Ecshop二次开发添加商品评论和打分功能的教程

CREATE TABLE `ecs_rating` (
  `rating_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `goods_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `rating` tinyint(1) unsigned NOT NULL,
  `comment` text,
  `add_time` int(10) unsigned NOT NULL,
  PRIMARY KEY (`rating_id`),
  KEY `goods_id` (`goods_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

<div class="rating-section">
    <?php
    $sql = "SELECT AVG(rating) as avg_rating, COUNT(*) as total_comments FROM ecs_rating WHERE goods_id = '$goods_id'";
    $result = $db->getRow($sql);
    $avg_rating = $result['avg_rating'];
    $total_comments = $result['total_comments'];
    ?>
    <h3>商品评分: <?php echo round($avg_rating, 1); ?> (共<?php echo $total_comments; ?>条评论)</h3>
    <div class="stars">
        <?php for ($i = 1; $i <= 5; $i++) { ?>
            <span class="star <?php echo ($i <= round($avg_rating) ? 'filled' : ''); ?>">★</span>
        <?php } ?>
    </div>
    <div class="comments">
        <?php
        $sql = "SELECT * FROM ecs_rating WHERE goods_id = '$goods_id' ORDER BY add_time DESC LIMIT 5";
        $comments = $db->getAll($sql);
        foreach ($comments as $comment) {
            echo '<div class="comment">';
            echo '<p>' . htmlspecialchars($comment['comment']) . '</p>';
            echo '<span class="comment-rating">' . str_repeat('★', $comment['rating']) . '</span>';
            echo '</div>';
        }
        ?>
    </div>
</div>

<form action="submit_comment.php" method="post">
    <input type="hidden" name="goods_id" value="<?php echo $goods_id; ?>">
    <textarea name="comment" placeholder="请输入您的评论"></textarea>
    <div class="rating-input">
        <?php for ($i = 1; $i <= 5; $i++) { ?>
            <label>
                <input type="radio" name="rating" value="<?php echo $i; ?>" <?php echo ($i == 5 ? 'checked' : ''); ?>>
                <span class="star">★</span>
            </label>
        <?php } ?>
    </div>
    <button type="submit">提交评论</button>
</form>

<?php
require_once('includes/lib_common.php');

$goods_id = isset($_POST['goods_id']) ? intval($_POST['goods_id']) : 0;
$comment = isset($_POST['comment']) ? $_POST['comment'] : '';
$rating = isset($_POST['rating']) ? intval($_POST['rating']) : 0;
$user_id = $_SESSION['user_id'];

if ($goods_id > 0 && $comment != '' && $rating > 0 && $user_id > 0) {
    $sql = "INSERT INTO ecs_rating (goods_id, user_id, rating, comment, add_time) VALUES ('$goods_id', '$user_id', '$rating', '$comment', '" . time() . "')";
    $db->query($sql);
    echo '评论提交成功！';
} else {
    echo '评论提交失败，请检查输入信息。';
}
?>

<?php
require_once('includes/lib_common.php');

$action = isset($_GET['action']) ? $_GET['action'] : '';
$rating_id = isset($_GET['rating_id']) ? intval($_GET['rating_id']) : 0;

if ($action == 'delete' && $rating_id > 0) {
    $sql = "DELETE FROM ecs_rating WHERE rating_id = '$rating_id'";
    $db->query($sql);
    echo '评论已删除！';
}

$sql = "SELECT r.*, u.user_name FROM ecs_rating r LEFT JOIN ecs_users u ON r.user_id = u.user_id";
$ratings = $db->getAll($sql);
?>
<table>
    <tr>
        <th>评论ID</th>
        <th>商品ID</th>
        <th>用户名</th>
        <th>评分</th>
        <th>评论内容</th>
        <th>添加时间</th>
        <th>操作</th>
    </tr>
    <?php foreach ($ratings as $rating) { ?>
        <tr>
            <td><?php echo $rating['rating_id']; ?></td>
            <td><?php echo $rating['goods_id']; ?></td>
            <td><?php echo $rating['user_name']; ?></td>
            <td><?php echo str_repeat('★', $rating['rating']); ?></td>
            <td><?php echo htmlspecialchars($rating['comment']); ?></td>
            <td><?php echo date('Y-m-d H:i:s', $rating['add_time']); ?></td>
            <td><a href="?action=delete&rating_id=<?php echo $rating['rating_id']; ?>">删除</a></td>
        </tr>
    <?php } ?>
</table>