PHP開發的二手回收網站提供發布商品後台審查功能

CREATE TABLE `goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text,
  `price` decimal(10,2) NOT NULL,
  `status` enum('pending','approved','rejected') NOT NULL DEFAULT 'pending',
  PRIMARY KEY (`id`)
);

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

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

if ($conn->connect_error) {
  die("连接失败: " . $conn->connect_error);
}

// 获取待审查商品列表
$sql = "SELECT * FROM goods WHERE status = 'pending'";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
  while($row = $result->fetch_assoc()) {
    echo "商品标题: " . $row["title"]. " - 价格: " . $row["price"]. "<br>";
    echo "描述: " . $row["description"]. "<br>";
    echo "<button onclick='approveProduct(" . $row["id"]. ")'>批准</button>";
    echo "<button onclick='rejectProduct(" . $row["id"]. ")'>拒绝</button>";
    echo "<hr>";
  }
} else {
  echo "暂无待审查商品";
}

// 批准商品
function approveProduct($productId) {
  // 更新商品状态为已批准
  $sql = "UPDATE goods SET status = 'approved' WHERE id = $productId";
  if ($conn->query($sql) === TRUE) {
    echo "商品已批准";
  } else {
    echo "更新商品状态失败: " . $conn->error;
  }
}

// 拒绝商品
function rejectProduct($productId) {
  // 更新商品状态为已拒绝
  $sql = "UPDATE goods SET status = 'rejected' WHERE id = $productId";
  if ($conn->query($sql) === TRUE) {
    echo "商品已拒绝";
  } else {
    echo "更新商品状态失败: " . $conn->error;
  }
}

$conn->close();
?>