在PHP中显示MSSQL数据库的所有结果

$serverName = "localhost";
$connectionOptions = array(
    "Database" => "your_database_name",
    "Uid" => "your_username",
    "PWD" => "your_password"
);
$conn = sqlsrv_connect($serverName, $connectionOptions);

$query = "SELECT * FROM users";
$result = sqlsrv_query($conn, $query);

while ($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) {
    echo "ID: " . $row['id'] . "<br>";
    echo "Name: " . $row['name'] . "<br>";
    // 其他字段...
    echo "<br>";
}

sqlsrv_free_stmt($result);
sqlsrv_close($conn);