php7 install mysql extension

How to install the mysql extension in php7: First download the mysql extension on the php website; then unzip it and initialize it using the phpize tool; then copy mysql.so to the directory where php.ini is currently located; finally, in php.ini Just add "extension=mysql.so".

The operating environment of this article: windows7 system, PHP7.2.18 version, DELL G3 computer

Installation of mysql in PHP7 Extension module

Compared with PHP5, the biggest change in PHP7 is the removal of the mysql extension. It is recommended to use mysqli or pdo_mysql. In fact, starting from PHP5.5, PHP started preparing to abandon the mysql extension. If you use mysql extension, you may have seen this prompt "Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in". So in future programs, in order to maintain For compatibility, it is necessary to minimize the use of mysql extension for database connections.

As an operation and maintenance personnel, I want to use PHP7 to improve the efficiency of the server, but also ensure that the old program can run. How to do this?

1. Go to the php website to download the mysql extension, http://git.php.net/?p=pecl/database/mysql.git;a=summary

2. Unzip and Use the phpize tool to initialize and compile: file package [Related recommendations: PHP7 tutorial]

Unzip

# tar xzvf mysql-45881bd.tar.gz

Enter the mysql extension directory

# cd mysql-45881bd/

Use phpize to initialize , my phpize is in /opt/ directory

# /opt/php/bin/phpize

may prompt the following error message

Cannot find autoconf. Please check your autoconf installation and the $PHP_AUTOCONF environment variable. Then, rerun this script.

Solution:

# yum install -y m4 autoconf

Compile the mysql extension and use the mysql native driver as the mysql link Library

# ./configure --with-php-config=/opt/php/bin/php-config --with-mysql=mysqlnd   
# make && make install

3. Next, we edit the php.ini file directly, copy mysql.so to the directory where php.ini is currently located, and then add extension=mysql.so

to php.ini.

# cp /root/mysql-fae9884/modules/mysql.so /etc/

4. Restart php

# /etc/init.d/php-fpm restart
Gracefully shutting down php-fpm . done
Starting php-fpm  done

5. Configure the connection MySQL test page

Before we access the MySQL database, we need to connect to the database server first:

<?php
$servername = "192.168.1.20";
$username = "test";
$password = "magedu";

// 创建连接
$conn = new mysqli($servername, $username, $password);

// 检测连接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}
echo "连接成功";
   phpinfo();
?>

After success, the browser access can see the MySQL extension information and display "Connection successful".

The above is the detailed content of php7 install mysql extension. For more information, please follow other related articles on the PHP Chinese website!