| Back to logs list
2095783 2009 年 11 月 11 日 10:00 Reading (loading. ..) Comments (0) Category: Notes
DreamWeaver to create Web query system (Pengcheng IT network)
This tutorial assumes you have HTML, Photoshop 6.0, ASP, Access 2000, Web configuration is already very familiar with, while Dreamwaver MX for the static and dynamic page production has some basis. If you are not very familiar with these technologies, please refer to the relevant books, or to explore the site forums.
This tutorial is one of my city 114 main telephone number inquiry procedures described, function is relatively simple. Therefore, if you read this tutorial, then, is not difficult to develop a more advanced program.
tutorial divided into 8 speakers, namely: Lecture: Functional Design, Second Lecture: Designing the database, the third lesson: design web graphics and cut map, Fourth: create a site in Dreamweaver MX and plan the site, Fifth Lecture: Creating static pages related to each, Lecture: The modified static pages to dynamic pages, SEVEN: Manage the preparation process, the eighth lesson: the overall test.
following the first lecture: functional design
telephone number inquiry we all know you can search through the 114 phone, but the query results only include the telephone corresponding to the names of businesses or individuals. Other information is not available, but also need to pay telephone charges, if achieved through the network will be very convenient. Currently, phone number search on the Internet site a lot, and their features are very strong, not only do the most basic telephone number search, but also includes business information, business promotion, as well as member companies of product sales and other activities. They all belong to an e-commerce site has. We want to design the program can be as complex without them, then we want to achieve what functions? I said what a simple functional requirements:
1, headed by entering a business name or the name of inquiry telephone number;
2, enterprise data includes enterprise contact information and business description;
3, enterprises can achieve ranking hot company can be displayed on each check the recommended location of enterprise, to achieve better information;
4, enterprise management class can be customized, and can operate in accordance with enterprise class inquiry telephone number;
5, companies can not fill out the online registration form to achieve auto-commit;
6, to provide background management. Including the audit forms submitted by the enterprise, the enterprise ranking display, focusing on recommended settings enterprises;
how, function is not okay? Now I say that our technical features:
1, by Include (included) in the form of organization page, make the program module;
2, page design using Photoshop 6.0, while cutting diagram, constructed from the overall perspective to facilitate page layout;
3, in the database the use of
5, manually modify the code generated by Dreamweaver MX and explain the code, so you want to develop their own capabilities.
how to have confidence? Yes, to pick up the mouse, we have together!
our program select the database used by Microsoft Access 2000, chose him because he is quite small, is included in Office 2000, for less traffic and data applications, but also easy to learn. If you are using SQL Server 2000 database or something else, then you can in this tutorial to build your database system, the appropriate library.
we open the Access 2000, Access will first let us in the first screen, select an existing database or create a new database, if we are new,
After secretly old .80 after the 80 must-see !, you can choose database name and select the database corresponding to the path. If the open end of the database has been established, you can select the following list box inside an existing. Or choose
way of positioning the database by hand. Figure 2-1:
no matter what, we will enter the database design view. Figure 2-2:
Now, our new data table, in the window, select telephone number table, were named, hy and tele.
to note here is that we build through the tele hy_id field inside the table, between the tables on the industry to achieve Meanwhile, in a telephone table in addition to setting basic telephone inside information, but also set a number of landmark field. For example: Is_Top, Is_Good, Is_Pass. Meaning: If Is_Top value is 1, the provision of information in the telephone directory in the top of the display. Is_Good the recommended mark, if this field is 1, then this section will be displayed in red numbers. The Is_Pass said that if the user fill out the form online, then fill in the content will not be immediately displayed to the query results, but rather the future through our audit, through the audit can be displayed. So, if the field is 1, then said it had approved. The default value of the above three fields are 0.
this point, we finished the database will be established. We note that the relationship between the main building and the establishment of the field signature. These will effectively improve the function of our program.
the next section, we will introduce the design of web graphics and cut map, so that our website has a first visual effect.
If the page does not
image, then the effect of certain bad. For web graphics production, each has its own method of making friends. For example, some friends like to use an image of each painting an image; some friends like to find some other sites directly Gif animated images or material modification of material inside the library directly into their web pages. As that method is better, I'm not going evaluation, after all, each have their own benefits.
Here, I talk about me page steps: The first step is to use Photoshop to create a 760 pixel wide and more than 1,000 high-canvas, completed in the fabric to draw the image of each page. If the page has Flash animation, they left the location, later in the Flash in the production. The second step is to cut the page draw a good map. The third step, put together in Dreamweaver MX in the cut graph. The fourth step, draw the next page. Again and again, until all the pages are unfinished. This is my picture page
step, of course, painting the page can be completed in Fireworks or Imageready, to do with their pages also can create drop-down menus, animation or visual effects better. However, because we mainly process-oriented and not too much to pursue a better visual effect. Still others like dynamic Flash stations, the order of their production is only Flash, ASP (ASP backing if the programming environment) and databases in the future I will also launch a 【using Flash MX 2004 + Dreamweaver MX 2004 + ASP + Access2000 to create Flash Guestbook】 tutorial introduction.
final say about the above steps to create a site when a person steps. If your site is relatively large, have specialized programmers write programs, but also the corresponding graphic design interface, as the database, and even to establish a database of specialized personnel. The method then it will not be just a few steps. After all, we have a lot of friends who are engaged in a website, what by one person, then this tutorial is for you. (But this form is not a regular form, like a company engaged in only one person, so how can companies do big. But in the early development of the Internet in China, only that the ^_^)
page cut plans stored in the package, which contains the cutting diagram and the whole station has been cut small pictures. As for how to cut chart, see your Photoshop books.
pages and cut through the painted figure, on our website layout're all done, the rest of the things you can create a web page. If you find that some features are not taken into account, also need to modify the database or re-edit pages cut map. Then I can be very tough to tell you: a wide-pill, but try not such a problem)
our page layout by Dreamweaver MX. In the layout, you need to build the site (can not tell me you do not have the habit of construction site), construction site is necessary to create dynamic websites. Law can not ignore. I strongly do not recommend using Frontpage to create dynamic websites.
First, in the PWS or IIS, a web site, the establishment of methods refer to the relevant books. Since my machine can only install win98, so I use the PWS (pain ah), see the following figure 4-1:
Then, in the folder where the web site established within the appropriate directory structure, this step can be completed in the Explorer. Figure 4-2:
need to explain that I am in my local disk pcitw E created a folder on the site. Also create a 114, common, db three folders. Sections were 114 folders, general files and databases folder. In the 114 folder and then create images and manage the following folder to save the 114 columns need to use the pictures and future management page. The Dreamweaver MX Connections folder is generated automatically, to save the database connection, the latter will be used (other folders on the machine for my other sites, without reference)
this point, our web sites and web site has been created complete directory structure. Directory structure of the construction process can also be the site in Dreamweaver mx window to complete. Remaining is to create a Dreamweaver MX site.
open Dreamweaver Mx, select Menu - Classes in the local information site, local conditions set in the
If the test in the machine, then the class can not set the remote information. The following classes set up a test server, and input data according to the situation. Select the server type ASP Vbscript (If you prefer to use other languages can choose the appropriate option ASP) access method selected Local / Network, said the local test page. Enter the folder in the test server Web folder just created the absolute path here must correspond. Finally, the prefix in the url to enter the local file access method 4-4:
other settings as the tutorial classes are not used, therefore not introduced.
ok, our web site, web site directory situation, dreamweaver Mx sites are built finished. The future we will be able to easily build dynamic Web pages complete.
put down the mouse, pick up the controller and play for a Contra,
12 constellation figures Naruto chapter - Qzone lo, and relax.
through the production of the previous sections, the site preparatory work has been initially completed and construction started to build this section in all 114 pages. Arrangements for the page file is this:
top_114.asp: are all top of the page in the site root / common folder below;
buttom.htm: the bottom of all pages, but also in the site root / common folder below;
by the above two files are included in the ASP's include command to the appropriate page, this was done to make the site modular, reduce the workload.
index.asp: 114 Home
search.asp: telephone number search results page;
seek_tel.asp: query form, as each page contains the query part,, so this section also make a Individual files are other files contained;
login_tel.asp: fill out the online registration page;
disp_tele.asp: show that the information page that contains the telephone number, number of the corresponding unit, unit description, etc.;
login_ok.asp: fill out the online registration is completed when the displayed page;
where you only need to pay attention to typographic skills, the other little too much. In addition, use the form http to access these pages, that is,
First, to establish a database connection
In the fourth step to our site has been created. Dynamic pages in the constructor, we first Dreamweaver MX to create a connection between the database, follow these steps:
1, which in the Applications tab, select the database item, then click the plus button and select custom connection string
2, the Data Source Setup dialog box, the respective input data source name and connection string. Connection string used to connect to the database, where we press the absolute path of the format input: , here be noted that, in quotation marks to find all content must be written in the format, the database path and file name based on the actual case may be, as shown in Figure 6-2:
After the above three steps, the database connection is established is completed. Then look at the database panel will be able to show the database structure. Figure 6-3:
establishing a database connection, in essence, is the root of our established a Connections folder, and in that folder and we established a data source name specified in the same asp file. Immediately familiar with asp Nengkanmingbai a friend, which turned out to be a variable definition. That is: MM_db114_STRING = is not on the database connection. How to modify, we will explain later. Figure 6-4:
far, we have established a connection to the database, after any operation, as long as the related database, the connection just created should be used. Of course, if your site requires a lot of databases, then you will create multiple database connections. Because a connection can only correspond to a database.
Finally, we set the time, but click on a company detail page should display the connection, which is called disp_tele.asp shows the corresponding business or personal phone number for more information, here we are in the form through the id parameter passed to the disp_tele . asp page. Selected dynamic text on the page, and then in the address bar the following: disp_tele.asp? Company_id =, as shown in Figure 6-8:
Second, convert the dynamic pages will index.asp
from this section, we gradually build in front of the static pages into dynamic pages, and database to combine in order to complete our final page. Home
First we need to convert the dynamic pages. In the home, only the right side of the show on it.
ok, to work. Step 1, a data set. In the binding panel, select Recordset (Query) menu, and in the dialog box shown in Figure 6-5.
select the appropriate content. At this point, the data set has been set up, has been shown to bind the data table panel field situation. The following step 2, the company name onto the page in order to display the field in the page content. See Figure 6-6:
to now, we have a record in the database appear on the page, but our aim is not to display a record, but shows 10 records. Therefore, we have to construct repeat region behavior, only then can we specify the number of records will be displayed on the page. To construct the repeat region behavior, select the tr> section.
Finally, we set the time, but click on a company detail page should display the connection, which is called disp_tele.asp shows the corresponding business or personal phone number for more information here, we are by id parameters are passed to the disp_tele.asp page. Selected dynamic text on the page, and then in the address bar the following: disp_tele.asp? Company_id = <% = rs_cztj (will disp_tele.asp and right_114.asp converted to dynamic pages
God, just got the news, November 5 until supply of heating, I've got a few days. Pain ah!
disp_tele.asp page today to talk about construction, features of this page is to show detailed corporate or personal data. Page function is not very complicated, let's go!
Here, we first agreed, calling the format of the page: recommended industry enterprise business. We do not have dreamweaver mx comes to detailed pages that act, we are filled out by hand code.
first page to construct a recordset to display the phone number specified in the corresponding detailed corporate information, pay attention to some url parameters, see Figure 6-9:
record set after set up, the word paragraphs were dragged to the corresponding page location. To display the field contents.
Then, in the structure corresponds to the recommendation of the relevant industry sector enterprise records set. But due in part to save the page as a separate, so you want to modify right_114.asp file. This step requires the definition of advanced recordset dialog box, and manually fill in part of the code. See Figure 6-10:
drag the company name to the page, and create repeat region behavior. Last modified dreamweaver mx manually generated code in order to have time when there is no category parameter recommended value shown. Modifications see Figure 6-11:
ok, after the above changes, regardless of whether the call parameters to provide hy_id are appropriate based on our intention to show the super recommended. That is, if no parameters will display all of the recommendations (Top 10) and, if appropriate category shows the top 10.
the end of this section, where the need to remind you, dreamweaver mx best to study the generated code to understand. Do not expect dreamweaver mx to you automatically generate a website, you do not have to change his party. Not the kind of good things.
Linear Mode
