php连接sqlserver数据库
2017/08/09 标签:
php
php使用pdo链接sqlserver数据库的步骤
一、下载相关软件
Microsoft® ODBC Driver 11 for SQL Server® - Windows (msodbcsql.msi)
Microsoft Drivers for PHP for SQL Server (SQLSRV32.EXE)
(根据需要下载对应版本:
Version support for PHP is as follows
Version 4.0 supports PHP 7.0+ on Windows and Linux
Version 3.2 supports PHP 5.6, 5.5, and 5.4 on Windows
Version 3.1 supports PHP 5.5 and 5.4 on Windows
Version 3.0 supports PHP 5.4 on Windows)
二、安装配置
1.双击msodbcsql.msi,按步骤全部下一步
2.双击SQLSRV32.exe,安装目录选择在php的ext扩展目录
3.修改php.ini文件,增加对应版本的扩展(php56n对应extension=php_pdo_sqlsrv_56_nts.dll);
4.重启服务器,phpinfo()打印php信息
如图则说明安装成功