在PHP中连接SQL Server数据库，可以使用PDO（PHP数据对象）或者SQLSRV扩展。
方法一：使用PDO扩展连接SQL Server数据库
<?php$serverName = "serverName";$connectionOptions = array( "Database" => "dbName", "Uid" => "username", "PWD" => "password");// 建立连接$conn = new PDO("sqlsrv:server=$serverName;Database=dbName", "username", "password");// 设置错误处理模式为异常$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);// 执行SQL查询$stmt = $conn->query("SELECT * FROM tableName");// 获取查询结果while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { echo $row['column1'] . ", " . $row['column2'] . "<br/>";}// 关闭连接$conn = null;?>方法二：使用SQLSRV扩展连接SQL Server数据库
<?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));}// 执行SQL查询$query = "SELECT * FROM tableName";$stmt = sqlsrv_query($conn, $query);if ($stmt === false) { die(print_r(sqlsrv_errors(), true));}// 获取查询结果while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) { echo $row['column1'] . ", " . $row['column2'] . "<br/>";}// 关闭连接sqlsrv_free_stmt($stmt);sqlsrv_close($conn);?>请注意替换代码中的serverName、dbName、username、password、tableName、column1和column2为实际的数据库连接信息和查询语句所需的参数。
