How to configure the Window2003 IIS+MySQL+PHP+Zend environment
Jun 02, 2023 pm 09:56 PM
The Windows 2003 installation package includes Zend, PHP5.2.17, PHPWind8.7 and PHPMyadmin3.5.2. You can download the installation package directly to save time searching for resources.
However, since MySQL has exceeded the upload limit, you need to go to the MySQL official website to download. Then unzip and copy to D drive, as shown below:
?MySQLinDdisk
Installation and configuration of WindowsIIS FTP
Click Start>Control Panel>Add or Remove Programs.
AddingordeletingaPG
Click Add/Remove Windows Components (A).
AddingordeletingWindowscomponent
Select the application server and click Details.
Selectingapplicationserver
Select Internet Information Services (IIS) and click Details.
Clicking theInternetserviceinfo(iis)
Check the File Transfer Protocol (FTP) service and click OK.
SelectingFTPservice
Click Browse and select C:\Win2003sys\disc1\I386.
Choosingthesourceoffiles
Click to open IIS and the installation will begin. If your device uses the Windows200364bit operating system, this file is located in the C:/Win2003sys/disc1/AMD64 directory.
Openingthefile
When the following interface appears, it means that your IIS and FTP installation has been completed.
Completinginstallation
Installation and configuration of WindowsIIS PHP
Cut libeay32.dll, libmcrypt.dll, libmysql.dll and ssleay32.dll in the D drive to the C:\Windows\system32 directory. Cut the PHP configuration settings file to the C:\Windows directory.
MySQLintheDdisk
Right-click My Computer and select Manage.
Locate and click Internet Information Server (IIS) in the navigation pane, and click Web Services Extensions.
Right-click in a blank space of the information pane and select Add a new Web service extension.
Addinganewseviceextension
Enter: PHP in the extension input field in the pop-up window and click Add.
NamingthePHPextenxion
In the pop-up window, click Browse and select D:\websoft\php-5.2.17\php5isapi.dll, and click OK.
Assigningthefilesource
Select the Set extension status in the check box to Allow and click OK.
Permittingtheextensionstatus
After setting, php is added to the Web service extension item in the computer management navigation pane.
Settingoverview
? Right-click the website in the navigation pane and select Properties.
Alttext
Click Configure under the Home Directory tab.
Clickingconfigureration
Click Add.
Addingfileextension
Click Browse and select the file path D:\websoft\php-5.2.17\php5isapi.dll. Enter the extension .php and click OK.
Mappingextensionfiles
Under the Document tab, click Add, enter index.php in the pop-up input box and click OK.
Under the Document tab, click Add, enter index.html in the pop-up input box and click OK. Click Apply (A).
Addingdocuments
Click Select All(s) and click OK.
Selectingsubnodes
Click Apply (A) and click OK.
?Finishingconfiguration
At this point, your IIS and PHP configuration is complete.
Installation and configuration of WindowsMySQL
?Install MySQL
Enter the file path and double-click D:\websoft\mysql-essential-5.1.63-win32.msi.
Installing
After the installation process is complete, click Custom, then click Next.
Installationnavigation
Click MYSQLServer in the directory structure.
Click Change to modify the MySQL installation path, switching from drive C to D:\websoft\mysql-5.1 (reselect the path according to your actual needs). Click OK to confirm the path.
Changinginstallingdestinationpath_1
Confirmation
Click MYSQLServerDatafiles in the directory structure.
Click Change to modify the MySQL installation path, switching from drive C to D:\websoft\mysql-5.1 (reselect the path according to your actual needs). Click OK to confirm the path.
Changinginstallingdestinationpath_2Confirmation
Click Next in the pop-up window to continue installing MySQL.
After the pop-up window switches, click Finish to complete the MySQL installation.
Changinginstallingdestinationpath_2
?Configuring MySQL
Continuing from the previous article. Check DetailedConfiguration in the pop-up window and click Next.
Selectingdetailedconfiguration
? Check MultifunctionalDatabase in the pop-up window and click Next.
?SelectingMultifunctionalDatabase
Click Next.
Clickingnext
Check ManualSetting in the pop-up window and set the number of connections to 1400.
?SelectingManualSetting
Check EnableTCP/IPNetworking in the pop-up window and set the port number to 3306. Check EnableStrictMode and click Next.
SlectingEnableStrictMode
Check StandardCharacterSet in the pop-up window and click Next.
Alttext
Check InstallAsWindowsService in the pop-up window and click Next.
Alttext
Check ModifySecuritySettings in the pop-up window to set your MySQLroot password. Please keep your password safe and be careful not to forget it. Click Next.
Alttext
Click Execute to start configuration. Wait for all four MySQL configuration progresses to be completed and click Finish to end the configuration.
ClickingExecute
?Install WindowsZend
If you do not have Zend encryption program on your device, you do not need to install Zend. If there is such a program, you will need to install Zend in case you cannot run the program.
Enter the file path and double-click D:\websoft\ZendOptimizer-3.3.3-Windows-i386.exe. Re-select the installation path and select the default settings for the rest of the settings. Click Next.
?Startinginstallation
Check Iagreethetermsofthelicenseagreement and click Next.
Confirmation
Select the Zend installation directory, such as D:\websoft\Zend in this example, and click Next.
Changingroot
Select IIS and click Next.
?ChoosingIIS
Install php.ini in the C:\Windows directory and click Next.
Installingphp.ini
Click Next.
ClickingNext
Click Install.
Installation
Click Yes.
Yes
After the Zend installation is complete, click Finish to end the installation boot.
?Configuring WindowsFTP
There are many FTP server software on the market. There are some genuine paid software such as Serv-u, Xlight, etc., and there are also free or system-included software. Here, Alibaba Cloud uses the FTP software that comes with Windows OS as an example to demonstrate the FTP configuration process for you.
?Configuring FTP
Click My Computer>Right-click>Manage.
Click Local Users and Groups > Users in the navigation pane, right-click in a blank area of ??the information pane and select New User.
?Users
Enter the FTP username and password.
SettingIDandpassword
Locate and click Internet Information Services Management in the navigation pane, right-click FTP site, and select New>FTP site.
Newsite
Click Next.
ClickingNext
Enter a description, such as "pwftp" in this example.
Typingdescription
Set the IP address and port of FTP and click Next. SettingIPandport
Check the box to not isolate users and click Next.
?Donotexcludeusers
Set the directory path, such as D:\websoft\www in this example.
Changingroot
Set the FTP access permissions to allow reading and writing, and click Next.
Changingaccessauthority
Click Finish to proceed to the next step of the site creation wizard.
Clickingcompletion
Set FTP permissions
Enter the directory D:\websoft (or the home directory of your FTP site), right-click the folder www>Properties.
Clickingattribute
Under the Security tab, check Users (this can be anyone logged in to the device, or yourself). Check the corresponding permission settings in the allow list and deny list.
After checking Full Control, click Advanced for advanced settings.
Settingaccessauthority
Check Use shown here to apply to sub-objects... and click Yes in the pop-up window.
Supportingaccess
Wait for the system to run the program.
Waiting
Set PWFTP account permissions
Right-click the folder WWW>Properties>Security and click Add (D).
Clickingattribute
Select the object type, select the location, enter the object name pwftp, and click OK.
Settingthepwftp
Check the corresponding permission settings in the allow list and deny list.
After checking Full Control, click Advanced for advanced settings.
Advancedsetting
It is the same as users permission settings. Check the permission item in the interface of advanced security settings, click Yes in the pop-up window, and then click Apply (A)>OK.
Settingaccessauthority
At this point, your WindowsFTP configuration is complete.
?Configuring WindowsIIS site
Right-click My Computer>Manage.
In the navigation pane, click Internet Information Services (IIS) > Websites, right-click the default website, and click Properties.
Clickingattribute
Under the Home Directory tab, click Browse and switch from the C drive to the specified path, such as D:\websoft\www\phpwind in this example.
Changingroot
Click Apply (A) and click OK.
Restart IIS or restart the server, and you can access your website through https://localhost.
Note: If your device uses the Windows 200364bit system version and is prompted that %1 is not a valid win32 application error when accessing https://localhost, please follow the instructions below to set it up:
Click Start > Run, enter cmd, and click OK.
Input: cscript%SYSTEMDRIVE%/inetpub/adminscripts/adsutil.vbsSETW3SVC/AppPools/Enable32bitAppOnWin641
Regarding IIS and FTP security hardening, please refer to FTP anonymous login or weak password vulnerability and service hardening.
The above is the detailed content of How to configure the Window2003 IIS+MySQL+PHP+Zend environment. For more information, please follow other related articles on the PHP Chinese website!
Hot AI Tools
Undress AI Tool
Undress images for free
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
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
How Do You Pass Variables by Value vs. by Reference in PHP?
Jul 08, 2025 am 02:42 AM
InPHP,variablesarepassedbyvaluebydefault,meaningfunctionsorassignmentsreceiveacopyofthedata,whilepassingbyreferenceallowsmodificationstoaffecttheoriginalvariable.1.Whenpassingbyvalue,changestothecopydonotimpacttheoriginal,asshownwhenassigning$b=$aorp
How to handle File Uploads securely in PHP?
Jul 08, 2025 am 02:37 AM
To safely handle PHP file uploads, you need to verify the source and type, control the file name and path, set server restrictions, and process media files twice. 1. Verify the upload source to prevent CSRF through token and detect the real MIME type through finfo_file using whitelist control; 2. Rename the file to a random string and determine the extension to store it in a non-Web directory according to the detection type; 3. PHP configuration limits the upload size and temporary directory Nginx/Apache prohibits access to the upload directory; 4. The GD library resaves the pictures to clear potential malicious data.
PHP find the position of the last occurrence of a substring
Jul 09, 2025 am 02:49 AM
The most direct way to find the last occurrence of a substring in PHP is to use the strrpos() function. 1. Use strrpos() function to directly obtain the index of the last occurrence of the substring in the main string. If it is not found, it returns false. The syntax is strrpos($haystack,$needle,$offset=0). 2. If you need to ignore case, you can use the strripos() function to implement case-insensitive search. 3. For multi-byte characters such as Chinese, the mb_strrpos() function in the mbstring extension should be used to ensure that the character position is returned instead of the byte position. 4. Note that strrpos() returns f
PHP header location ajax call not working
Jul 10, 2025 pm 01:46 PM
The reason why header('Location:...') in AJAX request is invalid is that the browser will not automatically perform page redirects. Because in the AJAX request, the 302 status code and Location header information returned by the server will be processed as response data, rather than triggering the jump behavior. Solutions are: 1. Return JSON data in PHP and include a jump URL; 2. Check the redirect field in the front-end AJAX callback and jump manually with window.location.href; 3. Ensure that the PHP output is only JSON to avoid parsing failure; 4. To deal with cross-domain problems, you need to set appropriate CORS headers; 5. To prevent cache interference, you can add a timestamp or set cache:f
Implementing Transactions and Understanding ACID Properties in MySQL
Jul 08, 2025 am 02:50 AM
MySQL supports transaction processing, and uses the InnoDB storage engine to ensure data consistency and integrity. 1. Transactions are a set of SQL operations, either all succeed or all fail to roll back; 2. ACID attributes include atomicity, consistency, isolation and persistence; 3. The statements that manually control transactions are STARTTRANSACTION, COMMIT and ROLLBACK; 4. The four isolation levels include read not committed, read submitted, repeatable read and serialization; 5. Use transactions correctly to avoid long-term operation, turn off automatic commits, and reasonably handle locks and exceptions. Through these mechanisms, MySQL can achieve high reliability and concurrent control.
Handling character sets and collations issues in MySQL
Jul 08, 2025 am 02:51 AM
Character set and sorting rules issues are common when cross-platform migration or multi-person development, resulting in garbled code or inconsistent query. There are three core solutions: First, check and unify the character set of database, table, and fields to utf8mb4, view through SHOWCREATEDATABASE/TABLE, and modify it with ALTER statement; second, specify the utf8mb4 character set when the client connects, and set it in connection parameters or execute SETNAMES; third, select the sorting rules reasonably, and recommend using utf8mb4_unicode_ci to ensure the accuracy of comparison and sorting, and specify or modify it through ALTER when building the library and table.
Connecting to MySQL Database Using the Command Line Client
Jul 07, 2025 am 01:50 AM
The most direct way to connect to MySQL database is to use the command line client. First enter the mysql-u username -p and enter the password correctly to enter the interactive interface; if you connect to the remote database, you need to add the -h parameter to specify the host address. Secondly, you can directly switch to a specific database or execute SQL files when logging in, such as mysql-u username-p database name or mysql-u username-p database name
Managing Character Sets and Collations in MySQL
Jul 07, 2025 am 01:41 AM
The setting of character sets and collation rules in MySQL is crucial, affecting data storage, query efficiency and consistency. First, the character set determines the storable character range, such as utf8mb4 supports Chinese and emojis; the sorting rules control the character comparison method, such as utf8mb4_unicode_ci is case-sensitive, and utf8mb4_bin is binary comparison. Secondly, the character set can be set at multiple levels of server, database, table, and column. It is recommended to use utf8mb4 and utf8mb4_unicode_ci in a unified manner to avoid conflicts. Furthermore, the garbled code problem is often caused by inconsistent character sets of connections, storage or program terminals, and needs to be checked layer by layer and set uniformly. In addition, character sets should be specified when exporting and importing to prevent conversion errors
