PHP开发的二手回收网站提供快捷找货通道

CREATE TABLE `goods` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `title` VARCHAR(255) NOT NULL,
  `description` TEXT,
  `price` DECIMAL(10, 2),
  `location` VARCHAR(100),
  `contact` VARCHAR(100),
  `image` VARCHAR(255)
);

class Goods
{
    private $conn;

    public function __construct($conn)
    {
        $this->conn = $conn;
    }

    public function getAllGoods()
    {
        $sql = "SELECT * FROM `goods`";
        $result = $this->conn->query($sql);
        return $result->fetchAll(PDO::FETCH_ASSOC);
    }

    public function getGoodsById($id)
    {
        $sql = "SELECT * FROM `goods` WHERE `id` = :id";
        $stmt = $this->conn->prepare($sql);
        $stmt->bindParam(':id', $id);
        $stmt->execute();
        return $stmt->fetch(PDO::FETCH_ASSOC);
    }

    // 其他操作方法...
}

<?php foreach ($goods as $good): ?>
    <div class="good">
        <h3><?php echo $good['title']; ?></h3>
        <p><?php echo $good['description']; ?></p>
        <p>价格：<?php echo $good['price']; ?></p>
        <p>地点：<?php echo $good['location']; ?></p>
        <p>联系人：<?php echo $good['contact']; ?></p>
        <img src="<?php echo $good['image']; ?>" alt="<?php echo $good['title']; ?>">
    </div>
<?php endforeach; ?>

class GoodsController
{
    private $model;

    public function __construct($model)
    {
        $this->model = $model;
    }

    public function index()
    {
        $goods = $this->model->getAllGoods();
        include 'view.php';
    }

    public function show($id)
    {
        $good = $this->model->getGoodsById($id);
        include 'detail.php';
    }

    // 其他操作方法...
}