Topic: mysqli works on command line but not in Apache

[rlecessi]

The following .php script works when I execute php from the
DOS prompt, but not from a Web browser:

<?php
$mysqli = new mysqli("my_ip_address", "root", "my_password",
"chapter7");
echo $mysqli->host_info . "\n";
$mysqli->real_query("SELECT name FROM hero");
$res = $mysqli->use_result();
while ($row = $res->fetch_assoc()) {
echo " name = " . $row['name'] . "\n";
}
?>

DOS>..\php connectMe.php
my_ip_address via TCP/IP
name = Green Lantern <- WORKS
name = Superman

But when I browse connectMe.php I get:

Fatal error: Class 'mysqli' not found in C:\Apache24\htdocs\CH8\connectMe.php on line 3

From PHP.ini:

extension_dir ="C:\PHP\ext"
extension=c:/php/ext/php_mysql.dll
extension=c:/php/ext/php_mysqli.dll
extension=c:/php/ext/php_pdo_mysql.dll

I copied libmysql.dll from MySQL to Apache\bin as per
Tue 13 Feb '07 Post (Apache mysqli installation problem),
but still not working.

Platform:
Apache 2.4.12 win32 VC11 update 4
PHP Version 5.6.7
MySQL Server 5.6
Windows 7 Ultimate Edition Service Pack 1) i586

Thanks in advance.

[James Blond]

create a script with

[rlecessi]

Thank you James.

The loaded configure command was as expected
(C:\PHP\php.ini).

I've posted the results at
http://www.ralphlecessitutor.com/phpinfo.pdf .
Please let me know if anything looks incorrect.

[James Blond]

Well

it seems mysql and mysqli are not enabled

change in your php.ini

[rlecessi]

Thank you James.

I was unable to find evidence of this in the phpinfo.
Could you help me find it?

I posted the php.ini specified by "loaded configuration file"
at http://www.ralphlecessitutor.com/php_ini.pdf.

I found the following at lines 890-895

extension=c:/php/ext/php_mysql.dll
extension=c:/php/ext/php_mysqli.dll
;extension=php_oci8_12c.dll ; Use with Oracle Database 12c Instant Client
extension=c:/php/ext/php_openssl.dll
;extension=php_pdo_firebird.dll
extension=c:/php/ext/php_pdo_mysql.dll

What am I missing?

[James Blond]

Did you restart apache? Cause these modules / extensions are not loaded!

See my phpinfo https://www.apachehaus.de/media/php_info.pdf

You will find a section with mysql and another one with mysqli

[rlecessi]

Looks like httpd -k restart doesn't update the extensions.
I stopped and started the Apache2.4 service in Windows Task
Manager (this gave Apache a new PID, which did not happen
during the restart). When I was done, the phpinfo looked like yours and the mysqli program worked in Apache.

Thank you so much for your help!

[James Blond]

Do not kill apache in the taskmanager. If you have installed it as a service

use

httpd -k stop
and
httpd -k start