Build the second automatic news publishing system for your website (posting)

Source: Internet
Author: User
Tags access database
(1) construct a news database
Analyze the elements that constitute each piece of news, including the News title, news content, image address, connection address, and news release time. While building databases. Considering the processing needs, the ID of the news must be added for identification. In addition, you can add statistics to understand the interesting content of the reader. Access Database is a database that is very suitable for the development stage. We construct the following news database (data. mdb)
Table data
News_id long news number
News_class text news category
News_class_name the category name of the text news
News_title text news title
Whether news_head logic is displayed on the homepage
Content of news_comment comment News
News_year text news year
News_month month of text news
Content of news_day text news
News_time text update time
News_delete logic delete flag
    
This table is created according to the above requirements. After the test is stable, we can transfer the news database to SQL server.
. Now, let's take a look at this step to create a news management page. For the convenience of layout and management, we adopt
Make the following page for the framework structure. The main file of the webadmin.htm framework.
    
    
Html
    
Head
Meta http-equiv = "Content-Type" content = "text/html; charset = gb2312"
Title: news and publishing system management page/title
Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.