The content of the article and the problem of displaying comments. Please give me some advice.

WBOY
Release: 2016-09-09 08:13:10
Original
1325 people have browsed it

I am blogging by myself recently. The article function. The user clicks on the article ID to enter the detailed article content display page and the user comment content corresponding to the current article. Here are my thoughts. I don't know if there are any shortcomings. I hope all the experts can give me some advice. Thank you
1. Article table
The content of the article and the problem of displaying comments. Please give me some advice.
2. User table (no pictures if there is no problem)
3. User comment table
The content of the article and the problem of displaying comments. Please give me some advice.

4.thinkphp gets a single article and displays the comment content code
The content of the article and the problem of displaying comments. Please give me some advice.

5. Front-end display
The content of the article and the problem of displaying comments. Please give me some advice.
Question 1: When getting a single article. Check whether the comment content corresponding to the current article is in a sql statement, and then perform paging of the comment content.
Question 2: No. 3 above. When a user comments on an article multiple times. The data I queried here are all repeated. Because I query based on the article ID.
In summary: Is there a problem with my table design? Is there any problem with the sql query?
Thank you for your advice

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template