Introduction to IIS + mysql + php _ MySQL

I found that many data versions are very old. it seems that this is a good news! Linews may use php! Some people say that it is not successful. next I will use WIN2003 as an example to reinstall and configure the demo and add it to you. I strongly hope you can refine it! If you encounter any problems during the installation process, please refer to bbs.xqin.com and I will try my best to help solve them! IIS

I found that many data versions are very old. it seems that this is a good news! Linews may use php!

Some people say that it is not successful. next I will use WIN2003 as an example to reinstall and configure the demo and add it to you. I strongly hope you can refine it!

If you encounter problems during the installation process welcome to http://bbs.xqin.com, I will try to help solve!

Complete title:

IIS + PHP + MySQL + Zend Optimizer + GD library + phpMyAdmin installation configuration in Windows 2000/XP/2003

Keywords: Windows IIS configuration support PHP + MYSQL

It is relatively simple to configure PHP in Apache.

I. software preparation:

The following are the latest official versions as of May 20 ,.

PHP (5.0.4): http://cn.php.net/get/php-5.0.4-Win32.zip/from/a/mirror

MySQL (4.1.11): http://www.skycn.com/soft/1262.html

Http://dev.mysql.com/downloads/mysql/4.1.html

Zend Optimizer (2.5.7): http://www.zend.com/store/free_download.php? Pid = 13

PhpMyAdmin (2.6.2): http://www.skycn.com/soft/10687.html

Http://www.crsky.com/SoftView/SoftView_4190.html

Suppose C: \ is the system disk of your current operating system. if your current operating system is not installed in C: \, modify it on your own.

II. install PHP:

(1), download to get the php-5.0.4-Win32.zip, decompress to C: \ Inetpub \ php (this path can be arbitrary, but if you use this path below, please modify the corresponding );

(2) re-run the C: \ Inetpub \ php directory to all the dll files (mainly C: \ Inetpub \ php C: \ Inetpub \ php \ ext DLL file) copy to c: \ Windows \ system32, overwrite the existing dll file;

(3) set php.exe‑php-win.exe and php. copy the ini-dist files to C: \ Windows (C: \ WINNT in Windows 2000) and C: \ Windows \ php. ini-dist is renamed as php. ini, open it with notepad, and use the search function of notepad to search

CODE:

Register_globals = Off

, Change Off to On;

Search again

CODE:

Extension_dir =

And direct the path to the extensions directory under your PHP Directory, for example, extension_dir = "C: \ Inetpub \ php \ ext ";

Search found

CODE:

Windows Extensions

List

CODE:

; Extension = php_dbase.dll

Optional

CODE:

; Extension = php_gd2.dll

This is used to support the GD Library. it is generally required.

CODE:

; Extension = php_ldap.dll

Optional

CODE:

; Extension = php_mbstring.dll

If you do not select PHPMYADMIN, a red prompt is displayed. Therefore, it is required.

CODE:

; Extension = php_mssql.dll

This is used to support MSSQL. optional.

CODE:

; Extension = php_mysql.dll

This is used to support MYSQL. it is required to support MYSQL.

Remove the previous ";". you can also remove the previous one if you need it. then, close and save the file.

Example of the PHP. ini file after my configuration is successful:

Http://xqin.com/iis/php.ini

(4) configure IIS to support PHP:

First, make sure that IIS is correctly installed in the system. if IIS is not installed, install IIS first. the installation steps are as follows:

Open your browser and enter http: // localhost/. then, you can view the successful page and perform the following operations:

PHP supports CGI and ISAPI installation modes. The ISAPI mode is recommended. Here, we will only describe how to install ISAPI:

In "control panel", select "Internet service manager" in "administrative tools", enable IIS, and stop the service, then, right-click the "Web site that you need to support PHP" on the left, for example, "default Web site", and choose "properties ", in the "ISAPI filter" tab in the "Web site properties" window, find and click "add, in the pop-up "filter properties" window, enter: PHP in the "filter name" column, and then point the executable file to php5isapi. dll path, for example, C: \ Inetpub \ php \ php5isapi. dll.

Open the "home directory" tab in the "Web site properties" window, find and click "configuration", find and click "add" in the "application configuration" window that appears, in the displayed window, add a new extension ing with the extension. php, click browse to point the executable file to php5isapi. dll path, for example, C: \ Inetpub \ php \ php5isapi. dll, and then click OK. If you want to support PHP files with extensions such as. php3 and. phtml, repeat the "add" step.

Open the "documents" tab in the "Web site properties" window, find and click "add" to add the index. php item to the default Web site startup document list. You can raise index. php to the highest priority, so that the index. php document is automatically searched and opened when you visit the site.

[Img] http://xqin.com/iis/iis-8.gif/?img]

Select "pure script" in the application settings and execution licenses of the Web Directory, close the Internet information service manager, and run the following command at the command prompt:

Net stop w3svc

Net stop iisadmin

Net start w3svc

Then, set the ISAPI extension permission in "WEB service extension" on the left of "Internet service manager". The Active Server Pages allow

Open the browser and enter http: // localhost/. after the successful page is displayed, create a new phpinfo. php file in the IIS root directory. the content is as follows:

CODE:

Phpinfo ();

?>

Open your browser and enter http: // localhost/phpinfo. php. all the information about PHP supported by the current Server is displayed. The Server API mode is ISAPI.

3. install MySQL:

If you are downloading Windows Essentials (x86), you will get the mysql-4.1.11-essential-win.exe, simply double-click the installation. Install C: \ Inetpub \ MySQL here. during the installation process, you will be prompted if you want to configure it immediately. select no to complete the installation. After the installation is complete, enter C: \ Inetpub \ MySQL \ bin \ mysqld-nt-install in "run" in the "Start" menu. after the installation is successful, enter: net mysql start, the MySQL service will be started. if you want to configure MySQL in more detail, go to the C: \ Inetpub \ MySQL \ bin directory and run MySQLInstanceConfig.exe, follow the prompts.

If you download Windows (x86), unzip the package and double-click to execute Setup.exe. The steps are the same as above.

If you download Without installer (unzip in C: \), decompress it to C: \ Inetpub \ MySQL, and enter C: \ Inetpub \ MySQL \ bin \ mysqld-nt.exe, after running successfully, enter: net mysql start, you can start the MySQL service.