MSSQL数据库与PHP的连接

<?php
$server = 'server_name';
$username = 'username';
$password = 'password';
$database = 'database_name';

$conn = mssql_connect($server, $username, $password);
if (!$conn) {
    die('连接失败：' . mssql_get_last_message());
}

mssql_select_db($database, $conn);

// 执行SQL查询和操作

mssql_close($conn);
?>

<?php
$server = 'server_name';
$username = 'username';
$password = 'password';
$database = 'database_name';

$conn = odbc_connect("Driver={SQL Server};Server=$server;Database=$database;", $username, $password);
if (!$conn) {
    die('连接失败：' . odbc_errormsg());
}

// 执行SQL查询和操作

odbc_close($conn);
?>

<?php
$server = 'server_name';
$username = 'username';
$password = 'password';
$database = 'database_name';

try {
    $conn = new PDO("sqlsrv:Server=$server;Database=$database", $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // 执行SQL查询和操作

    $conn = null;
} catch (PDOException $e) {
    die('连接失败：' . $e->getMessage());
}
?>