php:php5.4 Connecting to SQL Server

To connect to the SQL Server (2005/2008) database in a PHP5.4 environment, the following steps are required:

1. Download the driver for PHP5.4 connection to SQL Server (two dynamic connection libraries) http://www.microsoft.com/en-us/download/confirmation.aspx?id=20098

Unzip to get two files Php_pdo_sqlsrv_54_ts.dll and Php_sqlsrv_54_ts.dll (this is a thread-safe version), copy these two files to PHP

In the Ext directory. Then configure it in the php.ini file:

[Php_pdo_sqlsrv]extension=php_pdo_sqlsrv_54_ts.dll[php_sqlsrv]extension=php_sqlsrv_54_ts.dll

2. Download Microsoft SQL Server Native Client http://www.xdowns.com/soft/38/110/2012/soft_87196.html

After the installation is complete, your PHP5.4 can access the SQL Server database unexpectedly.

Note: The driver for PHP5.4 only supports WIN7 and server 2008 operating systems.