Home > Article > Backend Development > How to connect php programming to mysql
php method to connect to mysql:
MySQLi - object-oriented
<?php $servername = "localhost"; $username = "username"; $password = "password"; // 创建连接 $conn = new mysqli($servername, $username, $password); // 检测连接 if ($conn->connect_error) { die("连接失败: " . $conn->connect_error); } echo "连接成功"; ?>
MySQLi - process-oriented
<?php $servername = "localhost"; $username = "username"; $password = "password"; // 创建连接 $conn = mysqli_connect($servername, $username, $password); // 检测连接 if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } echo "连接成功"; ?>
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:
(MySQLi - Object Oriented
$conn->close();
MySQLi - Procedure Oriented
mysqli_close($conn);
Recommended: php server
The above is the detailed content of How to connect php programming to mysql. For more information, please follow other related articles on the PHP Chinese website!