php 粉丝关注功能实现

实现粉丝关注功能的步骤如下：

1. 创建用户表（user）和关注表（follow）：

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `follow` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `follower_id` int(11) NOT NULL,
  `following_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

1. 实现用户注册和登录功能

2. 实现用户查找和关注功能：

// 用户查找函数
function findUser($username) {
    $query = "SELECT * FROM user WHERE username='$username'";
    $result = mysqli_query($conn, $query);
    return mysqli_fetch_assoc($result);
}

// 关注函数
function followUser($follower_id, $following_id) {
    $query = "INSERT INTO follow (follower_id, following_id) VALUES ('$follower_id', '$following_id')";
    $result = mysqli_query($conn, $query);
    return $result;
}

1. 实现用户关注列表和粉丝列表：

// 获取用户关注列表
function getFollowingList($user_id) {
    $query = "SELECT user.username FROM user JOIN follow ON user.id=follow.following_id WHERE follow.follower_id='$user_id'";
    $result = mysqli_query($conn, $query);
    $following_list = array();
    while ($row = mysqli_fetch_assoc($result)) {
        $following_list[] = $row['username'];
    }
    return $following_list;
}

// 获取用户粉丝列表
function getFollowerList($user_id) {
    $query = "SELECT user.username FROM user JOIN follow ON user.id=follow.follower_id WHERE follow.following_id='$user_id'";
    $result = mysqli_query($conn, $query);
    $follower_list = array();
    while ($row = mysqli_fetch_assoc($result)) {
        $follower_list[] = $row['username'];
    }
    return $follower_list;
}

以上就是实现 PHP 粉丝关注功能的基本步骤，可以根据自己的需求和实际情况进行相应的修改和扩展。