Shulou(Shulou.com)06/02 Report--

This article mainly introduces "how PHP extends Mysql and Mysqli". In daily operation, I believe many people have doubts about how PHP extends Mysql and Mysqli. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "how to expand Mysql and Mysqli by PHP". Next, please follow the editor to study!

In PHP development, use Mysql extension to link Mysql database for addition, deletion, modification, query and other operations.

When choosing the Mysql extension, there are two official options:

Original version of MySQL.

Http://cn.php.net/manual/zh/book.mysql.php

This extension has been obsolete since PHP 5.5.0 and has been deprecated since PHP 7.0.0. It's starting to be removed.

Instead, you can use mysqli or PDO_MySQL extensions instead.

Enhanced version of MySQL.

Http://cn.php.net/manual/zh/book.mysqli.php

The mysqli extension allows us to access the features provided by MySQL version 4.1 and above.

Property comparison:

Feature mysqlimysqlPHP version > = 5. 0 > 3.0MySQL development status active maintenance only MySQL recommended to use preferred recommended API character set support whether stored procedure support, whether multi-statement execution support, whether all functions above MySQL4.1 are supported

The I of MySQLi stands for Improvement.

Related concepts

Both MySQL and MySQLi are sets of functions for PHP.

After the PHP5 version, the function function of mysqli has been added.

In a sense, it is an enhanced version of the MySQL system function, more stable, more efficient and more secure.

Connection process

MySQL opens a connected process for each link.

Multiple runs of MySQLi will use the same connection process, reducing the overhead of the server.

Link mode

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.