php如何連接sqlserver數(shù)據(jù)庫(kù)

在PHP中連接SQL Server數(shù)據(jù)庫(kù)，可以使用PDO（PHP數(shù)據(jù)對(duì)象）或者SQLSRV擴(kuò)展。

方法一：使用PDO擴(kuò)展連接SQL Server數(shù)據(jù)庫(kù)

<?php
$serverName = "serverName";
$connectionOptions = array(
    "Database" => "dbName",
    "Uid" => "username",
    "PWD" => "password"
);

// 建立連接
$conn = new PDO("sqlsrv:server=$serverName;Database=dbName", "username", "password");

// 設(shè)置錯(cuò)誤處理模式為異常
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

// 執(zhí)行SQL查詢
$stmt = $conn->query("SELECT * FROM tableName");

// 獲取查詢結(jié)果
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    echo $row['column1'] . ", " . $row['column2'] . "<br/>";
}

// 關(guān)閉連接
$conn = null;
?>

方法二：使用SQLSRV擴(kuò)展連接SQL Server數(shù)據(jù)庫(kù)

<?php
$serverName = "serverName";
$connectionOptions = array(
    "Database" => "dbName",
    "Uid" => "username",
    "PWD" => "password"
);

// 建立連接
$conn = sqlsrv_connect($serverName, $connectionOptions);

if ($conn === false) {
    die(print_r(sqlsrv_errors(), true));
}

// 執(zhí)行SQL查詢
$query = "SELECT * FROM tableName";
$stmt = sqlsrv_query($conn, $query);

if ($stmt === false) {
    die(print_r(sqlsrv_errors(), true));
}

// 獲取查詢結(jié)果
while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
    echo $row['column1'] . ", " . $row['column2'] . "<br/>";
}

// 關(guān)閉連接
sqlsrv_free_stmt($stmt);
sqlsrv_close($conn);
?>

請(qǐng)注意替換代碼中的serverName、dbName、username、password、tableName、column1和column2為實(shí)際的數(shù)據(jù)庫(kù)連接信息和查詢語(yǔ)句所需的參數(shù)。