方法/步骤
-
PHP连接MSSQL2008/2005数据库与以往的连接mssql2000是不一样的,连接mssql2008/2005是需要自己添加PHP对MSSQL连接的驱动扩展了,而我们常用的hp.ini中的extension=php_mssql.dll扩展只适用连接于MSSQL2000哦
-
去官方下载一个SQL Server Driver for PHP的扩展包,我是在这里下载的http://www.microsoft.com/en-us/download/details.aspx?id=20098【记得下载后好像是要先安装然后再解压】
有四个文件,开始我也不知道下载那个,就全部下载了,然后逐个运行,
运行的时候记得选择存放地址:
D:\wamp\bin\php\php5.6.15\ext(也就是安装wamp的目录下php的扩展地址)
-
下载驱动程序,下载后安装释放程序,里面有以下文件:
php_pdo_sqlsrv_52_nts.dll
php_pdo_sqlsrv_52_ts.dll
php_pdo_sqlsrv_53_nts_vc6.dll
php_pdo_sqlsrv_53_nts_vc9.dll
php_pdo_sqlsrv_53_ts_vc6.dll
php_pdo_sqlsrv_53_ts_vc9.dll
php_sqlsrv_52_nts.dll
php_sqlsrv_52_ts.dll
php_sqlsrv_53_nts_vc6.dll
php_sqlsrv_53_nts_vc9.dll
php_sqlsrv_53_ts_vc6.dll
php_sqlsrv_53_ts_vc9.dll
SQLServerDriverForPHP.chm(手册,英文够好的话,可以看看,嘿嘿)
SQLServerDriverForPHP_License.rtf
SQLServerDriverForPHP_Readme.htm(自述文件)
-
配置php.ini
(1)在php.ini的Dynamic Extensions中添加如下两条扩展:extension=php_sqlsrv_56_ts.dllextension=php_pdo_sqlsrv_56_ts.dll
(2)将;extension=php_pdo.dll前面的;去掉,开启pdo连接扩展
(3)重新启动apache
备注:不要用***_nts.dll的文件,这样就会失败
extension=php_sqlsrv_56_nts.dllextension=php_pdo_sqlsrv_56_nts.dll
-
还需要安装驱动
https://msdn.microsoft.com/en-us/library/cc296170.aspx
https://www.microsoft.com/download/details.aspx?id=36434
To access data in a SQL Server 2005 or later database using the Microsoft Drivers for PHP for SQL Server (SQL Server 2008 or later if using version 3.2 or 3.1), you must have the following components installed on your computer: