下载php to sqlsrv扩展文件:php_sqlsrv_56_ts.dll,php_pdo_sqlsrv_56_ts.dll注意有32位跟64位的区别
1.在php.ini文件中添加
extension=php_sqlsrv_56_ts.dll
extension=php_pdo_sqlsrv_56_ts.dll
在phpinfo()中看到如下提示
2. 下载ntwdblib.dll并拷贝到php解压目录和system32目录下
3.测试连接:
新建conn-sqlserver.php文件
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>PHP Connect Sqlserver</title>
</head>
<body>
<?php
$serverName = "ip,port";
$connectionInfo = array("UID" => "username", "PWD" => "password", "Database"=>"dbName");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn )
{
echo "Connection established.\n";
}
else
{
echo "Connection could not be established.\n";
die( print_r( sqlsrv_errors(), true));
}
//-----------------------------------------------
// Perform operations with connection.
//-----------------------------------------------
/* Close the connection. */
sqlsrv_close( $conn);
?>
</body>
</html>
看到Connection established.则说明连接成功