Sharing of development practices using PHP for mutual attention functions

Sharing the practice of developing mutual follow function using PHP

With the rapid development of social networks, the mutual follow function has become a must-have on major social platforms One of the functions. Whether it is Weibo, WeChat, or Instagram, users can follow each other to follow other people's updates and establish interactive relationships with them. This article will share how to use PHP to develop the mutual attention function to help developers better understand and apply this function.

1. Functional requirements analysis
Before developing the mutual attention function, we first need to clarify the functional requirements. Usually the mutual following function should include the following aspects:

1. User following: Users can choose to follow other users to see their updates on their homepage.
2. Following list: Users can view the list of users they have followed and can unfollow them.
3. Fans list: Users can view the list of users who follow them.
4. Dynamic display: Users can see the latest updates of followed users on the homepage.

2. Database design
Before functional development, we need to design database tables to store relevant data. The following is the database table design required for the mutual follow function:

1. User table (user)
   Fields: user ID (user_id), user name (username), password (password), etc.
2. Following relationship table (following)
   Fields: follower ID (follower_id), followed person ID (followed_id), following time (follow_time), etc.

3. Function Implementation

1. User Follow
   When the user clicks the follow button, we need to insert the follower ID and the followed ID into the follow relationship table , and set the attention time. The specific code is as follows:

$follower_id = $_GET['follower_id'];  // 获取关注者ID
$followed_id = $_GET['followed_id'];  // 获取被关注者ID
$follow_time = time();  // 获取当前时间

$sql = "INSERT INTO following (follower_id, followed_id, follow_time) VALUES ($follower_id, $followed_id, $follow_time)";
$result = mysqli_query($conn, $sql);

2. Following list and fan list
   Users can query the following relationship table to obtain the list of users who have followed and followed themselves. The specific code is as follows:

$user_id = $_GET['user_id'];  // 获取用户ID

// 查询关注列表
$sql1 = "SELECT * FROM following WHERE follower_id = $user_id";
$result1 = mysqli_query($conn, $sql1);

// 查询粉丝列表
$sql2 = "SELECT * FROM following WHERE followed_id = $user_id";
$result2 = mysqli_query($conn, $sql2);

// 输出关注列表
while ($row1 = mysqli_fetch_assoc($result1)) {
    $followed_id = $row1['followed_id'];
    $followed_user = mysqli_query($conn, "SELECT * FROM user WHERE user_id = $followed_id");
    $row = mysqli_fetch_assoc($followed_user);
    echo $row['username'];  // 输出关注的用户名
}

// 输出粉丝列表
while ($row2 = mysqli_fetch_assoc($result2)) {
    $follower_id = $row2['follower_id'];
    $follower_user = mysqli_query($conn, "SELECT * FROM user WHERE user_id = $follower_id");
    $row = mysqli_fetch_assoc($follower_user);
    echo $row['username'];  // 输出粉丝的用户名
}

3. Dynamic display
   Users can query the following relationship table and dynamic table to obtain the latest updates of the users they have followed. The specific code is as follows:

$user_id = $_GET['user_id'];  // 获取用户ID

// 查询关注列表
$sql = "SELECT * FROM following WHERE follower_id = $user_id";
$result = mysqli_query($conn, $sql);

// 输出动态列表
while ($row = mysqli_fetch_assoc($result)) {
    $followed_id = $row['followed_id'];
    $dynamic = mysqli_query($conn, "SELECT * FROM dynamic WHERE user_id = $followed_id ORDER BY dynamic_time DESC LIMIT 10");
    while ($row = mysqli_fetch_assoc($dynamic)) {
        echo $row['content'];  // 输出动态内容
    }
}

4. Summary
The development of the mutual attention function is basically the operation of adding, deleting and checking the database. Through the code examples in this article, we can better understand the implementation principle of the mutual attention function, and can optimize and expand accordingly according to actual needs. I hope this article will be helpful to the development practice of using PHP to carry out mutual attention functions.

The above is the detailed content of Sharing of development practices using PHP for mutual attention functions. For more information, please follow other related articles on the PHP Chinese website!