php如何连接sqlserver

// 使用 sqlsrv 扩展
extension=php_sqlsrv.dll

$serverName = "your-server-name";
$connectionInfo = array("Database"=>"your-database", "UID"=>"username", "PWD"=>"password");

$conn = sqlsrv_connect($serverName, $connectionInfo);

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

$query = "SELECT * FROM your-table";
$stmt = sqlsrv_query($conn, $query);
if (!$stmt) {
    die(print_r(sqlsrv_errors(), true));
}

while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
    // 处理每一行数据
    print_r($row);
}

sqlsrv_close($conn);

// 加载 SQL Server 驱动程序
extension=php_sqlsrv.dll

// 创建连接字符串
$serverName = "localhost";
$connectionInfo = array("Database"=>"MyDatabase", "UID"=>"sa", "PWD"=>"your-password");

// 建立连接
$conn = sqlsrv_connect($serverName, $connectionInfo);
if (!$conn) {
    die(print_r(sqlsrv_errors(), true));
}

// 执行查询
$query = "SELECT * FROM MyTable";
$stmt = sqlsrv_query($conn, $query);
if (!$stmt) {
    die(print_r(sqlsrv_errors(), true));
}

// 处理结果
while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
    print_r($row);
}

// 关闭连接
sqlsrv_close($conn);