先需要装(sqlsrv)扩展
https://www.microsoft.com/en-us/download/details.aspx?id=20098
下载好后,解压到随便一个目录里,然后找到对应版本的扩展的两个文件,复制到PHP的EXT目录下面
然后在php.ini加上extension扩展两个,比如
extension=php_sqlsrv_xx_ts.dll
extension=php_pdo_sqlsrv_xx_ts.dll
再需要装ODBC(不然还是连不上,大坑一个)
https://www.microsoft.com/zh-cn/download/details.aspx?id=36434
示例代码:
<?php
$server = 'xxx,11433';
$username = 'jooj';
$password = "xxxx";
$database = "xxxxx";
$connectionInfo = array("UID"=>$username, "PWD"=>$password, "Database"=>$database);
$dns = "sqlsrv:Database={$database};Server={$server}";
$conn = sqlsrv_connect( $server, $connectionInfo);
var_dump($conn);
$conn1 = new \PDO($dns,$username,$password);
var_dump($conn1);
if( $conn == false)
{
exit ( "fail" );
}输出结果:
C:\MyFile\syncScript>php sync.php
resource(4) of type (SQL Server Connection)
object(PDO)#1 (0) {
}