首先下载微软官方驱动,Microsoft Drivers for PHP for SQL Server选择Window**.zip:
https://docs.microsoft.com/en-us/sql/connect/php/download-drivers-php-sql-server?view=sql-server-2017
将相应的DLL文件拷贝到php安装目录的ext文件
将相应的DLL文件拷贝到php安装目录的ext文件夹中
编辑php.ini,添加:
extension=php_sqlsrv_(*对应)ts.dll
extension=php_pdo_sqlsrv(*对应)_ts.dll
下载安装ODBC Driver
Microsoft® ODBC Driver 11 for SQL Server® - Windows (支持Sql Server® 2005) https://www.microsoft.com/zh-CN/download/details.aspx?id=36434
Microsoft® ODBC Driver 13 for SQL Server® - Windows + Linux (支持最新的SQL Server® 2016) https://www.microsoft.com/zh-CN/download/details.aspx?id=50420