[PHP] Mysqli Extension

2013-08-19 Thread Ethan Rosenberg
Dear List - My mysqli extension seems to have gone away. $host = 'localhost'; $user = 'root'; $password = 'SdR3908'; echo hello2br /; var_dump(function_exists('mysqli_connect'));// this returns boo(false) $db = 'Store'; $cxn = mysqli_connect($host,$user,$password,$db); I tried to reinstall

Re: [PHP] Mysqli Extension

2013-08-19 Thread Matijn Woudt
On Mon, Aug 19, 2013 at 8:02 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: Dear List - My mysqli extension seems to have gone away. $host = 'localhost'; $user = 'root'; $password = 'SdR3908'; echo hello2br /; var_dump(function_exists('**mysqli_connect'));// this returns

Re: [PHP] Mysqli Extension

2013-08-19 Thread Curtis Maurand
Ethan Rosenberg wrote: Dear List - My mysqli extension seems to have gone away. $host = 'localhost'; $user = 'root'; $password = 'SdR3908'; echo hello2br /; var_dump(function_exists('mysqli_connect'));// this returns boo(false) $db = 'Store'; $cxn =

Re: [PHP] Mysqli Extension

2013-08-19 Thread Ashley Sheridan
Curtis Maurand cur...@maurand.com wrote: Ethan Rosenberg wrote: Dear List - My mysqli extension seems to have gone away. $host = 'localhost'; $user = 'root'; $password = 'SdR3908'; echo hello2br /; var_dump(function_exists('mysqli_connect'));// this returns boo(false) $db =

Re: [PHP] Mysqli Extension

2013-08-19 Thread Matijn Woudt
On Mon, Aug 19, 2013 at 8:55 PM, Ashley Sheridan a...@ashleysheridan.co.ukwrote: Curtis Maurand cur...@maurand.com wrote: Ethan Rosenberg wrote: Dear List - My mysqli extension seems to have gone away. $host = 'localhost'; $user = 'root'; $password = 'SdR3908'; echo

Re: [PHP] Mysqli Extension

2013-08-19 Thread Ashley Sheridan
Matijn Woudt tijn...@gmail.com wrote: On Mon, Aug 19, 2013 at 8:55 PM, Ashley Sheridan a...@ashleysheridan.co.ukwrote: Curtis Maurand cur...@maurand.com wrote: Ethan Rosenberg wrote: Dear List - My mysqli extension seems to have gone away. $host = 'localhost'; $user =

Re: [PHP] Mysqli Extension

2013-08-19 Thread Daniel P. Brown
On Aug 19, 2013 2:32 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: Dear List - My mysqli extension seems to have gone away. (REACTED) Remember: avoid putting passwords - especially for root users - on a public mailing list, which is also permanently archived. echo hello2br

Re: [PHP] Mysqli Extension

2013-08-19 Thread Matijn Woudt
On Mon, Aug 19, 2013 at 9:40 PM, Ashley Sheridan a...@ashleysheridan.co.ukwrote: Matijn Woudt tijn...@gmail.com wrote: On Mon, Aug 19, 2013 at 8:55 PM, Ashley Sheridan a...@ashleysheridan.co.ukwrote: Curtis Maurand cur...@maurand.com wrote: Ethan Rosenberg wrote: Dear List

Re: [PHP] Mysqli Extension

2013-08-19 Thread Curtis Maurand
Matijn Woudt wrote: On Mon, Aug 19, 2013 at 9:40 PM, Ashley Sheridan a...@ashleysheridan.co.ukwrote: Matijn Woudt tijn...@gmail.com wrote: On Mon, Aug 19, 2013 at 8:55 PM, Ashley Sheridan a...@ashleysheridan.co.ukwrote: Curtis Maurand cur...@maurand.com wrote: Ethan

Re: [PHP] Mysqli Extension

2013-08-19 Thread Lester Caine
Matijn Woudt wrote: apt-get install php5-mysql Just to elaborate on that ... php5-common and php5-cli does not include a number of modules that need to be loaded separately. Choosing one of the database modules is not the only thing that may need to be added to your list of additional

Re: [PHP] mysqli nested queries - maybe I'm rusty...

2013-04-02 Thread Jay Blanchard
Anyone? I have not been able to find a solution online. On 4/1/2013 11:33 AM, Jay Blanchard wrote: I am putting together an application where we are almost exclusively using stored procedures in MySQL because most of the heavy lifting (as it should be) is done in the database. I have exactly

[PHP] mysqli nested queries - maybe I'm rusty...

2013-04-01 Thread Jay Blanchard
I am putting together an application where we are almost exclusively using stored procedures in MySQL because most of the heavy lifting (as it should be) is done in the database. I have exactly one situation where I need to execute a stored procedure and while returning the results if I run a

[PHP] MySQLi

2012-12-20 Thread Stephen
I read about the subject in another thread. Where does PDO fit? That is what I have used for sometime. Am I good? -- Stephen -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] MySQLi

2012-12-20 Thread Daniel Brown
On Thu, Dec 20, 2012 at 12:18 PM, Stephen stephe...@rogers.com wrote: I read about the subject in another thread. Where does PDO fit? That is what I have used for sometime. Am I good? Right as rain. PDO is a preferred abstraction layer in PHP and isn't going anywhere anytime soon. --

[PHP] mysqli question

2011-11-12 Thread Peet Grobler
Not sure if this is the correct mailing list to be asking this question but here goes: I've got a prepared statement. $stmt = $dbh-prepare (insert into test values (?, ?)) or die (Error: . $dbh-error); $stmt-bind_param ('ii', $var1, $var2) or die (Error: . $dbh-error);

Re: [PHP] mysqli question

2011-11-12 Thread Tommy Pham
On Sat, Nov 12, 2011 at 6:15 AM, Peet Grobler p...@hivemind.net wrote: Not sure if this is the correct mailing list to be asking this question but here goes: I've got a prepared statement. $stmt = $dbh-prepare (insert into test values (?, ?))        or die (Error: . $dbh-error);

Re: [PHP] mysqli question

2011-11-12 Thread Peet Grobler
On 2011-11-13 1:42 AM, Tommy Pham wrote: or db_error ($dbh, $__FILE__, $__LINE__); __FILE__ are reserved keywords __LINE__. If you intended to use variables represent the similar meaning, the suggested approach would Yes, sorry, was a bit quick there - I'm using __FILE__ __LINE__ to

[PHP] mysqli sql question

2011-08-31 Thread Peet Grobler
Is it possible to get the actual sql that is being used to query or update the database? E.g $sth = $dbh-prepare (update table set field=?, field2=? where id=?); mysqli_bind_param ($sth, 'ssi', 'text1', 'text2', 10); $sth-execute(); Something like $sth-sql? Or $dbh-sql? I want to see update

Re: [PHP] mysqli sql question

2011-08-31 Thread John Black
On 31.08.2011 11:23, Peet Grobler wrote: Is it possible to get the actual sql that is being used to query or update the database? E.g $sth = $dbh-prepare (update table set field=?, field2=? where id=?); mysqli_bind_param ($sth, 'ssi', 'text1', 'text2', 10); $sth-execute(); Something like

Re: [PHP] mysqli sql question

2011-08-31 Thread James Yerge
On 08/31/2011 05:23 AM, Peet Grobler wrote: Is it possible to get the actual sql that is being used to query or update the database? E.g $sth = $dbh-prepare (update table set field=?, field2=? where id=?); mysqli_bind_param ($sth, 'ssi', 'text1', 'text2', 10); $sth-execute(); Something

Re: [PHP] mysqli sql question

2011-08-31 Thread Peet Grobler
On 8/31/2011 1:38 PM, John Black wrote: Hi Peet, not sure if there is a method to echo the sql but you can set your development MySQL server to log all queries to a log file. Use the log file with tail and you'll get a live view of all queries the server attempts to process. I already

RE: [PHP] mysqli sql question

2011-08-31 Thread Jen Rasmussen
, August 31, 2011 4:24 AM To: php-general@lists.php.net Subject: [PHP] mysqli sql question Is it possible to get the actual sql that is being used to query or update the database? E.g $sth = $dbh-prepare (update table set field=?, field2=? where id=?); mysqli_bind_param ($sth, 'ssi', 'text1', 'text2

[PHP] Mysqli error handling

2011-08-31 Thread Robert Williams
Okay, so I've finally got an opportunity to start converting our code to use Mysqli instead of the old mysql_* functions. Mysqli is new to me, but I thought things were going well until the first time I tried to run a query with a syntax error in it, and it threw up a PHP warning. Being that

[PHP] PHP mysqli help

2011-08-11 Thread Peet Grobler
So I have: $result = $dbh-query (select * from roles order by name); $row = mysqli_fetch_object ($result); function process_field ($which) { // This fails, I need to know how to do this the right way if ($row-may_$which == 'Y') { // Print stuff } else {

[PHP] mysqli fetch-fields returns blob for text

2011-01-04 Thread Mari Masuda
Hello, On http://www.php.net/manual/en/mysqli.constants.php there are some predefined constants for MYSQLI_TYPE_TINY_BLOB, MYSQLI_TYPE_MEDIUM_BLOB, MYSQLI_TYPE_LONG_BLOB, and MYSQLI_TYPE_BLOB. Through some experimentation I have found that fields in my MySQL database that are declared as

Re: [PHP] mysqli procedural calls and manual entries ?

2010-03-15 Thread Daniel Egeberg
On Fri, Mar 12, 2010 at 08:49, Per Jessen p...@computer.org wrote: I run a local mirror of the PHP manual, and I most often go straight to the Search for box to look up the format of a function.  With the mysqli functions, I've found than many of them simply aren't available that way.  E.g.

Re: [PHP] mysqli procedural calls and manual entries ?

2010-03-15 Thread Daniel Brown
On Fri, Mar 12, 2010 at 06:48, Daniel Egeberg degeb...@php.net wrote: Hi Per, The manual already supports that. If you install the sqlite extension on your webserver, it should work. Dan; The question wasn't whether or not it supports that kind of lookup, but rather why it's not

Re: [PHP] mysqli procedural calls and manual entries ?

2010-03-12 Thread Daniel Brown
On Fri, Mar 12, 2010 at 02:49, Per Jessen p...@computer.org wrote: I run a local mirror of the PHP manual, and I most often go straight to the Search for box to look up the format of a function.  With the mysqli functions, I've found than many of them simply aren't available that way.  E.g.

Re: [PHP] mysqli procedural calls and manual entries ?

2010-03-12 Thread Per Jessen
Daniel Brown wrote: On Fri, Mar 12, 2010 at 02:49, Per Jessen p...@computer.org wrote: I run a local mirror of the PHP manual, and I most often go straight to the Search for box to look up the format of a function.  With the mysqli functions, I've found than many of them simply aren't

[PHP] mysqli procedural calls and manual entries ?

2010-03-11 Thread Per Jessen
I run a local mirror of the PHP manual, and I most often go straight to the Search for box to look up the format of a function. With the mysqli functions, I've found than many of them simply aren't available that way. E.g. mysqli_connect() - Sorry, but the function mysqli_connect is not in the

[PHP] MySQLi and prepared statements

2009-10-19 Thread Chris W
If I am using the mysqli extension and prepared statements, after I execute bind_param, is there a away to print the actual query that gets sent to the server? -- Chris W KE5GIX Protect your digital freedom and privacy, eliminate DRM, learn more at

Re: [PHP] mysqli, prepare and fetch_row

2008-10-23 Thread Marten Lehmann
Hi, Kyle Terry wrote: Why don't you want to bind the results? thats poor programming style and bad performance (dozends of bind calls). Since there is a method fetch_row(), then why shouldn't I use it? It is a bit strange that I cannot find any example for its use besides in conjunction

[PHP] mysqli, prepare and fetch_row

2008-10-22 Thread Marten Lehmann
Hello, I have a small piece of code where I'm trying to use mysqli with a prepare-statement. I don't want to bind variables for the fetch, instead I want to use something like list($question) = $stmt-fetch_row(); And this fetch_row should exist according to the documentation. But while

Re: [PHP] mysqli, prepare and fetch_row

2008-10-22 Thread Kyle Terry
You prepare the statement, execute it then use -fetch() to get the data. On Oct 22, 2008, at 1:36 PM, Marten Lehmann [EMAIL PROTECTED] wrote: Hello, I have a small piece of code where I'm trying to use mysqli with a prepare-statement. I don't want to bind variables for the fetch,

Re: [PHP] mysqli, prepare and fetch_row

2008-10-22 Thread Marten Lehmann
Hi, You prepare the statement, execute it then use -fetch() to get the data. but the documentation says, that -fetch() is only to fetch data to variables that have been bound with bind_result() before. But I want to use fetch_row() instead. Regards Marten -- PHP General Mailing List

Re: [PHP] Mysqli issue

2008-09-12 Thread Chris
Jason Pruim wrote: No political undertones in this one I promise! :) Attempting to setup a prepared statement in php that will update a record in a mysql database using mysqli Here is the relevant code: $stmt = mysqli_stmt_init($link); mysqli_stmt_prepare($stmt, UPDATE purl.schreur

[PHP] Mysqli issue

2008-09-11 Thread Jason Pruim
No political undertones in this one I promise! :) Attempting to setup a prepared statement in php that will update a record in a mysql database using mysqli Here is the relevant code: $stmt = mysqli_stmt_init($link); mysqli_stmt_prepare($stmt, UPDATE purl.schreur (FName, LName,

Re: [PHP] Mysqli issue

2008-09-11 Thread Stut
On 11 Sep 2008, at 16:15, Jason Pruim wrote: Attempting to setup a prepared statement in php that will update a record in a mysql database using mysqli Here is the relevant code: $stmt = mysqli_stmt_init($link); mysqli_stmt_prepare($stmt, UPDATE purl.schreur (FName, LName, email,

Re: [PHP] Mysqli issue

2008-09-11 Thread Wolf
Jason Pruim [EMAIL PROTECTED] wrote: No political undertones in this one I promise! :) Attempting to setup a prepared statement in php that will update a record in a mysql database using mysqli Here is the relevant code: $stmt = mysqli_stmt_init($link);

Re: [PHP] Mysqli issue

2008-09-11 Thread Jason Pruim
On Sep 11, 2008, at 11:29 AM, Wolf wrote: Jason Pruim [EMAIL PROTECTED] wrote: No political undertones in this one I promise! :) Attempting to setup a prepared statement in php that will update a record in a mysql database using mysqli Here is the relevant code: $stmt =

Re: [PHP] Mysqli issue

2008-09-11 Thread Stut
On 11 Sep 2008, at 16:29, Wolf wrote: Jason Pruim [EMAIL PROTECTED] wrote: No political undertones in this one I promise! :) Attempting to setup a prepared statement in php that will update a record in a mysql database using mysqli Here is the relevant code: $stmt =

Re: [PHP] Mysqli issue

2008-09-11 Thread Wolf
!-- SNIP -- Attempting to setup a prepared statement in php that will update a record in a mysql database using mysqli Here is the relevant code: $stmt = mysqli_stmt_init($link); mysqli_stmt_prepare($stmt, UPDATE purl.schreur (FName, LName, email, phone, record, subscribed,

Re: [PHP] Mysqli issue

2008-09-11 Thread Jason Pruim
On Sep 11, 2008, at 11:23 AM, Stut wrote: On 11 Sep 2008, at 16:15, Jason Pruim wrote: Attempting to setup a prepared statement in php that will update a record in a mysql database using mysqli Here is the relevant code: $stmt = mysqli_stmt_init($link); mysqli_stmt_prepare($stmt,

Re: [PHP] Mysqli issue

2008-09-11 Thread Stut
On 11 Sep 2008, at 17:08, Jason Pruim wrote: On Sep 11, 2008, at 11:23 AM, Stut wrote: On 11 Sep 2008, at 16:15, Jason Pruim wrote: Attempting to setup a prepared statement in php that will update a record in a mysql database using mysqli Here is the relevant code: $stmt =

Re: [PHP] Mysqli issue

2008-09-11 Thread Andrew Ballard
On Thu, Sep 11, 2008 at 12:08 PM, Jason Pruim [EMAIL PROTECTED] wrote: On Sep 11, 2008, at 11:23 AM, Stut wrote: On 11 Sep 2008, at 16:15, Jason Pruim wrote: Attempting to setup a prepared statement in php that will update a record in a mysql database using mysqli Here is the relevant

[PHP] Mysqli::prepare + select ... where ... in + array

2008-08-26 Thread Hans Henrik Petersen
Hey there I have been toying around with the following code for a few days: ?php //Gets the tokens defined in the array $tokensToGet, with the language defined by $languageId public static function GetTokens($tokensToGet, $languageId) { $query = @SELECT Name,

[PHP] Mysqli::prepare + select ... where ... in + array

2008-08-26 Thread hanshenp
Hey there I have been toying around with the following code for a few days: ?php //Gets the tokens defined in the array $tokensToGet, with the language defined by $languageId public static function GetTokens($tokensToGet, $languageId) { $query = @SELECT Name, Value FROM

[PHP] Fwd: How to enable php-mysqli on linux

2008-07-08 Thread Kapil Kapil
Hi How can we enable php-mysqli support on linux machine using yum etc., without reinstalling php again? Also how to check it - Is php-mysqli package is present or not? Thanks Kapil

Re: [PHP] Fwd: How to enable php-mysqli on linux

2008-07-08 Thread Per Jessen
Kapil Kapil wrote: Hi How can we enable php-mysqli support on linux machine using yum etc., without reinstalling php again? Just install the appropriate package. Also how to check it - Is php-mysqli package is present or not? Check output from phpinfo(). /Per Jessen, Zürich -- PHP

Re: [PHP] Mysqli support - test or complain? [SOLVED]

2007-12-12 Thread Per Jessen
Robert Cummings wrote: I can't remember what sort of environment the OP was in, but if any sort of organised testing is done, the use of two different APIs will just about double the test-effort. Which is why I still think the best option is to mandate _one_ of the APIs and choose your

Re: [PHP] Mysqli support - test or complain? [SOLVED]

2007-12-12 Thread Nathan Nobbe
On Dec 12, 2007 4:47 AM, Per Jessen [EMAIL PROTECTED] wrote: Robert Cummings wrote: I can't remember what sort of environment the OP was in, but if any sort of organised testing is done, the use of two different APIs will just about double the test-effort. Which is why I still think the

Re: [PHP] Mysqli support - test or complain? [SOLVED]

2007-12-12 Thread Robert Cummings
On Wed, 2007-12-12 at 10:47 +0100, Per Jessen wrote: Robert Cummings wrote: I can't remember what sort of environment the OP was in, but if any sort of organised testing is done, the use of two different APIs will just about double the test-effort. Which is why I still think the best

Re: [PHP] Mysqli support - test or complain? [SOLVED]

2007-12-11 Thread Richard Heyes
You use a session variable for that? Why not? That's entirely the wrong place to store something like which database API is installed. Not really. You could even wrap a function called (for example) Feature() around it. It should a class variable or global configuration variable. Heck,

Re: [PHP] Mysqli support - test or complain? [SOLVED]

2007-12-11 Thread Stut
Richard Heyes wrote: You use a session variable for that? Why not? Because it's not user data, it's server data. That's entirely the wrong place to store something like which database API is installed. Not really. You could even wrap a function called (for example) Feature() around it.

Re: [PHP] Mysqli support - test or complain? [SOLVED]

2007-12-11 Thread Jochem Maas
Stut wrote: Richard Heyes wrote: You use a session variable for that? Why not? Because it's not user data, it's server data. That's entirely the wrong place to store something like which database API is installed. Not really. You could even wrap a function called (for example)

Re: [PHP] Mysqli support - test or complain? [SOLVED]

2007-12-11 Thread Per Jessen
Stut wrote: However, I'd expect a stat on that file will be more expensive than calling extension_loaded. Difficult to say, but a stat() is cheap, especially if the inode is cached already. /Per Jessen, Zürich -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP] Mysqli support - test or complain? [SOLVED]

2007-12-11 Thread Richard Heyes
Because it's not user data, it's server data. So? It's there - use it. That's entirely the wrong place to store something like which database API is installed. Not really. You could even wrap a function called (for example) Feature() around it. Yeah, really. Sessions are for user data.

Re: [PHP] Mysqli support - test or complain? [SOLVED]

2007-12-11 Thread Stut
Richard Heyes wrote: Because it's not user data, it's server data. So? It's there - use it. So are cookies, would you stuff this into a cookie? No, because that's not what cookies are there for. Because it's there is never a good reason to do something. That's entirely the wrong place

Re: [PHP] Mysqli support - test or complain? [SOLVED]

2007-12-11 Thread Robert Cummings
On Tue, 2007-12-11 at 15:25 +, Stut wrote: Richard Heyes wrote: Because it's not user data, it's server data. So? It's there - use it. So are cookies, would you stuff this into a cookie? No, because that's not what cookies are there for. Because it's there is never a good

Re: [PHP] Mysqli support - test or complain? [SOLVED]

2007-12-11 Thread Richard Heyes
So? It's there - use it. So are cookies, would you stuff this into a cookie? No, because that's not what cookies are there for. Not because it's not what cookies are for - but because sessions are a more efficient and easier to use storage medium. You could potentially be pointlessly

Re: [PHP] Mysqli support - test or complain? [SOLVED]

2007-12-11 Thread Richard Heyes
Sre, sessions are for whatever you choose to put in them. That's like saying bodies are for whatever a crazed murderer chooses to put in them... No it's not. the statement is true, but it's not optimal. Real life is rarely optimal. -- Richard Heyes

Re: [PHP] Mysqli support - test or complain? [SOLVED]

2007-12-11 Thread Robert Cummings
On Tue, 2007-12-11 at 16:31 +, Richard Heyes wrote: Sre, sessions are for whatever you choose to put in them. That's like saying bodies are for whatever a crazed murderer chooses to put in them... No it's not. Yes it is. Neither is a good argument. the statement is true,

Re: [PHP] Mysqli support - test or complain? [SOLVED]

2007-12-11 Thread Richard Heyes
Real life is rarely optimal. That's not a valid excuse for taking the sloppy pig route to development. Sloppy pig's give conscientious developers a bad name. And when they use PHP to create their slop, they give PHP a bad name. Well I err towards actually doing something useful. Businesses

Re: [PHP] Mysqli support - test or complain? [SOLVED]

2007-12-11 Thread Stut
Richard Heyes wrote: Real life is rarely optimal. That's not a valid excuse for taking the sloppy pig route to development. Sloppy pig's give conscientious developers a bad name. And when they use PHP to create their slop, they give PHP a bad name. Well I err towards actually doing something

Re: [PHP] Mysqli support - test or complain? [SOLVED]

2007-12-11 Thread Richard Heyes
I don't see a reason to compromise. It would take no longer to call extension_loaded on each page request than it will to put the variable in the session. You're right in saying that there's a balance to be struck, but in this particular case I personally see a right way and a wrong way and no

Re: [PHP] Mysqli support - test or complain? [SOLVED]

2007-12-11 Thread Per Jessen
Stut wrote: I couldn't care less what your domain name is, you're still advocating a poor choice IMHO. I have been trying hard not to join this thread, but ... apart from the principle, what's _really_ so poor about it? Having to write application code that needs to work with two different

Re: [PHP] Mysqli support - test or complain? [SOLVED]

2007-12-11 Thread Robert Cummings
On Tue, 2007-12-11 at 17:01 +, Richard Heyes wrote: Real life is rarely optimal. That's not a valid excuse for taking the sloppy pig route to development. Sloppy pig's give conscientious developers a bad name. And when they use PHP to create their slop, they give PHP a bad name.

Re: [PHP] Mysqli support - test or complain? [SOLVED]

2007-12-11 Thread Robert Cummings
On Tue, 2007-12-11 at 18:14 +0100, Per Jessen wrote: Stut wrote: I couldn't care less what your domain name is, you're still advocating a poor choice IMHO. I have been trying hard not to join this thread, but ... apart from the principle, what's _really_ so poor about it? Having to

Re: [PHP] Mysqli support - test or complain? [SOLVED]

2007-12-11 Thread Robert Cummings
On Tue, 2007-12-11 at 22:11 +0100, Per Jessen wrote: Robert Cummings wrote: On Tue, 2007-12-11 at 18:14 +0100, Per Jessen wrote: I have been trying hard not to join this thread, but ... apart from the principle, what's _really_ so poor about it? Having to write application code that

Re: [PHP] Mysqli support - test or complain? [SOLVED]

2007-12-11 Thread Nathan Nobbe
On Dec 11, 2007 4:11 PM, Per Jessen [EMAIL PROTECTED] wrote: I can't remember what sort of environment the OP was in, but if any sort of organised testing is done, the use of two different APIs will just about double the test-effort. Which is why I still think the best option is to mandate

Re: [PHP] Mysqli support - test or complain? [SOLVED]

2007-12-11 Thread Per Jessen
Robert Cummings wrote: On Tue, 2007-12-11 at 18:14 +0100, Per Jessen wrote: I have been trying hard not to join this thread, but ... apart from the principle, what's _really_ so poor about it? Having to write application code that needs to work with two different APIs is poor enough, using

Re: [PHP] Mysqli support - test or complain? [SOLVED]

2007-12-11 Thread Larry Garfield
On Tuesday 11 December 2007, Per Jessen wrote: Stut wrote: I couldn't care less what your domain name is, you're still advocating a poor choice IMHO. I have been trying hard not to join this thread, but ... apart from the principle, what's _really_ so poor about it? Having to write

[PHP] Mysqli support - test or complain?

2007-12-10 Thread Dave M G
PHP List, Based on what seemed to be good advice to switch to using mysqli for interacting with a MySQL database, I built a content management system that uses mysqli for all it's calls. It works great on a lot of my servers. However, I just discovered that one web hosting service I use

Re: [PHP] Mysqli support - test or complain?

2007-12-10 Thread Per Jessen
Dave M G wrote: One is based on the assumption that mysqli is as likely not to be available as it is to be installed. In this case I should write my scripts to test whether it exists and then use either mysqli or straight mysql commands as appropriate. If this is the way to go, what do I do

Re: [PHP] Mysqli support - test or complain?

2007-12-10 Thread Richard Heyes
One is based on the assumption that mysqli is as likely not to be available as it is to be installed. In this case I should write my scripts to test whether it exists and then use either mysqli or straight mysql commands as appropriate. If this is the way to go, what do I do to test for the

RE: [PHP] Mysqli support - test or complain?

2007-12-10 Thread Andrés Robinet
-Original Message- From: Per Jessen [mailto:[EMAIL PROTECTED] Dave M G wrote: One is based on the assumption that mysqli is as likely not to be available as it is to be installed. In this case I should write my scripts to test whether it exists and then use either mysqli or

Re: [PHP] Mysqli support - test or complain?

2007-12-10 Thread Dave M G
Richard, Per, Andres, Thank you for responding. If it were entirely my web site to dictate what to do with, I would just switch for a server that has mysqli available to me. However, in this one case, the web site is owned by a small, not very profitable group that has reasons to stay with

Re: [PHP] Mysqli support - test or complain?

2007-12-10 Thread Zoltán Németh
2007. 12. 10, hétfő keltezéssel 21.58-kor Dave M G ezt írta: Richard, Per, Andres, Thank you for responding. If it were entirely my web site to dictate what to do with, I would just switch for a server that has mysqli available to me. However, in this one case, the web site is owned by

Re: [PHP] Mysqli support - test or complain?

2007-12-10 Thread Per Jessen
Dave M G wrote: Richard said: Alter your program to support both - use mysqi if it's avilable, mysql if it's not. How exactly do I test for the presence of mysqli from within a script? Or are you saying I have two different versions of my script? I think you can test for the

Re: [PHP] Mysqli support - test or complain?

2007-12-10 Thread Richard Heyes
How exactly do I test for the presence of mysqli from within a script? IIRC there's a function called extension_loaded(). Or something similar. Or are you saying I have two different versions of my script? Not at all. Taking PEAR::DB for example, you could test for the existence of

Re: [PHP] Mysqli support - test or complain?

2007-12-10 Thread Per Jessen
Richard Heyes wrote: another. This is one of the reasons abstraction layers exist. Which brings us to alternative #3 - odbc. /Per Jessen, Zürich -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Mysqli support - test or complain?

2007-12-10 Thread Daniel Brown
On Dec 10, 2007 3:16 AM, Dave M G [EMAIL PROTECTED] wrote: Which assumption should I be proceeding with? Rather than assume (because we all know what happens then), why not build for both scenarios? Here's an example of one way ? // inc/include_files.php # # Includes all files

Re: [PHP] Mysqli support - test or complain?

2007-12-10 Thread Chris
Per Jessen wrote: Richard Heyes wrote: another. This is one of the reasons abstraction layers exist. Which brings us to alternative #3 - odbc. That's probably less likely to be available than mysqli. If you're targetting php5 then you could use pdo::mysql as well (and there's even the

Re: [PHP] Mysqli support - test or complain?

2007-12-10 Thread Larry Garfield
On Monday 10 December 2007, Dave M G wrote: One is based on the assumption that mysqli is as likely not to be available as it is to be installed. In this case I should write my scripts to test whether it exists and then use either mysqli or straight mysql commands as appropriate. If this is

Re: [PHP] Mysqli support - test or complain? [SOLVED]

2007-12-10 Thread Dave M G
Zoltan, Per, Richard, Chris, Daniel, Larry, Thank you for responding. I have created a method in the class that handles my database connections that will first test on extension_loaded(mysqli) before connecting to the database. Then I store the result in a session variable for reference, so

Re: [PHP] Mysqli support - test or complain? [SOLVED]

2007-12-10 Thread Robert Cummings
On Tue, 2007-12-11 at 13:02 +0900, Dave M G wrote: Zoltan, Per, Richard, Chris, Daniel, Larry, Thank you for responding. I have created a method in the class that handles my database connections that will first test on extension_loaded(mysqli) before connecting to the database. Then

Re: [PHP] Mysqli insert / OO Design Problem - Call to a member function bind_param() on a non-object in...

2007-05-17 Thread Robin Vickery
On 16/05/07, Lee PHP [EMAIL PROTECTED] wrote: /** Insert record. */ public function insert() { $sql = INSERT INTO table ( . field_1, . field_2, . field_3) . ?, . ?, . ?);

[PHP] Mysqli insert / OO Design Problem - Call to a member function bind_param() on a non-object in...

2007-05-16 Thread Lee PHP
Hi there, I'm new to OO-PHP and have encountered a problem that I just can't figure out. I have a class called DBAccess that extends mysqli. In a nutshell, it looks like this: class DBAccess extends mysqli { private static $instance; private static $preferences; /** Create an instance

Re: [PHP] Mysqli insert / OO Design Problem - Call to a member function bind_param() on a non-object in...

2007-05-16 Thread Chris
Lee PHP wrote: Hi there, I'm new to OO-PHP and have encountered a problem that I just can't figure out. I have a class called DBAccess that extends mysqli. In a nutshell, it looks like this: snip If I execute the following code: $conn = DBAccess::getInstance(); Does that give you an

[PHP] php / mysqli problem

2006-02-06 Thread jonathan
I have a couple of questions about php and accessing mysql 4.1 via the mysqli interface. I get the following warning on a script: bWarning/b: mysqli::mysqli() [a href='function.mysqli/a]: User jt_select has already more than 'max_user_connections' active connections in but this

Re: [PHP] mysqli bind_param and store_result don't work well together

2006-01-13 Thread anirudh dutt
On 1/5/06, Curt Zirzow [EMAIL PROTECTED] wrote: On Wed, Jan 04, 2006 at 12:31:02AM +0530, anirudh dutt wrote: hi the subject is pretty much what the problem is. if i use $st1 = $sql-stmt_init(); // $sql is a mysqli obj/conn $st1-prepare(select `num` from `activity` where `id` = ?);

Re: [PHP] mysqli bind_param and store_result don't work well together

2006-01-13 Thread Curt Zirzow
On Sat, Jan 14, 2006 at 03:18:55AM +0530, anirudh dutt wrote: On 1/5/06, Curt Zirzow [EMAIL PROTECTED] wrote: On Wed, Jan 04, 2006 at 12:31:02AM +0530, anirudh dutt wrote: hi the subject is pretty much what the problem is. if i use $st1 = $sql-stmt_init(); // $sql is a mysqli

Re: [PHP] mysqli bind_param and store_result don't work well together

2006-01-04 Thread Curt Zirzow
On Wed, Jan 04, 2006 at 12:31:02AM +0530, anirudh dutt wrote: hi the subject is pretty much what the problem is. if i use $st1 = $sql-stmt_init(); // $sql is a mysqli obj/conn $st1-prepare(select `num` from `activity` where `id` = ?); $st1-bind_param('s', $myid); $myid =

[PHP] mysqli bind_param and store_result don't work well together

2006-01-03 Thread anirudh dutt
hi the subject is pretty much what the problem is. if i use $st1 = $sql-stmt_init(); // $sql is a mysqli obj/conn $st1-prepare(select `num` from `activity` where `id` = ?); $st1-bind_param('s', $myid); $myid = '3f6d017d3e728b057bcc082a7db75a57'; // forcing value to check $st1-execute();

Re: [PHP] mysqli class not found

2005-12-29 Thread Erik Saline
PROTECTED] To: Erik Saline [EMAIL PROTECTED] Cc: php-general@lists.php.net Sent: Wednesday, December 28, 2005 6:56 PM Subject: Re: [PHP] mysqli class not found you are not missing anything, you are actually adding to much. Using new is for making objects, if you take away the new in the $result

Re: [PHP] mysqli class not found

2005-12-29 Thread PHP Superman
added extenstion=mysqli.so to my php.ini Erik - Original Message - From: PHP Superman [EMAIL PROTECTED] To: Erik Saline [EMAIL PROTECTED] Cc: php-general@lists.php.net Sent: Wednesday, December 28, 2005 6:56 PM Subject: Re: [PHP] mysqli class not found you are not missing

Re: [PHP] mysqli class not found

2005-12-29 Thread John Nichel
PHP Superman wrote:* What OS are you using? I think that you entered the wrong filename. for windows i use php_mysqli.dll . Somewhere in php.ini there is a list of extensions you can use, uncomment the php_mysqli.dll , copy php_mysqli.dll to the php install directory and change the php.ini

Re: [PHP] mysqli class not found

2005-12-29 Thread John Nichel
PHP Superman wrote: Hold on, I heard that you can't run the mysql and mysqli php extensions , try removing the mysql extension if my other advice doesen't work snip Please reply to the list. You can compile php with both. From the manual : http://us2.php.net/mysqli If you would like to

Re: [PHP] mysqli module in php 4

2005-12-28 Thread Paul Waring
On 12/28/05, Bagus Nugroho [EMAIL PROTECTED] wrote: Is mysqli module enable by default on php 4 as mysql module. No, because it's a PHP5 module (if you look at the documentation for it, all the php.ini settings for it have only been available since 5.0.0). If not enable by default, where I can

[PHP] mysqli class not found

2005-12-28 Thread Erik Saline
- Original Message - From: Erik Saline To: php-general@lists.php.net Sent: Wednesday, December 28, 2005 1:08 PM I installed Apache, PHP, and Mysql during the Fedora Core 4 installation. PHP 5.0.4 MYSQL 4.1.14 I used php -i to show that mysql and mysqli were installed. Configure

  1   2   >