使用PHP进行互相关注功能的开发实践分享

$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);

$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'];  // 输出粉丝的用户名
}

$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'];  // 输出动态内容
    }
}