PHP项目怎样实现评论审核功能？

wen PHP项目 2026-06-08 191

本文目录导读：

PHP项目怎样实现评论审核功能？

基础数据库设计
评论提交与审核流程
前端展示控制
自动审核（可选扩展）
批量审核功能
通知系统
管理界面模板示例
建议的审核流程

我来详细说明 PHP 项目中实现评论审核功能的几种方案：

基础数据库设计

数据表结构

CREATE TABLE comments (
    id INT PRIMARY KEY AUTO_INCREMENT,
    content TEXT NOT NULL,
    user_id INT NOT NULL,
    article_id INT NOT NULL,
    status ENUM('pending', 'approved', 'rejected') DEFAULT 'pending',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    reviewed_at TIMESTAMP NULL,
    reviewed_by INT NULL,
    reject_reason VARCHAR(255) NULL,
    INDEX idx_status (status),
    INDEX idx_article (article_id)
);

评论提交与审核流程

评论提交接口

// submit_comment.php
<?php
class CommentController {
    public function submit() {
        // 1. 验证用户输入
        $content = filter_input(INPUT_POST, 'content', FILTER_SANITIZE_STRING);
        $articleId = filter_input(INPUT_POST, 'article_id', FILTER_VALIDATE_INT);
        // 2. 保存评论（默认状态为待审核）
        $comment = new Comment();
        $comment->content = $content;
        $comment->article_id = $articleId;
        $comment->user_id = $_SESSION['user_id'];
        $comment->status = 'pending'; // 待审核
        $comment->save();
        // 3. 通知管理员（可选）
        $this->notifyAdmin($comment);
        return ['success' => true, 'message' => '评论已提交，等待审核'];
    }
    private function notifyAdmin($comment) {
        // 发送邮件/站内信通知管理员
    }
}

审核后台

// admin/review_comments.php
<?php
class ReviewController {
    // 获取待审核评论列表
    public function getPendingComments($page = 1, $perPage = 20) {
        $offset = ($page - 1) * $perPage;
        return Comment::where('status', 'pending')
            ->orderBy('created_at', 'desc')
            ->limit($perPage)
            ->offset($offset)
            ->get();
    }
    // 审核通过
    public function approve($commentId) {
        $comment = Comment::find($commentId);
        if (!$comment) {
            return ['success' => false, 'message' => '评论不存在'];
        }
        $comment->status = 'approved';
        $comment->reviewed_at = now();
        $comment->reviewed_by = auth()->id();
        $comment->save();
        // 可选：通知用户评论已通过
        $this->notifyUser($comment, 'approved');
        return ['success' => true];
    }
    // 审核拒绝
    public function reject($commentId, $reason = '') {
        $comment = Comment::find($commentId);
        if (!$comment) {
            return ['success' => false, 'message' => '评论不存在'];
        }
        $comment->status = 'rejected';
        $comment->reviewed_at = now();
        $comment->reviewed_by = auth()->id();
        $comment->reject_reason = $reason;
        $comment->save();
        // 可选：通知用户评论被拒绝
        $this->notifyUser($comment, 'rejected');
        return ['success' => true];
    }
}

前端展示控制

文章页评论展示

// article.php
<?php
class ArticleController {
    public function showComments($articleId) {
        // 只显示已审核通过的评论
        $approvedComments = Comment::where('article_id', $articleId)
            ->where('status', 'approved')
            ->orderBy('created_at', 'desc')
            ->get();
        // 显示用户自己的评论（不管审核状态）
        $userComments = [];
        if (auth()->check()) {
            $userComments = Comment::where('user_id', auth()->id())
                ->where('article_id', $articleId)
                ->get();
        }
        return view('article.comments', [
            'approvedComments' => $approvedComments,
            'userComments' => $userComments
        ]);
    }
}

自动审核（可选扩展）

敏感词过滤

<?php
class AutoReview {
    private $blacklist = ['敏感词1', '敏感词2', '广告链接'];
    private $whitelist = ['白名单用户1', '白名单用户2'];
    public function autoReview($comment) {
        // 白名单用户自动通过
        if (in_array($comment->user->username, $this->whitelist)) {
            return 'approved';
        }
        // 检查敏感词
        foreach ($this->blacklist as $word) {
            if (strpos($comment->content, $word) !== false) {
                return 'rejected';
            }
        }
        // 检查垃圾内容
        if ($this->isSpam($comment)) {
            return 'rejected';
        }
        // 默认返回待审核
        return 'pending';
    }
    private function isSpam($comment) {
        // 检查是否包含过多链接
        $linkCount = preg_match_all('/https?:\/\/[^\s]+/', $comment->content);
        if ($linkCount > 3) {
            return true;
        }
        // 检查重复内容
        $similarComments = Comment::where('content', 'LIKE', '%' . $comment->content . '%')
            ->count();
        if ($similarComments > 5) {
            return true;
        }
        return false;
    }
}

批量审核功能

<?php
class BatchReviewController {
    public function batchApprove() {
        $commentIds = request()->input('comment_ids', []);
        Comment::whereIn('id', $commentIds)
            ->where('status', 'pending')
            ->update([
                'status' => 'approved',
                'reviewed_at' => now(),
                'reviewed_by' => auth()->id()
            ]);
        return ['success' => true, 'message' => '批量审核通过'];
    }
    public function batchReject() {
        $commentIds = request()->input('comment_ids', []);
        $reason = request()->input('reason', '');
        Comment::whereIn('id', $commentIds)
            ->where('status', 'pending')
            ->update([
                'status' => 'rejected',
                'reviewed_at' => now(),
                'reviewed_by' => auth()->id(),
                'reject_reason' => $reason
            ]);
        return ['success' => true, 'message' => '批量拒绝成功'];
    }
}

通知系统

<?php
class NotificationService {
    public function notifyUser($comment, $action) {
        if ($action === 'approved') {
            // 用户通知：评论已通过
            $message = "您的评论「{$comment->content}」已通过审核";
        } else {
            // 用户通知：评论被拒绝
            $reason = $comment->reject_reason ?: "未提供原因";
            $message = "您的评论「{$comment->content}」未通过审核，原因：{$reason}";
        }
        // 发送邮件或站内信
        Notification::send($comment->user, [
            'title' => '评论审核结果',
            'content' => $message,
            'type' => 'comment_review'
        ]);
    }
}

管理界面模板示例

<!-- admin/comments.html -->
<div class="comment-list">
    <h2>评论审核管理</h2>
    <div class="filter-bar">
        <select id="status-filter">
            <option value="all">全部</option>
            <option value="pending">待审核</option>
            <option value="approved">已通过</option>
            <option value="rejected">已拒绝</option>
        </select>
        <button onclick="batchApprove()">批量通过</button>
        <button onclick="batchReject()">批量拒绝</button>
    </div>
    <table>
        <thead>
            <tr>
                <th><input type="checkbox" id="select-all"></th>
                <th>ID</th>
                <th>用户</th>
                <th>内容</th>
                <th>状态</th>
                <th>提交时间</th>
                <th>操作</th>
            </tr>
        </thead>
        <tbody>
            <?php foreach ($comments as $comment): ?>
            <tr>
                <td><input type="checkbox" class="comment-checkbox" value="<?= $comment->id ?>"></td>
                <td><?= $comment->id ?></td>
                <td><?= htmlspecialchars($comment->user->username) ?></td>
                <td><?= htmlspecialchars($comment->content) ?></td>
                <td>
                    <span class="status-badge status-<?= $comment->status ?>">
                        <?= $comment->status_label ?>
                    </span>
                </td>
                <td><?= $comment->created_at ?></td>
                <td>
                    <button onclick="approve(<?= $comment->id ?>)">通过</button>
                    <button onclick="reject(<?= $comment->id ?>)">拒绝</button>
                </td>
            </tr>
            <?php endforeach; ?>
        </tbody>
    </table>
</div>