How can you best associate comments with specific news articles in PHP when using separate tables for news and comments?

To associate comments with specific news articles in PHP when using separate tables for news and comments, you can create a foreign key relationship between the two tables. In the comments table, include a column that stores the ID of the news article that the comment is related to. This way, you can easily retrieve and display comments for a specific news article. 

// Assuming you have a news table with columns id, title, content
// and a comments table with columns id, news_id, comment

// Create a foreign key relationship between the news_id column in the comments table and the id column in the news table
CREATE TABLE comments (
    id INT PRIMARY KEY,
    news_id INT,
    comment TEXT,
    FOREIGN KEY (news_id) REFERENCES news(id)
);

// Retrieve comments for a specific news article
$news_id = 1; // ID of the news article
$query = "SELECT * FROM comments WHERE news_id = $news_id";
// Execute the query and display the comments

Keywords

PHP MySQL Database Foreign key Relationship

Related Questions