二手回收网站利用PHP开发的交易评分系统

CREATE TABLE ratings (
    id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    user_id INT(11) UNSIGNED,
    item_id INT(11) UNSIGNED,
    rating TINYINT(1),
    review TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

<?php
// 获取用户ID和商品ID
$user_id = $_POST["user_id"];
$item_id = $_POST["item_id"];

// 将评分和评价保存到数据库
if(isset($_POST["submit"])) {
    $rating = $_POST["rating"];
    $review = $_POST["review"];
    
    // 将评分和评价插入"ratings"表中
    $sql = "INSERT INTO ratings (user_id, item_id, rating, review) VALUES ('$user_id', '$item_id', '$rating', '$review')";
    mysqli_query($conn, $sql);
}

// 查询数据库获取评分和评价信息
$sql = "SELECT * FROM ratings WHERE item_id = '$item_id'";
$result = mysqli_query($conn, $sql);
?>

<h1>用户评分和评价</h1>

<!-- 展示评分和评价信息 -->
<table>
    <tr>
        <th>评分</th>
        <th>评价</th>
        <th>时间</th>
    </tr>
    <?php while($row = mysqli_fetch_assoc($result)): ?>
    <tr>
        <td><?php echo $row["rating"]; ?></td>
        <td><?php echo $row["review"]; ?></td>
        <td><?php echo $row["created_at"]; ?></td>
    </tr>
    <?php endwhile; ?>
</table>

<!-- 提供评分和评价表单 -->
<form action="ratings.php" method="post">
    <input type="hidden" name="user_id" value="<?php echo $user_id; ?>">
    <input type="hidden" name="item_id" value="<?php echo $item_id; ?>">
    <label>评分：</label>
    <input type="radio" name="rating" value="1">1
    <input type="radio" name="rating" value="2">2
    <input type="radio" name="rating" value="3">3
    <input type="radio" name="rating" value="4">4
    <input type="radio" name="rating" value="5">5
    <br>
    <label>评价：</label>
    <textarea name="review"></textarea>
    <br>
    <input type="submit" name="submit" value="提交评价">
</form>