Experiment three: mysql+php's website construction

Objective: To master the construction process of mysql+php website
Experiment Preparation:
One server, one client
Preparation before the experiment:
Build a Web server (procedure omitted)
Experimental steps:
Step One
1. Installing PHP Packets
Unzip the Php-5.1.4-win32 this unpacking package, unzip it into its own folder, and then modify the package name of the unpacked folder in PHP, change the package name to PHP-----> Then set the extracted PHP folder properties information, Write permissions to the Local Users user---------> then open the PHP folder, locate Go-pear.abt, and double-click the file to perform the installation-----> requires a continuous press of 4 carriage returns, and then a random key after which the PHP package is installed.
2. This step is very key: first copy c:php inside the Libmysql.dll this file into the C:\windows\windows32 inside, and then copy C:\php\ext under the Php_mysql.dll this file to C:\windows\ Windows32 inside, the last copy of the C:\php in the php.ini-dist this file into the C:\windows, and the copy of the file to change to PHP.ini, is not finished, here also to modify the contents of this file, the contents of this document with; Extension=php_mysql.dll in this line of the front of the semicolon to be removed
3. Add the executable file C:\php\php5isapi.dll to the settings in the master configuration of the default Web site, and add a path to the Web service extension C:\php\php5isapi.dll
Step Two
Install MySQL
1. Extract the MySQL decompression package, unzip it to its own directory, and then into the extracted folder, found in the Setup.exe this executable file, double-click and execute this file, next is the "next"----> select "Typical"-----> "Install"-----> select "skip-sign-up"-----> "Next"-----> tick "Configure the MySQL server now"------> "Finish".
2. Continue to "next"----> here Select "Standard configuration"----> "Next"----> "Include bin directory in Windows path"----- > "Next"----> Check the "Modify security settings" and configure the password for this selected root user------> click "Execute" to start----"Finish"
3. Open the installed MySQL----> enter "show Databases;" On the command line to view the current database, then use the using with the database name to enter into the database, and then use show tables; To see all the current files
Step Three
Testing with test php-test.php files
Copy this file into C:\inetpub\wwwroot and enter it in the Address bar: http://localhost/php-test.php to verify that the MySQL database has been successfully installed
Step Four
1. First unzip the dynamic forum
2. Then import this extracted dynamic Forum Web file into the Web server's home directory under "Local path" and test access
3. Then unzip the discussion forum
4. Import this extracted dynamic Forum Web file into the Web server's home directory under "Local path" and test access
Here's how this experiment is done:
Copy the files from the real machine into the virtual machine via network file sharing, as shown below:

Change the path of the access

To disable the ASP

With local access

Permission to write to the local user as follows

Double-click the "go-pear.bat" executable file to start installing the PHP package

Press 4 consecutive carriage returns, then press an arbitrary key to install the OK

Here's a copy of C:\php's Libmysql.dll into C:\widnows\system32.

Copy the Php_mysql.dll file from C:\php\ext to C:\windows\system32.

Copy the php.ini-dist under the C:\php to C:\windows, and change the file to PHP.ini

Not finished, but also to open this file, and in the editor of the view found inside find Php_mysql.dll this file, and the front of the semicolon removed

In the default Web site, in the home directory, in configuration, locate options, and then add

The following is the file path found in the Web server extension of C:\php\php5isapi.dll.

Visit below to find out

Install MySQL below, double-click setup.exe to start the installation

Select "Skip Sign-up"

Select "Standard Configuration"

Check the box below to select "Include Bin directory windows path"

Check the "Modify security Settings" below and enter the root password

Use the show command to view the first created database, apply the database with the use command, use "show tables;" To view the files of the database, and use the SELECT * from the specific folder of the database to view the specific file contents of the file

Enter "Services.msc" in "Run" to view the database service after it has been created

Using Netstat-na to see the port number opened by the MySQL service, we found that the port number on MySQL was 3306 ports

Now stop the MySQL service on the service side

We found no 3306 ports open now.

Now the database is also installed, the following to test the database there is no problem

Now that you have access to it, that means no problem.

Modify the suffix name of the file

Found to still be able to access

Change into TXT document form

Found to still be able to access

The following is the dynamic forum of the PHP Web file package to extract into a folder, and then the folder inside the uploadscopy to inetpub under the wwwroot below

Discovery Directory list Reject

Now add a document "index.php"

Discover that Access still fails

Locate the database file below and send it under install install.php

No permissions found

Now that you have access to it, you can start installing the

Fill in some configuration information and save the configuration information

A database error was found stating that there is no such database file, so we can now create a database under MySQL named Dvbbs.

As shown below:

Now the visit found a whole bunch of bugs,

Now check the "modify" item in the Internet Guest account under Wwwroot, then advanced

In advanced, tick "override permission entries for all child objects with items shown here that can be applied to child objects"

Fill in the configuration information again

Now that the inspection is passed, you can now start to perform the installation

Discovery created table succeeded

Check it out with MySQL, and it's also successful.

Now to install the basic information of the Forum

Dvbbs Forum Installation success

Now to delete "install.php" This file can be accessed

Found now able to access the

Sign in with the client.

Enter http://192.168.2.1/admin into the background at client input

Now you can manage the forum, you can add the plate in it

Here's the game section you created

Now to install another file package with PHP, unzip the discussion forum under this package, unzip into a folder after the copy of the package, copy it to C:\inetpub\wwwroot\discuz!_utf8

The following access to the discovery cannot access the local

This database file "install.php" is found below

The following discovery provides access to the

Choose to accept the following criteria

We need to make some changes here.

Now it's time to start installing the

Successful database table creation

Check it out on MySQL and find out more dname this database

Discover the success of establishing a data list creation

Experiment three: mysql+php's website construction