MySQLi - "Unknown command"

[rich1000]

I enabled MySQLi by adding the line:
"extension=php_mysqli.dll"
to php.ini.

I can create a MySQLi object. However, when I call its function, "prepare()", its error property is set to "Undefined function."

Is there a build problem with Xampp where MySQLi is not working correctly?
Is there some configuration problem?

thanks and please don't respond regarding the MySQL interface which is different.

[Wiedmann]

Can you give us a code example?

[rich1000]

This code outputs:
"Ping: 1
Prepare failed: Unknown command"

--------------

$mysqli = new mysqli("localhost", "root", "", "res1");

echo "<p>Ping: " . $mysqli->ping() . "</p>\n";

$stmt = $mysqli->prepare("SELECT * FROM Hotels");
if ( !$stmt )
echo "<p>Prepare failed: " . $mysqli->error . "</p>\n";

$mysqli->close();

[jjrohrer]

I was having the same problem. I'm trying to test some php code written by somebody else, and it requires mysqli. I added the single line:
(at line 615 in C:\xampp\apache\bin\php.ini)

Code: Select all

extension=php_mysqli.dll ;<-- jjr 1/19/2005) added in accordance with http://community.apachefriends.org/f/viewtopic.php?t=6893&highlight=mysqli


and the code seemingly works now.

[ulises]

I enabled MySQLi by adding the line:
"extension=php_mysqli.dll"
to php.ini.

I can create a MySQLi object. However, when I call its function, "prepare()", its error property is set to "Undefined function."

Is there a build problem with Xampp where MySQLi is not working correctly?
Is there some configuration problem?

thanks and please don't respond regarding the MySQL interface which is different.

hello to Activate mysqli instead of mysql steps to segir first sight in:

php.ini

that have descomentado this

;extension=php_mysqli.dll

has that descomentar this;

extension = php_mysqli. dll

Once it arrived aqui you have to publish the config.inc of phpmyadmin in this piece of codigo.

Has to remain in this manner:

$cfg['Servers'][$i]['extension'] = 'mysqli'; // The php MySQL extension to use ('mysql' or 'mysqli')