ASP advanced article Online Management Update (1)

When you have a website of your own, especially for those with large flow, more content of the site, the daily update site has become one of your first tasks to maintain the site, but often found the data, but also to make the relevant pages, and then use FTP and other tools to upload the future of their own pages to update, This is not for those who have small traffic, and the time is sufficient for the administrator of course, but when your site has a certain scale, such updates become a heavy task. Is there a way to find information on the Internet, and then online update management, and the page can maintain automatic updates and automatically generate browsing page? The answer is yes, and when the ASP appeared, it became a simple thing!

First I briefly introduce what we will implement online article management have those functions, the use of ASP database management we can implement the article section of the online add, modify, delete, online modify the administrator name, password, add new columns, article section of the search function, the article automatically generated display, As well as the article's forwarding mailbox and other functions! Its operating environment is: Windows95 +pws+access97 (2000) or Windows NT+IIS4+ACCESS97 (2000) or Windows2000 (with IIS5) +access97 (2000).

Here's a step-by-step procedure for you to implement this feature:

First we will explain the establishment of the database and its specific structure

(1). Use Access to create a database named Bookid.mdb blank

(2). Create a table 1:admin to hold the administrator name and password information, which is structured as follows:

Field name Segment data type description

ID Auto Number

USERNAME text Here you can enter your administrator's name, also can be modified online

PASSWORD text input Administrator password, can also be modified online

(3). Create a table 2:type to hold the column information of the article, its structure is:

Field name Segment data type description

typeID Automatic Numbering

Type text Enter the articles you need, or add them online, modify

(4). Create a table 3:article, to save the title, content, update date and other information, the structure is:

Field name Segment data type description

ArticleID Automatic Numbering

Title text field Size 40, enter the title of the article, you can add online, modify

Content Notes Enter the contents of the article, you can add it online, modify

typeID numbers are used to establish an association with table 2

HITS Digital Records Click to browse articles number

Date Date/Time record the time the article was added

Well, set up the database structure of the program we can start to write related programs, the next one I will introduce the article Management system database connection.