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!