php连接sqlserver数据库
2017/08/09    标签: php   

php使用pdo链接sqlserver数据库的步骤


一、下载相关软件

  1. Microsoft® ODBC Driver 11 for SQL Server® - Windows (msodbcsql.msi

  2. 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信息

image.png

如图则说明安装成功