상호 주목 기능을 위해 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']; // 输出动态内容 } }