How to solve Fatal error Class MySQLi not found

Question

I am doing a tutorial and am getting this error      Fatal error  Class  MySQLi  not found  LONG URL  on line 8   The code on line 8 is    mysqli   new MySQLi  db server   db user   db pass   db name     I saw online someone said to see if it was turned on in my phpinfo    but there wasn t anything listed in there under for  mysqli    Also  I am running PHP version 5 2 5

User · Answer

My OS is Ubuntu  I solved this problem by using   sudo apt-get install php5-mysql

User · Answer

For anyone using docker  I ran into this issue  and resolved it by using my own Dockerfile instead of the php fpm image   FROM php fpm  RUN docker-php-ext-install mysqli

User · Answer

If you re calling  new mysqli      from within a class that is namespaced  you might see a similar error Fatal error  Class  foo bar mysqli  not found in  The way to fix this is to explicitly set it to the root namespace with a preceding backslash like so    lt  php   mysqli   new  MySQLi  db server   db user   db pass   db name

User · Answer

I thought I might help anybody with the same problem using Namesco servers  I have been trying to fix this problem after moving a database from my local server on home pc to namesco  They would not assist they said it was a coding issue   However  it was simple to fix from their CPANEl LINUX hosting interface  Click on php  then click on php modules and from their list of preinstalled modules just click the box for mysqli  Then click save   No need to change code if it worked s  on another server    Unfortunately  their support articles were a waste of time  After reading this I went to admin interface with a new determination

User · Answer

Sounds like you just need to install MySQLi   If you think you ve done that and still have a problem  please post your operating system and anything else that might help diagnose it further

User · Answer

In addition to uncommenting the php mysqli dll extension in php ini  also uncomment the extension dir directive in php ini and specify your location    extension dir    C  software php dist ext    This made it work for me

User · Answer

install phpXX-extension by PHP  In my FreeBSD s case  pkg install php74-extensions

User · Answer

I m using xampp and my problem was fixed once i rename  extension dir    quot ext quot   to extension dir    quot C  xampp php ext quot   PS  Don t forget to restart apache after making this change

User · Answer

If you are on Docker     Inside php-container RUN    docker-php-ext-install mysqli   apachectl restart

User · Answer

I found a solution for this problem after a long analysing procedure  After properly testing my php installation with the command line features I found out that the php is working well and could work with the mysql database  Btw  you can run code-files with php code with the command   php -f filename php So I realized  it must something be wrong with the Apache  I made a file with just the phpinfo   function inside  Here I saw  that in the line Loaded Configuration File my config file was not loaded  instead there was mentioned  none   Finally I found within the Apache configuration the entry  lt IfModule php5 module gt      PHPINIDir  quot C  xampp php quot   lt  IfModule gt   But I ve installed the PHP 7 and so the Apache could not load the php ini file because there was no entry for that  I added  lt IfModule php7 module gt      PHPINIDir  quot C  xampp php quot   lt  IfModule gt   and after restart Apache all works well  These code blocks above I found in my httpd-xampp conf file   May it is somewhere else at your configuration  In the same file I had changed before the settings for the php 7 as replacement for the php 5 version      PHP-Module setup    LoadFile  quot C  xampp php php5ts dll quot   LoadModule php5 module  quot C  xampp php php5apache2 4 dll quot  LoadFile  quot C  xampp php php7ts dll quot  LoadModule php7 module  quot C  xampp php php7apache2 4 dll quot   As you can see I have the xampp package installed but this problem was just on the Apache side

User · Answer

on ubuntu   sudo apt-get install php-mysql sudo service apache2 restart

User · Answer

If you are on Ubuntu  run   sudo apt-get install php-mysqlnd

User · Answer

I checked all above and it didn t work for me   There are some steps I found   I used PHP Version 5 5 9-1ubuntu4 17 on Ubuntu 14 04  First check the folder   ls  etc php5 mods-available  json ini  mcrypt ini  mysqli ini  mysql ini  mysqlnd ini  opcache ini  pdo ini  pdo mysql ini  readline ini  xcache ini   If it did not contain mysqli ini  read other answer for installing it   Open php ini find extension dir   In my case   I must set extension dir    usr lib php5 20121212  And restart apache2    ect init d apache2 restart

User · Answer

Open your PHP folder  Find php ini-development and open it  Find  extension mysqli delete the   symbol save file and change the file extension from php ini-development to php ini Restart the server and test the code       if   function exists  mysqli init    amp  amp   extension loaded  mysqli                    echo  We don  t have mysqli               else              echo  mysqli is installed            if it not working  change both extension dir in php ini from  quot ext quot  to  quot c  php ext quot  and extension mysqli to extension php mysqli dll then test again Remember to reset the server every time you test

User · Answer

In php ini   extension dir   quot c  wamp64 bin php php7 4 9 ext  quot   Make sure the PHP version is correct

User · Answer

Seems like problem with your installation     Have you installed MySQLi   Have you activated it in php ini  Restarted Apache and or PHP-FPM    http   www php net manual en mysqli installation php

User · Answer

On a fresh install of PHP  remove   before extension dir in php ini

User · Answer

on Debian 10   apt install php-mysql   etc init d apache2 restart

User · Answer

You can check if the mysqli libraries are present by executing this code   if   function exists  mysqli init    amp  amp   extension loaded  mysqli          echo  We don  t have mysqli        else       echo  Phew we have it

User · Answer

How to Enable mysqli in php ini  Edit uncomment by removing     colon  the following config in php ini  1st  uncomment and add config   include path    quot C  php includes quot   2nd  uncomment   extension dir    quot ext quot   3rd  uncomment and edit config   extension C  PHP ext php mysql dll extension C  PHP ext php mysqli dll   Restart the IIS server Make sure that mysql is running on the system   How to load php ini file  Rename any one of the file php ini-production php ini-development to php ini from C  PHP note now the extention will be ini i e  quot php ini quot    After renaming to php ini file restart server See the changes in http   localhost phpinfo php

User · Answer

The PHP zip includes most of the commonly used extensions    dll on windows such as php mysqli dll  under the  ext directory  however they are not enabled by default  You might be getting this Fatal Error when trying to use MySQLi         Fatal error  Uncaught Error  Class  mysqli  not found in C  myProject  class Database php on line 24   To enable extensions  open php ini  you might need to first copy php ini-development as php ini   and un-comment  or add  these two lines   extension dir    ext    And any particular extensions you are getting Fatal Errors for  i e  for mysqli   extension mysqli

User · Answer

Some distributions  such as Gentoo  support multiple installations of PHP  and you have to make sure you re using one with mysqli installed and enabled   On Gentoo  I had installed a new PHP  with the mysqli USE flag enabled   but I needed to activate the new version of PHP  since the old one must have been missing mysqli      eselect php list apache2    1    php5 3      2    php5 5   eselect php set apache2 2 You have to run   etc init d apache2 restart  for the changes to take effect    etc init d apache2 restart

User · Answer

lt  php     If the error is due to calling mysqli in a class         class dbconnect extends mysqli           private  host    localhost           private  user    root           private  pass               private  db    test            public function   construct                 parent    construct  this- gt host   this- gt user   this- gt pass   this- gt db                if  mysqli connect error                      die  Connect Error      mysqli connect errno                                mysqli connect error                                     gt

[php] How to solve "Fatal error: Class 'MySQLi' not found"?

Examples related to php

Examples related to mysqli