PHP 5.6
Ubuntu的
sudo apt-get install PHP5.6-sybase freetds-common libsybdb5
AWS / Centos / Redhat
sudo yum install PHP56-mssql
之后,您可以通过PHP连接到Mssql数据库,如下所示:
$server = 'localhost';
$user = 'someUser';
$pass = 'somePassword';
$database = 'theDatabaseName';
try {
$pdo = new \PDO(
sprintf(
"dblib:host=%s;dbname=%s",$server,$database
),$user,$pass
);
$pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
echo "There was a problem connecting. " . $e->getMessage();
}
$query = "SELECT * FROM TestSchema.Employees";
$statement = $pdo->prepare($query);
$statement->execute();
$results = $statement->fetchAll(PDO::FETCH_ASSOC);
var_dump($results);
您可以在命令行上使用类似的方法对Mssql进行故障排除:
tsql -H your.server.name -p 1433 -U yourusername -P yourpassword -D yourdatabasename
该链接还包含在您的开发机器上安装Ms sql服务器所需的步骤(在Ubuntu上工作,在AWS上不起作用,但您可以在那里启动RDS实例).它还包含有关如何在数据库中创建测试表和数据的基本指令,以及PHP连接代码.