Configure PHP database connections for different database management systems

Connect to different databases PHP: MySQL: Use the mysqli library, provide the server name, user name, password and database name. PostgreSQL: Use the pg_connect function, providing the host, port, database name, username, and password. Microsoft SQL Server: Use the sqlsrv_connect function, providing an array of server name and connection information.

Configuring PHP database connections for different database management systems

Connecting to a database in PHP is difficult for many web applications. is a basic task. Depending on the database management system (DBMS) you are using, the connection string and configuration settings will differ. In this tutorial, we will explore how to configure PHP database connections for popular DBMS such as MySQL, PostgreSQL, and Microsoft SQL Server.

MySQL

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "myDB";

// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

PostgreSQL

$host = "localhost";
$port = 5432;
$dbname = "myDB";
$username = "postgres";
$password = "mypassword";

// 创建连接
$conn = pg_connect("host=$host port=$port dbname=$dbname user=$username password=$password");

// 检查连接
if (!$conn) {
    die("连接失败: " . pg_last_error($conn));
}

Microsoft SQL Server

$serverName = "localhost";
$connectionInfo = array("Database"=>"myDB", "UID"=>"sa", "PWD"=>"mypassword");

// 创建连接
$conn = sqlsrv_connect($serverName, $connectionInfo);

// 检查连接
if ($conn === false) {
    die("连接失败: " . sqlsrv_errors());
}

Practical case

The following is a way to connect to a MySQL database and execute a query Complete example of:

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "myDB";

// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 执行查询
$sql = "SELECT * FROM users";
$result = $conn->query($sql);

// 遍历结果
if ($result->num_rows > 0) {
    // 输出数据
    while($row = $result->fetch_assoc()) {
        echo "id: " . $row["id"] . " - Name: " . $row["name"] . "
";
    }
} else {
    echo "没有数据";
}

// 关闭连接
$conn->close();

The above is the detailed content of Configure PHP database connections for different database management systems. For more information, please follow other related articles on the PHP Chinese website!