How to configure the Window2003 IIS+MySQL+PHP+Zend environment
Jun 02, 2023 pm 09:56 PMThe 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

std::chrono is used in C to process time, including obtaining the current time, measuring execution time, operation time point and duration, and formatting analysis time. 1. Use std::chrono::system_clock::now() to obtain the current time, which can be converted into a readable string, but the system clock may not be monotonous; 2. Use std::chrono::steady_clock to measure the execution time to ensure monotony, and convert it into milliseconds, seconds and other units through duration_cast; 3. Time point (time_point) and duration (duration) can be interoperable, but attention should be paid to unit compatibility and clock epoch (epoch)

ToaccessenvironmentvariablesinPHP,usegetenv()orthe$_ENVsuperglobal.1.getenv('VAR_NAME')retrievesaspecificvariable.2.$_ENV['VAR_NAME']accessesvariablesifvariables_orderinphp.iniincludes"E".SetvariablesviaCLIwithVAR=valuephpscript.php,inApach

CTE is a temporary result set in MySQL used to simplify complex queries. It can be referenced multiple times in the current query, improving code readability and maintenance. For example, when looking for the latest orders for each user in the orders table, you can first obtain the latest order date for each user through the CTE, and then associate it with the original table to obtain the complete record. Compared with subqueries, the CTE structure is clearer and the logic is easier to debug. Usage tips include explicit alias, concatenating multiple CTEs, and processing tree data with recursive CTEs. Mastering CTE can make SQL more elegant and efficient.

PHPhasthreecommentstyles://,#forsingle-lineand/.../formulti-line.Usecommentstoexplainwhycodeexists,notwhatitdoes.MarkTODO/FIXMEitemsanddisablecodetemporarilyduringdebugging.Avoidover-commentingsimplelogic.Writeconcise,grammaticallycorrectcommentsandu

There are three key ways to avoid the "undefinedindex" error: First, use isset() to check whether the array key exists and ensure that the value is not null, which is suitable for most common scenarios; second, use array_key_exists() to only determine whether the key exists, which is suitable for situations where the key does not exist and the value is null; finally, use the empty merge operator?? (PHP7) to concisely set the default value, which is recommended for modern PHP projects, and pay attention to the spelling of form field names, use extract() carefully, and check the array is not empty before traversing to further avoid risks.

When using PHP preprocessing statements to execute queries with IN clauses, 1. Dynamically generate placeholders according to the length of the array; 2. When using PDO, you can directly pass in the array, and use array_values to ensure continuous indexes; 3. When using mysqli, you need to construct type strings and bind parameters, pay attention to the way of expanding the array and version compatibility; 4. Avoid splicing SQL, processing empty arrays, and ensuring data types match. The specific method is: first use implode and array_fill to generate placeholders, and then bind parameters according to the extended characteristics to safely execute IN queries.

WhensettingupMySQLtables,choosingtherightdatatypesiscrucialforefficiencyandscalability.1)Understandthedataeachcolumnwillstore—numbers,text,dates,orflags—andchooseaccordingly.2)UseCHARforfixed-lengthdatalikecountrycodesandVARCHARforvariable-lengthdata

Reasons and solutions for the header function jump failure: 1. There is output before the header, and all pre-outputs need to be checked and removed or ob_start() buffer is used; 2. The failure to add exit causes subsequent code interference, and exit or die should be added immediately after the jump; 3. The path error should be used to ensure correctness by using absolute paths or dynamic splicing; 4. Server configuration or cache interference can be tried to clear the cache or replace the environment test.
