Ultradev example tutorial: 5 Make a relatively simple website backend (1)
Author:Eve Cole
Update Time:2009-05-26 16:34:33
Chapter 5: Make a relatively simple website backend (1)
In this section, we will comprehensively utilize the display, insertion, editing, deletion and other functions we learned earlier to implement a relatively simple news release system.
First, let’s introduce the composition of this news release system:
Front part: The home page displays the latest 5 news updates. Click on the title of the news to view detailed information (including the content of the news and related links). There is also a More link pointing to one page to display 10 records per page.
Backend part: Log in to the function selection page through a password verification page. The function selection page provides jumps for adding, deleting, and modifying management users and adding, deleting, and modifying news.
According to the introduction in our previous course, our first task is to create a database. Please refer to the previous introduction for the creation process. Only the structure of the database table is given here. The database consists of two tables, one is the management user table, named admin; the other is the news record table, named article. See the chart structure below:
Except that the title in the table article takes the text type and the field size is 200; the default value for insert_time is:=Now(); and src takes the text type and the field size is 255, the rest as shown in the figure take the default value of access.
Next, save the newly created database, and then create a data source for this database. As shown in the picture:
After the data source name is created, let us open Ultradev, create a new site, name it News_Data, follow the previous method to create a database connection for this site, and then we can start! Everything is so simple!