MySQLi not found error

I just deployed my website to a staging environment and am getting the following error:

Fatal error: Class 'mysqli' not found in D:\ClientSites\baileyboiler.com\www\new\php\db.php on line 11

At first I assumed that MySQLI was simply not installed, but running a phpinfo() reveals the following:

enter image description here

To me it looks like MySQLI is installed (though I could be reading this wrong). What should I do?

Code

class DB
{
    public static function GetConnection()
    {
        return new mysqli(DBHOST, DBUSER, DBPASSWORD, DEFAULTDATABASE);
    }
}

(line 11 is the return new mysql(...);)

Update

I added extension=php_mysqli.dll to my php.ini located at /Windows/php.ini (according to phpinfo(), this is the one being loaded):

Loaded Configuration File   C:\WINDOWS\php.ini

But the error persists. I know that mysqli.dll exists at C:\php\ext – because I can see the file. What now?

Here is Solutions:

We have many solutions to this problem, But we recommend you to use the first solution because it is tested & true solution that will 100% work for you.

Solution 1

I got the error corrected by enabling/editing the following config in php.ini:

1st (uncomment and add config):

include_path = "C:\php\includes"

2nd (uncomment):

extension_dir = "ext"

3rd (uncomment and edit config):

extension=D:/PHP/ext/php_mysql.dll
extension=D:/PHP/ext/php_mysqli.dll

Solution 2

Make sure is enabled under php.ini just find php_mysqli.dll and remove semi-colon and restart apache

Solution 3

Christian Mark is right but I think it need:

4rd Copy php.ini to “C:\Windows”. On my computer, need copy it to “C:\Windows”, Because phpinfo() output “Configuration File (php.ini) Path: C:\Windows” and “Loaded Configuration File: C:\Windows\php.ini”

5rd login out Computer and login in.

Then it work for me.

If I don’t do 4,5rd, It’s also don’t work for me, the phpinfo output include_path is not my configured. and extension_di also not. run the test also not work.

Note: Use and implement solution 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply