php 粉丝关注功能实现
实现粉丝关注功能的步骤如下：
- 创建用户表（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;
-
实现用户注册和登录功能
-
实现用户查找和关注功能：
// 用户查找函数
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;
}
- 实现用户关注列表和粉丝列表：
// 获取用户关注列表
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 粉丝关注功能的基本步骤，可以根据自己的需求和实际情况进行相应的修改和扩展。