prepare("SELECT id FROM coupons WHERE code = ?"); $check->execute([$code]); if($check->rowCount() > 0) { $msg = "Coupon Code already exists!"; $msg_type = "danger"; } else { $sql = "INSERT INTO coupons (code, discount_value, discount_type, status) VALUES (?, ?, ?, ?)"; if ($pdo->prepare($sql)->execute([$code, $value, $type, $status])) { $msg = "Coupon created successfully!"; $msg_type = "success"; } else { $msg = "Error creating coupon."; $msg_type = "danger"; } } } } // --- HANDLE DELETE COUPON --- if (isset($_GET['delete'])) { $id = $_GET['delete']; $pdo->prepare("DELETE FROM coupons WHERE id = ?")->execute([$id]); $msg = "Coupon deleted successfully!"; $msg_type = "warning"; } ?>
Manage Coupons - SejiStore
Discount Coupons
Create codes for sales & offers
Create Coupon
Code
Discount
Type
Status
Actions
query("SELECT * FROM coupons ORDER BY id DESC"); while($row = $stmt->fetch()): $statusClass = ($row['status'] == 1) ? 'status-active' : 'status-inactive'; $statusText = ($row['status'] == 1) ? 'Active' : 'Inactive'; // Format Value $displayValue = ($row['discount_type'] == 'percent') ? $row['discount_value'].'%' : '₹'.$row['discount_value']; $typeLabel = ($row['discount_type'] == 'percent') ? 'Percentage' : 'Fixed Amount'; ?>
No coupons found. Create one to get started.
"; } ?>
Add New Coupon
Coupon Code
Code will be automatically uppercase.
Discount Value
Discount Type
Percentage (%)
Fixed Amount (₹)
Status
Active
Inactive