Backend Development
PHP Tutorial
javascript - The article content and the problem of displaying comments. Please give me some advice.
javascript - The article content and the problem of displaying comments. Please give me some advice.
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
Reply content:
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
The table design is fine. SQL error
According to the way you write it, it is wrong, because the comments are 1 to many, all comments must be displayed, and the table with many must be left connected as the main table.
But although you can write like this, it is not recommended, because you can simply search the article, and the comments are checked based on the ID. There is no need to go to the left link. The time for the two searches is faster than the time you mentioned above, so there is no need. Then write.
SQL statement: 1. Check the article content 2: Check the comments, limit 1,10, and then the comment table left link user table, conditional article id
Check the article content and comment list separately. The more functions a SQL statement has, the more troublesome it will be to change it in the future.
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1665
14
1423
52
1321
25
1269
29
1249
24
The Continued Use of PHP: Reasons for Its Endurance
Apr 19, 2025 am 12:23 AM
What’s still popular is the ease of use, flexibility and a strong ecosystem. 1) Ease of use and simple syntax make it the first choice for beginners. 2) Closely integrated with web development, excellent interaction with HTTP requests and database. 3) The huge ecosystem provides a wealth of tools and libraries. 4) Active community and open source nature adapts them to new needs and technology trends.
HTML vs. CSS and JavaScript: Comparing Web Technologies
Apr 23, 2025 am 12:05 AM
HTML, CSS and JavaScript are the core technologies for building modern web pages: 1. HTML defines the web page structure, 2. CSS is responsible for the appearance of the web page, 3. JavaScript provides web page dynamics and interactivity, and they work together to create a website with a good user experience.
Laravel8 optimization points
Apr 18, 2025 pm 12:24 PM
Laravel 8 provides the following options for performance optimization: Cache configuration: Use Redis to cache drivers, cache facades, cache views, and page snippets. Database optimization: establish indexing, use query scope, and use Eloquent relationships. JavaScript and CSS optimization: Use version control, merge and shrink assets, use CDN. Code optimization: Use Composer installation package, use Laravel helper functions, and follow PSR standards. Monitoring and analysis: Use Laravel Scout, use Telescope, monitor application metrics.
Using React with HTML: Rendering Components and Data
Apr 19, 2025 am 12:19 AM
Using HTML to render components and data in React can be achieved through the following steps: Using JSX syntax: React uses JSX syntax to embed HTML structures into JavaScript code, and operates the DOM after compilation. Components are combined with HTML: React components pass data through props and dynamically generate HTML content, such as. Data flow management: React's data flow is one-way, passed from the parent component to the child component, ensuring that the data flow is controllable, such as App components passing name to Greeting. Basic usage example: Use map function to render a list, you need to add a key attribute, such as rendering a fruit list. Advanced usage example: Use the useState hook to manage state and implement dynamics
Which 2025 currency exchanges are more secure?
Apr 20, 2025 pm 06:09 PM
The top ten safe and reliable exchanges in the 2025 cryptocurrency circle include: 1. Binance, 2. OKX, 3. Gate.io (Sesame Open), 4. Coinbase, 5. Kraken, 6. Huobi Global, 7. Gemini, 8. Crypto.com, 9. Bitfinex, 10. KuCoin. These exchanges are rated as safe and reliable based on compliance, technical strength and user feedback.
The Compatibility of IIS and PHP: A Deep Dive
Apr 22, 2025 am 12:01 AM
IIS and PHP are compatible and are implemented through FastCGI. 1.IIS forwards the .php file request to the FastCGI module through the configuration file. 2. The FastCGI module starts the PHP process to process requests to improve performance and stability. 3. In actual applications, you need to pay attention to configuration details, error debugging and performance optimization.
How to import the source code of wordpress
Apr 20, 2025 am 11:24 AM
Importing WordPress source code requires the following steps: Create a sub-theme for theme modification. Import the source code and overwrite the files in the sub-topic. Activate the sub-theme to make it effective. Test the changes to make sure everything works.
What happens if session_start() is called multiple times?
Apr 25, 2025 am 12:06 AM
Multiple calls to session_start() will result in warning messages and possible data overwrites. 1) PHP will issue a warning, prompting that the session has been started. 2) It may cause unexpected overwriting of session data. 3) Use session_status() to check the session status to avoid repeated calls.
