Several ways to connect php to mysql

PHP 5 and above versions recommend using the following method to connect to MySQL:

MySQLi: MySQLi is only for MySQL database, MySQLi also provides API interface.

PDO (PHP Data Objects): PDO is used in 12 different databases.

Common points:(Recommended learning:PHP programming from entry to proficiency)

1. Both are object-oriented

2. Both support prepared statements. Prepared statements can prevent SQL injection and are very important for the security of web projects.

Make sure MySQLi or PDO has been installed in wamp, view method: echo phpinfo();

The following three methods will be used to demonstrate PHP operation of MySQL:

MySQLi - Object-oriented

 connect_error) { die("连接失败：". $conn->connect_error); } echo "连接成功"; ?>

MySQLi - Process-oriented

PDO connects to MySQL database

PDO needs to set the database name. If it is not specified, an exception will be thrown

getMessage(); } ?>

The above is the detailed content of Several ways to connect php to mysql. For more information, please follow other related articles on the PHP Chinese website!