PHP development: How to implement article likes and comments functions

PHP development: How to implement article likes and comments functions

With the development of the Internet, users have more participation needs for information and content, website articles The like and comment functions have become an important part of user interaction. This article will introduce how to use PHP to develop and implement article likes and comments functions, and provide specific code examples.

1. Implementation of the like function

1. Database design:

First, we need to create a table in the database to store user likes Information. You can create a table named "likes", containing the following fields: id (unique identifier of the like record), user_id (ID of the user who liked it), article_id (ID of the liked article), created_at (time of like) .

2. Add a like button:

In the article page, add a like button, and the user clicks the button to trigger the like action.

<button onclick="likeArticle(<?php echo $article_id; ?>)">点赞</button>

3. Processing like operations:

In PHP, add a function to process likes. The specific implementation is as follows:

function likeArticle($article_id) {
    // 获取用户ID，这里假设用户已登录且用户ID存储在$user_id变量中
    
    // 查询点赞记录
    $sql = "SELECT * FROM likes WHERE user_id = $user_id AND article_id = $article_id";
    $result = mysqli_query($conn, $sql);
    
    if (mysqli_num_rows($result) == 0) {
        // 用户未点赞过该文章，进行点赞操作
        $sql = "INSERT INTO likes (user_id, article_id, created_at) VALUES ($user_id, $article_id, NOW())";
        mysqli_query($conn, $sql);
    } else {
        // 用户已点赞该文章，取消点赞操作
        $sql = "DELETE FROM likes WHERE user_id = $user_id AND article_id = $article_id";
        mysqli_query($conn, $sql);
    }
}

Through the above code , after the user clicks the like button, corresponding operations will be performed based on whether the user has liked the article.

2. Implementation of the comment function

1. Database design:

In order to realize the comment function of the article, we need to create a table named The "comments" table contains the following fields: id (the unique identifier of the comment record), user_id (the comment user's ID), article_id (the commented article ID), content (comment content), created_at (comment time).

2. Add comment form:

In the article page, add a comment form for users to fill in the comment content, and add a submit button.

<form method="post" action="comment.php">
    <textarea name="content" placeholder="请输入评论内容"></textarea>
    <button type="submit">提交评论</button>
</form>

3. Processing comment operations:

Create a PHP file named "comment.php" to process the comment data submitted by the user. The specific implementation is as follows:

<?php
// 获取用户ID，这里假设用户已登录且用户ID存储在$user_id变量中

// 获取文章ID
$article_id = $_POST['article_id'];

// 获取评论内容
$content = $_POST['content'];

// 插入评论记录
$sql = "INSERT INTO comments (user_id, article_id, content, created_at) VALUES ($user_id, $article_id, '$content', NOW())";
mysqli_query($conn, $sql);
?>

After the user submits a comment, the comment content will be inserted into the database, that is, the comment function is successfully implemented.

Summary:

Through the above steps, we have completed the implementation of the article likes and comments function in PHP development. Users can click the like button to like or unlike the article, and they can also submit comments to comment on the article. These features can increase the interaction between users and the website and provide a better user experience.

Note: The above code examples are for reference only and may need to be modified and optimized according to specific circumstances in actual applications. At the same time, in order to ensure security and data integrity, it is recommended to perform security filtering and verification of data entered by users.

The above is the detailed content of PHP development: How to implement article likes and comments functions. For more information, please follow other related articles on the PHP Chinese website!