订单管理
order.php · 订单模块
/app/order.php
<?php
// 订单列表
function listOrders(string $status = ''): array {
$sql = 'SELECT * FROM orders';
$params = [];
if ($status) {
$sql .= ' WHERE status = ?';
$params[] = $status;
}
$sql .= ' ORDER BY id DESC';
$stmt = db()->prepare($sql);
$stmt->execute($params);
return $stmt->fetchAll();
}