当前位置：首页 > PHP

php实现主动关注

2026-03-13 06:35:47PHP

实现主动关注功能的方法

在PHP中实现主动关注功能通常涉及数据库操作、用户身份验证和前后端交互。以下是实现这一功能的关键步骤：

数据库设计

创建用户表和关注关系表是基础。用户表存储用户信息，关注表记录用户之间的关注关系。

用户表结构示例：

php实现主动关注

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL,
    email VARCHAR(100) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

关注表结构示例：

CREATE TABLE follows (
    follower_id INT NOT NULL,
    followed_id INT NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (follower_id, followed_id),
    FOREIGN KEY (follower_id) REFERENCES users(id),
    FOREIGN KEY (followed_id) REFERENCES users(id)
);

关注操作处理

处理关注请求需要验证用户身份并更新数据库。以下是一个简单的PHP处理脚本：

php实现主动关注

<?php
// 确保用户已登录
session_start();
if (!isset($_SESSION['user_id'])) {
    header("HTTP/1.1 401 Unauthorized");
    exit;
}

// 获取当前用户ID和被关注用户ID
$followerId = $_SESSION['user_id'];
$followedId = $_POST['followed_id'];

// 数据库连接
$db = new PDO('mysql:host=localhost;dbname=your_database', 'username', 'password');

// 检查是否已关注
$stmt = $db->prepare("SELECT * FROM follows WHERE follower_id = ? AND followed_id = ?");
$stmt->execute([$followerId, $followedId]);

if ($stmt->rowCount() > 0) {
    // 已关注，执行取消关注
    $stmt = $db->prepare("DELETE FROM follows WHERE follower_id = ? AND followed_id = ?");
    $stmt->execute([$followerId, $followedId]);
    echo json_encode(['status' => 'unfollowed']);
} else {
    // 未关注，执行关注
    $stmt = $db->prepare("INSERT INTO follows (follower_id, followed_id) VALUES (?, ?)");
    $stmt->execute([$followerId, $followedId]);
    echo json_encode(['status' => 'followed']);
}
?>

前端交互实现

使用AJAX实现无刷新关注操作：

document.querySelector('.follow-button').addEventListener('click', function() {
    const userId = this.dataset.userId;
    fetch('/follow.php', {
        method: 'POST',
        headers: {
            'Content-Type': 'application/x-www-form-urlencoded',
        },
        body: `followed_id=${userId}`
    })
    .then(response => response.json())
    .then(data => {
        if (data.status === 'followed') {
            this.textContent = '取消关注';
        } else {
            this.textContent = '关注';
        }
    });
});