1、PHP连接MSSQL2008/2005数据库与以往的连接mssql2000是不一样的,连接mssql2008/2005是需要自己添加PHP对MSSQL连接的驱动扩展了,而我们常用的hp.ini中的extension=php_mssql.dll扩展只适用连接于MSSQL2000哦
2、去官方下载一个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的扩展地址)

3、下载驱动程序,下载后安装楠道塘校释放程序,里面有以下文件:php_pdo_sqlsrv_52_nts.dllphp_pdo_sqlsrv_52_ts.dllp茑霁酌绡hp_pdo_sqlsrv_53_nts_vc6.dllphp_pdo_sqlsrv_53_nts_vc9.dllphp_pdo_sqlsrv_53_ts_vc6.dllphp_pdo_sqlsrv_53_ts_vc9.dllphp_sqlsrv_52_nts.dllphp_sqlsrv_52_ts.dllphp_sqlsrv_53_nts_vc6.dllphp_sqlsrv_53_nts_vc9.dllphp_sqlsrv_53_ts_vc6.dllphp_sqlsrv_53_ts_vc9.dllSQLServerDriverForPHP.chm(手册,英文够好的话,可以看看,嘿嘿)SQLServerDriverForPHP_License.rtfSQLServerDriverForPHP_Readme.htm(自述文件)


4、配置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
5、还需要安装驱动https://msdn.microsoft.com/en-us/library/cc296170.aspxhttps://www.microsoft.com/download/details.aspx?id=36434To 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: