query("UPDATE orders SET status = 'approved' WHERE id = $id"); echo ""; } if(isset($_GET['delete'])) { $id = intval($_GET['delete']); $conn->query("DELETE FROM orders WHERE id = $id"); echo ""; } $orders = $conn->query("SELECT * FROM orders ORDER BY id DESC"); ?>
| Order ID | Customer Details | Items | Total | Status | Date | Actions |
|---|---|---|---|---|---|---|
| # |
|
Rs. | Approved Pending | Approve | ||
| No orders found yet. | ||||||