PHP连接 SQL Server步骤详解

￡神魔★判官ぃ 2022-01-09 12:49 1152阅读 0赞

php 连接sql server时遇到了不少问题，这里把详细步骤记录下来，供大家参考：

首先我的是phpstudy-5.4,如下图;

![1132061-20170706174559050-2115374594.png][]

**第一步：下载SQLSRV**

**　　**地址：**[http://www.microsoft.com/en-us/download/details.aspx?id=20098][http_www.microsoft.com_en-us_download_details.aspx_id_20098]**

**　　**下载的是一个自解压的文件，解压后会有一堆dll文件

![1132061-20170706175506565-41956373.png][]

**第二步：将对应[PHP][]版本的dll文件copy到[php][PHP] ext目录下**

**　　**版本是php5.4，将php\_sqlsrv\_54\_ts.dll复制到ext目录下

![1132061-20170706175621206-1626417748.png][]

**第三步：修改php.ini文件**

增加一行： extension=php\_sqlsrv\_54\_ts.dll

![1132061-20170706175653519-200769150.png][]

修改一行 : mssql.secure\_connection = Off**改为on**

**![1132061-20170706175719675-715689820.png][]**

**第四步：重启apache**

**第五步：安装Microsoft SQL Server 2012 Native Client.msi**

根据自己系统在PHP服务器所在机器安装Microsoft SQL Server 2012 Native Client.msi，分X64和X86的。

[http://www.softpedia.com/get/Internet/Servers/Server-Tools/SQL-Server-Native-Client.shtml][http_www.softpedia.com_get_Internet_Servers_Server-Tools_SQL-Server-Native-Client.shtml]

**第六步：php代码判断是否能连接成功**

<?php  
header("Content-type:text/html;charset=utf-8");  
$conInfo=array('Database'=>'test', 'UID'=>'test', 'PWD'=>'123456');

$conn=sqlsrv\_connect('12.14.27.116', $conInfo);

/\*判断连接成功与否：\*/

if(!$conn) echo "FAILD!连接错误，用户名密码不对";  
else echo "OK!可以连接";  
?>

![1132061-20170706175810050-655117097.png][]

转载于:https://www.cnblogs.com/webwangjie/p/7127718.html

[1132061-20170706174559050-2115374594.png]: /images/20220109/1c7ef18cbf1b41dfbc8dee3047450116.png
[http_www.microsoft.com_en-us_download_details.aspx_id_20098]: http://www.microsoft.com/en-us/download/details.aspx?id=20098
[1132061-20170706175506565-41956373.png]: /images/20220109/f14b2eae30b54b00aba1ebb7950c4b5a.png
[PHP]: http://lib.csdn.net/base/php
[1132061-20170706175621206-1626417748.png]: /images/20220109/69e11019d3704376b0fbfcb18af3de23.png
[1132061-20170706175653519-200769150.png]: /images/20220109/32a9789188f549c0baf2b8f6db4f4b1b.png
[1132061-20170706175719675-715689820.png]: /images/20220109/7760c8b8ae0e42319d6fc86681fed996.png
[http_www.softpedia.com_get_Internet_Servers_Server-Tools_SQL-Server-Native-Client.shtml]: http://www.softpedia.com/get/Internet/Servers/Server-Tools/SQL-Server-Native-Client.shtml
[1132061-20170706175810050-655117097.png]: /images/20220109/ffa67a0ec50345a8ab861d8e8f16e755.png