Since the web server has several websites deployed under iis before, Now this project is developed using php. Originally, php mysql iis should be very simple and can be easily searched on the Internet. However, since the previous web website used the sqlserver database, now I don’t want to change the original database structure and use it directly. In an environment like iis sql server php5.6, I won’t talk about the twists and turns in the middle. Let’s talk about the steps I took during 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 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.