Linux - PHP 7.0 和 MSSQL (Microsoft SQL)

使用PHP 7.0与MSSQL轻松整合：构建高效Linux环境

bash
sudo apt-get update
sudo apt-get install php7.0 php7.0-mssql

bash
php -v

php
$serverName = "your_server_name";
$connectionOptions = array(
    "Database" => "your_database_name",
    "Uid" => "your_username",
    "PWD" => "your_password"
);
$conn = sqlsrv_connect($serverName, $connectionOptions);
if ($conn) {
    echo "Connection established!";
} else {
    echo "Connection failed!";
    die(print_r(sqlsrv_errors(), true));
}
?>

php
$query = "SELECT * FROM your_table";
$result = sqlsrv_query($conn, $query);
if ($result === false) {
    die(print_r(sqlsrv_errors(), true));
}
while ($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)) {
    echo "ID: " . $row['id'] . "
";
    echo "Name: " . $row['name'] . "
";
    // Add other fields as needed
}
sqlsrv_free_stmt($result);
sqlsrv_close($conn);
?>