Windows 搭配 IIS7 PHP MySQL 环境
IIS+PHP缺点：由于正版Windows价格昂贵，Windows 2003中文企业版一般价格在19000-30000。
其实Win7上面的配置和Windows 2003上的配置大同小异，只是Win7上面的IIS的安装和界面有所变化。
MySQL v5.1.60 for Win下载
PHP v5.3 For Windows下载
2、安装IIS7.5：依次打开控制面板->程序->打开或关闭Windows功能，打开下面的对话框，展开Internet信息服务，然后展开万维网服务，选择“安全性”和“常见HTTP功能”的默认选项，“应用程序开发功能”按下面的图选择即可，然后点击确定，系统就会从光盘里面自动安装IIS，安装好的IIS就可釉支持ASP功能了。
3、配置php环境：把php压缩包解压到d:\php目录下面，然后找到php.ini-dist，把他更名为php.ini，修改里面的扩展目录
加强栈
extension_dir = “D:\php\ext\”
然后把extension=php_mysql.dll前面的分号去掉，保存并把php.ini复制到系统Windows目录下面。
然后依次打开我的电脑(右键)->管理->服务和应用程序->Internet信息服务(IIS)管理器
打开ISAPI和CGI限制，然后添加php的ISAPI的执行文件
添加后如下图所示
然后打开ISAPI筛选器，添加php的ISAPI执行文件
添加之后如下图所示
添加默认文档
添加之后的列表如下
4、安装/配置Mysql：把下载的mysql文件直接安装即可，然后复制php目录下面的libmysql.dll到系统Windows下面的System32目录里。
5、重启IIS，刚才的配置就都生效了，配置也就完成了。
BTW：关于Win7下面的apache+php+mysql的配置和Windows 2003下面的配置是一样的，想了解的朋友请点这里。
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1668
14
1426
52
1328
25
1273
29
1255
24
What is the significance of the session_start() function?
May 03, 2025 am 12:18 AM
session_start()iscrucialinPHPformanagingusersessions.1)Itinitiatesanewsessionifnoneexists,2)resumesanexistingsession,and3)setsasessioncookieforcontinuityacrossrequests,enablingapplicationslikeuserauthenticationandpersonalizedcontent.
Steps to add and delete fields to MySQL tables
Apr 29, 2025 pm 04:15 PM
In MySQL, add fields using ALTERTABLEtable_nameADDCOLUMNnew_columnVARCHAR(255)AFTERexisting_column, delete fields using ALTERTABLEtable_nameDROPCOLUMNcolumn_to_drop. When adding fields, you need to specify a location to optimize query performance and data structure; before deleting fields, you need to confirm that the operation is irreversible; modifying table structure using online DDL, backup data, test environment, and low-load time periods is performance optimization and best practice.
How to uninstall MySQL and clean residual files
Apr 29, 2025 pm 04:03 PM
To safely and thoroughly uninstall MySQL and clean all residual files, follow the following steps: 1. Stop MySQL service; 2. Uninstall MySQL packages; 3. Clean configuration files and data directories; 4. Verify that the uninstallation is thorough.
An efficient way to batch insert data in MySQL
Apr 29, 2025 pm 04:18 PM
Efficient methods for batch inserting data in MySQL include: 1. Using INSERTINTO...VALUES syntax, 2. Using LOADDATAINFILE command, 3. Using transaction processing, 4. Adjust batch size, 5. Disable indexing, 6. Using INSERTIGNORE or INSERT...ONDUPLICATEKEYUPDATE, these methods can significantly improve database operation efficiency.
How to use MySQL functions for data processing and calculation
Apr 29, 2025 pm 04:21 PM
MySQL functions can be used for data processing and calculation. 1. Basic usage includes string processing, date calculation and mathematical operations. 2. Advanced usage involves combining multiple functions to implement complex operations. 3. Performance optimization requires avoiding the use of functions in the WHERE clause and using GROUPBY and temporary tables.
How to configure the character set and collation rules of MySQL
Apr 29, 2025 pm 04:06 PM
Methods for configuring character sets and collations in MySQL include: 1. Setting the character sets and collations at the server level: SETNAMES'utf8'; SETCHARACTERSETutf8; SETCOLLATION_CONNECTION='utf8_general_ci'; 2. Create a database that uses specific character sets and collations: CREATEDATABASEexample_dbCHARACTERSETutf8COLLATEutf8_general_ci; 3. Specify character sets and collations when creating a table: CREATETABLEexample_table(idINT
How to analyze the execution plan of MySQL query
Apr 29, 2025 pm 04:12 PM
Use the EXPLAIN command to analyze the execution plan of MySQL queries. 1. The EXPLAIN command displays the execution plan of the query to help find performance bottlenecks. 2. The execution plan includes fields such as id, select_type, table, type, possible_keys, key, key_len, ref, rows and Extra. 3. According to the execution plan, you can optimize queries by adding indexes, avoiding full table scans, optimizing JOIN operations, and using overlay indexes.
Composer: The Package Manager for PHP Developers
May 02, 2025 am 12:23 AM
Composer is a dependency management tool for PHP, and manages project dependencies through composer.json file. 1) parse composer.json to obtain dependency information; 2) parse dependencies to form a dependency tree; 3) download and install dependencies from Packagist to the vendor directory; 4) generate composer.lock file to lock the dependency version to ensure team consistency and project maintainability.
