Solution to PHP Fatal error: Call to undefined method mysqli::stmt_init()

When using PHP for MySQL database operations, we often encounter the error "PHP Fatal error: Call to undefined method mysqli::stmt_init()". This error is usually due to PHP not loading the MySQL extension library or MySQL correctly. Caused by incompatible extension library versions. In this article we will explain how to solve this problem.

Step one: Check whether PHP correctly loads the MySQL extension library

In PHP, we can view the current PHP configuration information through the phpinfo() function. Open the terminal and enter the following command to view the current PHP configuration information:

php -r "phpinfo();"

After executing this command, the PHP configuration information will be output. We need to confirm whether the MySQL extension library has been loaded.

You can search for mysqli through Ctrl F. If it is not found, it means that the MySQL extension library is not loaded. You need to install the MySQL extension library first.

Step 2: Install the MySQL extension library

According to your actual situation, you can install the MySQL extension library in the following two ways:

Method 1: Use the command line Install the MySQL extension library

Ubuntu/Debian system

sudo apt-get update
sudo apt-get install php-mysql

CentOS/RHEL system

sudo yum update
sudo yum install php-mysql

Method 2: Manually compile and install the MySQLi extension

If the above command fails When executing, you can choose to manually compile and install the extension. Take the Ubuntu system as an example:

sudo apt-get update
sudo apt-get install php7.2-dev libmysqlclient-dev
sudo pecl channel-update pecl.php.net
sudo pecl install mysqlnd_ms

Note that php7.2-dev in the above command needs to be modified to the currently used PHP version. libmysqlclient-dev must be installed. If it is not installed, it will not be compiled successfully.

After the installation is completed, you need to add the following configuration information to php.ini:

extension=mysqlnd_ms.so

Step 3: Restart the Apache service

After installing the MySQL extension library, you need to Restart the Apache service to take effect:

Ubuntu/Debian system

sudo /etc/init.d/apache2 restart

CentOS/RHEL system

sudo systemctl restart httpd

After completing the above three steps, run the program again and you will be able to connect normally The MySQL database is operated.

Summary:

When using PHP for MySQL database operations, it is easy to encounter the error "PHP Fatal error: Call to undefined method mysqli::stmt_init()". This error is usually This is caused by PHP not loading the MySQL extension library correctly or the MySQL extension library version being incompatible. To address this problem, we can confirm whether the MySQL extension library has been loaded correctly by checking the information returned by the phpinfo() function. If it is not loaded correctly, you need to install the MySQL extension library through the command line or manually compile and install it; after the installation is completed, you need to Restart the Apache service to take effect.

The above is the detailed content of Solution to PHP Fatal error: Call to undefined method mysqli::stmt_init(). For more information, please follow other related articles on the PHP Chinese website!