DreamWeaver creates a Web query system

This tutorial assumes that you are familiar with HTML, Photoshop 6.0, ASP, Access 2000, and Web configuration. At the same time, you also have a foundation for static and dynamic page creation of Dreamwaver MX. If you are not familiar with the above technologies, please refer to relevant books or go to the forum to discuss them.
This tutorial is based on a 114 phone number query program in my city. The function is relatively simple. Therefore, if you understand this tutorial, it is not difficult to develop more advanced programs.
The tutorials are divided into 8 Lectures: Lecture 1: Functional Design, Lecture 2: Design database, Lecture 3: Design Web images and cut images, and Lecture 4: create a site in Dreamweaver MX, plan the site and Lecture 5: create related static pages, Lecture 6: change static pages to dynamic pages, Lecture 7: prepare background management programs, and Lecture 8: overall test.

The first part is about function design.

You all know that you can query the phone number by phone number 114, but the query result only includes the name of the enterprise or individual corresponding to the phone number. Other materials cannot be obtained, and the telephone fee must be paid. It is very convenient to use the network. Currently, there are many phone number query websites on the Internet, and their functions are very powerful. They not only achieve the most basic phone number query, it also includes enterprise information, enterprise promotion, and product sales of member enterprises. They all belong to e-commerce sites. The programs we want to design are not as complex as they are. So what functions should we implement? Let me talk about the simple functional requirements:

1. Enter the company name or owner name to query the phone number;
2. Enterprise information includes the company's contact information and business introduction;
3. Enterprises can achieve rankings, and hotspot enterprises can be displayed in the recommended positions for each query to achieve better publicity;
4. The business category of an enterprise can be customized, and the telephone number can be queried according to the business category of the enterprise;
5. Enterprises without registration can enter a form online for automatic submission;
6. Provides background management. Including review of enterprise submission forms, display rankings of enterprises, and setting of key recommendation enterprises;

How about the functions? Let me talk about our technical features below:

1. Organize pages in the form of Include to modularize the program;
2. Use Photoshop 6.0 to design the page and cut the page at the same time to facilitate the construction of the page layout from the overall perspective;
3. Use the "one-to-many" relationship in the database to construct the database and make its design more reasonable;
4. Use the Dreamweaver MX design page and apply the "database behavior" to create a webpage. This gives you the power of Dreamweaver MX;
5. Manually modify the code generated by Dreamweaver MX and explain the code so that you can develop the desired function.

How about it? Are you confident? If there is one, we will pick up the mouse and let's get together!

Microsoft's Access 2000 is selected for the database used by our program. The reason is that it is relatively small and included in Office 2000, which is suitable for applications with low Access volume and small data volume, it is also easy to learn. If you are using SQL Server 2000 or any other database, you can create a database in your database system according to this tutorial.
We open Access 2000. First, Access will ask us to select an existing database or create a new database on the first screen. If we use it for the first time, we can select "null Access database ", this is the system will let us enter the database name and select the corresponding path of the database. To open a database that has been created, you can select an existing database from the list box below. Or select "more files ..."

Locate the database manually. See Figure 2-1:

In any case, we will go to the database design view. See Figure 2-2:

<