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
2. User table (no pictures if there is no problem)
3. User comment table
4.thinkphp gets a single article and displays the comment content code
5. Front-end display
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