prepare("SELECT id FROM coupons WHERE code = ?"); $check->execute([$code]); if($check->rowCount() == 0) { $stmt = $pdo->prepare("INSERT INTO coupons (code, type, value) VALUES (?, ?, ?)"); if($stmt->execute([$code, $type, $value])) { $msg = "Success! Coupon $code created."; $msgClass = "success"; } else { $msg = "Error creating coupon."; $msgClass = "error"; } } else { $msg = "Coupon code '$code' already exists."; $msgClass = "error"; } } // 2. HANDLE DELETE COUPON if (isset($_GET['delete'])) { $id = $_GET['delete']; $pdo->prepare("DELETE FROM coupons WHERE id = ?")->execute([$id]); header("Location: coupons.php?msg=deleted"); exit(); } // 3. FETCH COUPONS $coupons = $pdo->query("SELECT * FROM coupons ORDER BY id DESC")->fetchAll(); ?> Manage Coupons

Coupon Manager

Coupon deleted successfully.

Create New Coupon

Active Coupons

0): ?>

Code	Discount Type	Value	Created At	Action
	Flat Amount Percentage			Delete
No coupons created yet.