如何使用PHP从网站连接到Microsoft SQL数据库

$serverName = "server_name";
$connectionOptions = array(
    "Database" => "database_name",
    "Uid" => "username",
    "PWD" => "password"
);

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

$sql = "SELECT * FROM table_name";
$query = sqlsrv_query($conn, $sql);
if ($query === false) {
    die(print_r(sqlsrv_errors(), true));
}

while ($row = sqlsrv_fetch_array($query, SQLSRV_FETCH_ASSOC)) {
    echo $row['column_name'] . "<br>";
}

sqlsrv_free_stmt($query);

sqlsrv_close($conn);