在Linux上从PHP连接到MS SQL Server？

sudo apt-get install php-mssql

sudo yum install php-mssql

<?php
$server = 'localhost';
$username = 'your_username';
$password = 'your_password';
$database = 'your_database';

$connection = mssql_connect($server, $username, $password, $database);

if (!$connection) {
    die('Could not connect: ' . mssql_get_last_message());
}

echo 'Connected successfully!';
?>

<?php
$server = 'localhost';
$username = 'your_username';
$password = 'your_password';
$database = 'your_database';

$connection = mssql_connect($server, $username, $password, $database);

if (!$connection) {
    die('Could not connect: ' . mssql_get_last_message());
}

$query = 'SELECT * FROM your_table';
$result = mssql_query($query, $connection);

if (!$result) {
    die('Query failed: ' . mssql_get_last_message());
}

while ($row = mssql_fetch_assoc($result)) {
    echo $row['column_name'] . '<br>';
}

mssql_free_result($result);
mssql_close($connection);
?>