PHP开发的二手回收网站快速建立用户信任度

// 将照片和描述信息保存到数据库中
$sql = "INSERT INTO products (name, description, photo) VALUES ('$name', '$description', '$photo')";
$result = mysqli_query($conn, $sql);

// 创建评价表
CREATE TABLE reviews (
  id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  product_id INT(6) UNSIGNED,
  user_id INT(6) UNSIGNED,
  rating INT(6),
  comment varchar(255)
);

// 添加评价
$sql = "INSERT INTO reviews (product_id, user_id, rating, comment) VALUES ('$product_id', '$user_id', '$rating', '$comment')";
$result = mysqli_query($conn, $sql);

// 获取评价
$sql = "SELECT * FROM reviews WHERE product_id = '$product_id'";
$result = mysqli_query($conn, $sql);
while($row = mysqli_fetch_assoc($result)) {
  echo "用户ID：" . $row['user_id'] . " 评分：" . $row['rating'] . " 评论：" . $row['comment'];
}

// 创建客服表
CREATE TABLE customer_service (
  id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(100),
  email VARCHAR(100),
  phone VARCHAR(20)
);

// 添加客服
$sql = "INSERT INTO customer_service (name, email, phone) VALUES ('$name', '$email', '$phone')";
$result = mysqli_query($conn, $sql);

// 获取客服信息
$sql = "SELECT * FROM customer_service";
$result = mysqli_query($conn, $sql);
while($row = mysqli_fetch_assoc($result)) {
  echo "客服姓名：" . $row['name'] . " 邮箱：" . $row['email'] . " 电话：" . $row['phone'];
}