Home > Article > Backend Development > Several ways to connect to the database in php
For PHP 5 and above, it is recommended to use the following method to connect to MySQL:
MySQLi: MySQLi only targets MySQL database, and MySQLi also provides an API interface. . PDO (PHP Data Objects): PDO is used in 12 different databases.
Common points:
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 that MySQLi or PDO has been installed in wamp, view method: echo phpinfo();
The following three methods will be used to demonstrate PHP operations. MySQL:
1., MySQLi - object-oriented
connect_error) { die("连接失败:". $conn->connect_error); } echo "连接成功"; ?>
2, MySQLi - process-oriented
3. PDO connects to MySQL database
PDO needs to set the database name. If it is not specified, an exception will be thrown
getMessage(); } ?>
The connection will be automatically made after the script is executed. Close, you can also use code to close the connection:
1, MySQLi - Object-oriented
$conn->close() ;
2, MySQLi - process-oriented
mysqli_close($conn);
3, PDO
$conn = null;
Recommended tutorial: PHP video tutorial
The above is the detailed content of Several ways to connect to the database in php. For more information, please follow other related articles on the PHP Chinese website!