How to install mysql extension module in PHP7

This article will introduce to you how to install the mysql extension module in PHP7. It has certain reference value. Friends in need can refer to it. I hope it will be helpful to everyone.

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, PHP has started preparing to abandon it since PHP5.5. Use 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 compatibility, it is necessary to minimize the use of mysql extension for database connections.

As an operation and maintenance personnel, we not only want to use PHP7 to improve the efficiency of the server, but also ensure that old programs can run. How to do it?

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, compile: file package

Unzip

# tar xzvf mysql-45881bd.tar.gz

Enter the mysql extension directory

# cd mysql-45881bd/

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

# /opt/php/bin/phpize

The following error message may be prompted

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

# 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, you can see it when accessed by the browser mysql extended information and displays "Connection successful".

Recommended learning: php video tutorial

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