Home > Backend Development > PHP7 > body text

How to install mysql extension module in PHP7

醉折花枝作酒筹
Release: 2023-02-17 22:10:01
forward
2601 people have browsed it

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.

How to install mysql extension module in PHP7

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
Copy after login

Enter the mysql extension directory

# cd mysql-45881bd/
Copy after login

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

# /opt/php/bin/phpize
Copy after login

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.
Copy after login

Solution:

# yum install -y m4 autoconf
Copy after login

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
Copy after login

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/
Copy after login

4. Restart php

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

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();
?>
Copy after login

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!

Related labels:
source:csdn.net
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!