PHP社開発の取引評価システムを活用した中古リサイクルサイト

CREATE TABLE `evaluation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `score` int(11) NOT NULL,
  `comment` text,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

<?php
// 连接数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

// 处理评价请求
if (isset($_POST['user_id']) && isset($_POST['order_id']) && isset($_POST['score']) && isset($_POST['comment'])) {
    $user_id = $_POST['user_id'];
    $order_id = $_POST['order_id'];
    $score = $_POST['score'];
    $comment = $_POST['comment'];

    // 插入评价信息
    $sql = "INSERT INTO evaluation (user_id, order_id, score, comment)
    VALUES ('$user_id', '$order_id', '$score', '$comment')";

    if ($conn->query($sql) === TRUE) {
        echo "评价成功";
    } else {
        echo "评价失败: " . $conn->error;
    }
}

// 展示评价列表
$sql = "SELECT * FROM evaluation";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "评价ID: " . $row["id"]. " - 用户ID: " . $row["user_id"]. " - 订单ID: " . $row["order_id"]. " - 评分: " . $row["score"]. " - 评论: " . $row["comment"]. "<br>";
    }
} else {
    echo "暂无评价";
}

$conn->close();
?>