Use ASP to create a personalized Forum (on)

Nowadays, online forums are everywhere, but I wonder if you have encountered such a situation: Looking for the content you want in the disorganized discussion information, it is a very time-consuming and laborious task. Later on, you don't want to go to any forums. So can we add a review function for the content of our website forum? That is, all the posts posted to the forum by netizens are not immediately displayed. They must be reviewed by the webmaster or moderator and considered valuable. If they are recommended to other netizens, they will be published. Otherwise, it will be deleted, so as not to waste space and make it a bit like an excellent area. In this way, your forum can provide clear and beneficial content compared with other forums. Put it on your website to attract more users. This idea can certainly be implemented. Next I will briefly introduce how to make it.
Note: this article applies to users who have some knowledge about ACCESS databases, HTML and ASP.
I. Forum Structure Analysis
Through the above functional requirements analysis, we can divide forum production into four parts:
(1) User Registration and Management Module: because webmasters or moderators are introduced, they must be able to authenticate in the forum. The function of this module is to manage registered users and provide related queries. For example, you can query all the articles published by the specified author and the Ten netizens who have published the most articles. If your forum is not very large, this module can be omitted as only having the moderator authentication function, and the registration and query sections are removed.
(2) Article Display Module: displays the articles that are recommended by all moderators for review.
(3) Post module: provides users with a place where they can post their posts. The Post will be reviewed by the moderator.
(4) Article Review Module: The moderator has decided whether to post or delete any published but unreviewed articles on the Internet.
After learning about the specific functional requirements, you can start designing the forum according to the module. Of course, these modules only divide the Forum structure in terms of functions. In fact, they cannot be completely designed independently. For such small applications, there is no need to fully modularize the design. It may be easier to directly write program code under good planning.
There are two methods to implement the Forum: Using files or databases. Relatively speaking, the use of databases should be simpler and more efficient, so as to better control the forum and provide some verification and protection for the materials. Here I am using an ACCESS database. For small and medium-sized applications, ACCESS should be competent.
From the above analysis, we can see that there should be four tables. Below I will show the structure of each table.
(1) Author table (used to store author information ):
ID: text type, required. It is a netizen code.
Password: text type, required.
Nickname: text type, required.
EMAIL: text type, required.