当前位置：首页 > PHP

php实现多级评论

2026-03-13 06:34:18PHP

实现多级评论的数据库设计

多级评论需要递归或嵌套的数据结构。常见的数据库设计方案有两种：

邻接表模型（Adjacency List）

CREATE TABLE comments (
    id INT AUTO_INCREMENT PRIMARY KEY,
    content TEXT NOT NULL,
    parent_id INT DEFAULT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (parent_id) REFERENCES comments(id) ON DELETE CASCADE
);

闭包表模型（Closure Table）

CREATE TABLE comments (
    id INT AUTO_INCREMENT PRIMARY KEY,
    content TEXT NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE comment_tree (
    ancestor INT NOT NULL,
    descendant INT NOT NULL,
    depth INT NOT NULL,
    PRIMARY KEY (ancestor, descendant),
    FOREIGN KEY (ancestor) REFERENCES comments(id),
    FOREIGN KEY (descendant) REFERENCES comments(id)
);

邻接表实现方案

添加评论

function addComment($content, $parentId = null) {
    $stmt = $pdo->prepare("INSERT INTO comments (content, parent_id) VALUES (?, ?)");
    $stmt->execute([$content, $parentId]);
    return $pdo->lastInsertId();
}

递归获取评论树

function getComments($parentId = null) {
    $stmt = $pdo->prepare("SELECT * FROM comments WHERE parent_id " . ($parentId ? "= ?" : "IS NULL"));
    $stmt->execute($parentId ? [$parentId] : []);

    $comments = [];
    while ($comment = $stmt->fetch(PDO::FETCH_ASSOC)) {
        $comment['replies'] = getComments($comment['id']);
        $comments[] = $comment;
    }
    return $comments;
}

闭包表实现方案

添加评论

function addCommentWithClosure($content, $parentId = null) {
    $pdo->beginTransaction();

    $stmt = $pdo->prepare("INSERT INTO comments (content) VALUES (?)");
    $stmt->execute([$content]);
    $commentId = $pdo->lastInsertId();

    if ($parentId) {
        $stmt = $pdo->prepare("
            INSERT INTO comment_tree (ancestor, descendant, depth)
            SELECT ancestor, ?, depth+1 FROM comment_tree WHERE descendant = ?
            UNION ALL SELECT ?, ?, 0
        ");
        $stmt->execute([$commentId, $parentId, $commentId, $commentId]);
    } else {
        $stmt = $pdo->prepare("INSERT INTO comment_tree (ancestor, descendant, depth) VALUES (?, ?, 0)");
        $stmt->execute([$commentId, $commentId]);
    }

    $pdo->commit();
    return $commentId;
}

获取评论树

function getCommentTree() {
    $stmt = $pdo->query("
        SELECT c.*, ct.depth 
        FROM comments c
        JOIN comment_tree ct ON c.id = ct.descendant
        WHERE ct.ancestor = (SELECT ancestor FROM comment_tree WHERE depth = 0 LIMIT 1)
        ORDER BY ct.ancestor, ct.depth
    ");
    return $stmt->fetchAll(PDO::FETCH_ASSOC);
}

前端展示方案

递归输出HTML

function displayComments($comments, $level = 0) {
    foreach ($comments as $comment) {
        echo '<div style="margin-left: ' . ($level * 20) . 'px">';
        echo htmlspecialchars($comment['content']);
        if (!empty($comment['replies'])) {
            displayComments($comment['replies'], $level + 1);
        }
        echo '</div>';
    }
}