This article mainly helps you develop related forum designs based on MySQL databases. First, we started from the system architecture. If you are interested in the actual content, the following describes the specific solution and hope it will be helpful in your future study.
System Architecture:
The modular concept is divided into three layers:
A. Data storage layer: MySQL (the best combination with PHP) is used to store all data of bbs, including user information, article data, user mail, user message, and system data ?), Key Issue: Database Planning, whether to use files for assistance.
B. System Function Layer: completes the basic functions of bbs. It consists of multiple parallel modules. It calls MySQL (the best combination of PHP and PHP) functions to access the database, and then receives and processes requests, return the processed results to the upper layer, and return the success or failure results and other data based on the request type. The module is highly flexible and can be easily modified. Including:
The User Module processes user registration, modification of basic data, permission changes, and query of user information.
The layout module has the highest Database Requirements for publishing articles, reading articles, deleting Articles, marking articles, and checking the read, modify, and delete permissions.
Excellent area module, including excellent area articles, directory addition, deletion, up and down movement
?) Check the read, modify, and delete permissions. The directory structure is difficult.
Letter module, including sending new letters, reading and deleting letters, letterhead marking, and notifications of new letters
The message module includes sending, receiving, new, and review messages, and saving messages.
System Dynamic modules, including the current number of people on the site, the current status, due to frequent changes, such data may be better achieved with shared memory.
Chat module: Can two-person chat use icq for reference? Both parties can talk directly, but it may be difficult to save the chat result. At the same time, it is compatible with the telnet function, when the upper-layer service layer is telnet, a dedicated module is added for processing.
Does the chat room module use shared memory or database? Open the room, which contains permission issues. New functions can also be added as needed. For example, the event dashboard module does not make much sense for non-telnet terminals .....
3. Database Design
The key is the efficiency problem of MySQL (the best combination of PHP and MySQL). The memory for MySQL (the best combination of PHP and MySQL) is allocated rationally, especially for table cache
Size. What happens when the system suddenly loses power? Is MySQL (the best combination with PHP) robust?
The above content is an introduction to the Forum design that helps you develop MySQL-based databases.