PHP 7 cannot find MySQLi

Question

For some reason, Windows 7 is unable to find the MySQL install. I've tried quite a few things to little or no avail.

I want to connect to my MySQL database with php using this code:

$con = new mysqli($server_name,$mysql_user,$mysql_pass,$db_name);
if($con->connect_errno) {
    echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
else{
    echo "<h3> Database Connected <h3>";
}

When I do connect, I receive this error message:

Fatal error: Uncaught Error: Class 'mysqli' not found in C:\Apache\htdocs\test_connection.php:8 Stack trace: #0 {main} thrown in C:\Apache\htdocs\test_connection.php on line 8

I ran this code and it returns that I don't have mysqli loaded:

if (!function_exists('mysqli_init') && !extension_loaded('mysqli')) {
    echo 'We don\'t have mysqli!!! ';
} else {
    echo 'Phew we have it!';
}

I have added

extension_dir = "C:\php\ext"

and

extension=php_mysqli.dll

to both php.ini-development and php.ini-production

I have my extensions in

C:\php\ext

and I also have the php_mysqli.dll file in that folder.

I have added the following code to the end of my httpd.exe file in Apache

LoadModule php7_module "c:/php/php7apache2_4.dll"
AddHandler application/x-httpd-php .php
PHPIniDir "c:/php"

What have your tried to do in relation to your PHP and Apache setup to resolve this? What does a test page for phpinfo(); report? — Drew
– Drew, Commented Jul 16, 2016 at 2:31
my extension dir is extension_dir = "C:/Apache24/~PHP_download/php-5.6.11-Win32-VC11-x64/ext/" — Drew
– Drew, Commented Jul 16, 2016 at 12:50
It takes hours sometimes. Mine took a while due to 32 bit vs 64 bit download discrepancies. total PITA. and the slashes going the "other" way — Drew
– Drew, Commented Jul 16, 2016 at 12:52

Priya · Accepted Answer · 2017-07-03 22:09:19Z

5

For me (on linux debian version) when I migrated from php5 + ubuntu 14 over to php7 + ubuntu 16, it was:

sudo apt-get install php-mysql

edited Jul 3, 2017 at 22:09

Priya

1,5541 gold badge14 silver badges33 bronze badges

answered Jul 3, 2017 at 18:06

jjX

611 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nisse Engström · Accepted Answer · 2016-10-10 17:51:12Z

4

Change

LoadModule php7_module "c:/php/php7apache2_4.dll"

to

LoadModule php7_module /php/php7apache2_4.dll

and

PHPIniDir "c:/php"

to

PHPIniDir /php

I fought this problem for days and the answer was that simple.

edited Oct 10, 2016 at 17:51

Nisse Engström

4,76323 gold badges29 silver badges44 bronze badges

answered Oct 10, 2016 at 9:21

Frank Hald

412 bronze badges

Collectives™ on Stack Overflow

PHP 7 cannot find MySQLi

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related