Some problems encountered when building iis sqlserver php5.6 environment under windows2008r2

Because the web server used to deploy several websites under iis, and now this project is developed using php. Originally, php MySQL iis should be very simple and can be easily searched online. However, because the web website used to use sqlserver database, now I don’t want to change the original database structure, so I directly use the iis sql server php5.6 environment

Because the web server used to deploy several websites under iis, and now this project is developed using php. Originally, php MySQL iis should be very simple and can be easily searched online. However, because the web website used to use sqlserver database, now I don’t want to change the original database structure, so I directly use the environment of iis sql server php5.6. I won’t talk about the twists and turns in the middle. Let’s talk about the steps during my deployment:

1. Go to the php official website to download php5.6.16 (http://windows.php.net/download). Please select VC11 x86 Non Thread Safe here. Whether you are 64-bit or 32-bit, select x86, which is 32-bit. Download, why is this because php5.6 does not support linking to sqlserver, but Microsoft provides corresponding components, but the components on Microsoft's official website only support 32-bit. Unzip it to C:PRogram Files (x86), modify php.ini, if not, copy php.ini-development and change it to php.ini, modify date.timezone = "Asia/Shanghai", and add the extensions you need. Modify the environment variables to add the php root directory and the php extension directory ext, download the corresponding vc11 (Visual C Redistributable for Visual Studio 2012 Update 4), download x86 and install it. You must also select x86 here because php is x86.

　2. Turn on the cgi function of iis in the server role

3. Download PHP Manager for IIS ( http://phpmanager.codeplex.com/ releases/view/69115 ) and install it

4. Configure PHP Manager in IIS, click "Register new PHP version", browse and select "php-cgi.exe" under the php installation file in the pop-up box

At this point you can check phppathinfo() to see if iis php is successful, and then connect to sqlserver.

5. Go to Microsoft to download the driver for php to connect to sqlserver (http://www.microsoft.com/en-us/download/details.aspx?id=36434), select the corresponding version and install it directly. ,

6. Go to Microsoft to download Microsoft Drivers for PHP for SQL Server (http://www.microsoft.com/en-us/download/details.aspx?id=20098). Choose the latest installation and install it under php. under the ext directory.

7. Open php.ini and add the corresponding extension=php_sqlsrv_56_nts.dll extension=php_pdo_sqlsrv_56_nts.dll extension.

Here the installation of iis7 mssql server php5.6 is completed.