PHP connection MySQL related knowledge and operations-PHP Tutorial-php.cn

How to connect through phpmysql database, this chapter will explain the database connection in detail.

Connecting to MySQL

Before we access the MySQL database, we need to connect to the database server first:

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

Copy after login

Note that $connect_error in the above object-oriented example was added in PHP 5.2.9 and 5.3.0. If you need to be compatible with earlier versions, please use the following code replacement:

// 检测连接 if (mysqli_connect_error()) { die("数据库连接失败: " . mysqli_connect_error()); }

Copy after login

Instance (MySQLi - process-oriented)

Copy after login

Instance (PDO)

getMessage();}?>

Copy after login

Note that In the above PDO example, we have specified the database (myDB). PDO needs to set the database name during the connection process. If not specified, an exceptionwill be thrown.

Close the connection

The connection will be automatically closed after the script is executed. You can also use the following code to close the connection:

Instance(MySQLi - Object Oriented)

$conn->close();

Copy after login

Instance(MySQLi - Procedural Oriented)

mysqli_close($conn);

Copy after login

Instance(PDO)

$conn = null;

Copy after login

This chapter provides a detailed understanding of the knowledge and operations of database connections. For more learning materials, please pay attention to the php Chinese website.

Related recommendations:

Introduction to PHP MySQL (database related knowledge)

PHP MySQL data reading operations and Method

How to use PHP to send email

The above is the detailed content of PHP connection MySQL related knowledge and operations. For more information, please follow other related articles on the PHP Chinese website!