[PHP-DB] Activating the mysql_clear_password plugin

2012-09-27 Thread Pierre-Gildas MILLON
Hi everyone, I need to use the mysql_clear_password plugin. I'm using the CentOS php 5.3.3 and manually recompiled the mysql mysqli extensions with the Oracle MySQL 5.5 libraries. According to the MySQL documentation (

Re: [PHP-DB] Activating the mysql_clear_password plugin

2012-09-27 Thread Niel Archer
Hi everyone, I need to use the mysql_clear_password plugin. I'm using the CentOS php 5.3.3 and manually recompiled the mysql mysqli extensions with the Oracle MySQL 5.5 libraries. According to the MySQL documentation (

Re: [PHP-DB] Activating the mysql_clear_password plugin

2012-09-27 Thread Niel Archer
Hi You could try using mysqli_options(), but I do not know if that supports this setting yet. The PHP documentation does not mention it, and I am unable to test it myself at the moment. Just occured to me, even if the setting is not directly supported yet, you can create a separate

[PHP-DB] Prepared Statements - Select - Bind Parameters

2012-09-27 Thread Ethan Rosenberg, PhD
Dear list - Thanks to all for your help. I hope [??] that this question will solve all the remaining problems. So that we are on the same page, here is what was previously stated. mysqli_stmt_bind_param expects three variables, in this order mysqli_stmt_bind_param($stmt, num, $a, $b,

Re: [PHP-DB] Activating the mysql_clear_password plugin

2012-09-27 Thread Pierre-Gildas MILLON
Hi, Many thanks for your quick answer. I tried what you suggest by modifying the phpMyAdmin code and it works great ! Thank you very much ! Le 27/09/2012 17:55, Niel Archer a écrit : Hi You could try using mysqli_options(), but I do not know if that supports this setting yet. The PHP

[PHP-DB] Prepared Statements - Select - Bind Parameters w/ correction

2012-09-27 Thread Ethan Rosenberg, PhD
Dear list - SEE CORRECTION IN $_POST VARIABLE BELOW. Thanks to all for your help. I hope [??] that this question will solve all the remaining problems. So that we are on the same page, here is what was previously stated. mysqli_stmt_bind_param expects three variables, in this order

[PHP-DB] Re: Prepared Statements - Select - Bind Parameters w/ correction

2012-09-27 Thread Jim Giner
On 9/27/2012 12:40 PM, Ethan Rosenberg, PhD wrote: Dear list - SEE CORRECTION IN $_POST VARIABLE BELOW. Thanks to all for your help. I hope [??] that this question will solve all the remaining problems. So that we are on the same page, here is what was previously stated.

Re: [PHP-DB] Prepared Statements - Select - Bind Parameters w/ correction

2012-09-27 Thread Matt Pelmear
Ethan, Please accept my apologies for the minor errors in the untested code I previously provided for your edification. Consider the following tested code: ?php /* CREATE TABLE test (id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT, data INT UNSIGNED); INSERT INTO test (data) VALUES