prepare("INSERT INTO bundles (name, price, products_included, is_active) VALUES (?, ?, ?, 1)");
if($stmt->execute([$name, $price, $items])) {
$msg = "Bundle Created Successfully!";
$msgClass = "success";
} else {
$msg = "Error creating bundle.";
$msgClass = "error";
}
} else {
$msg = "Please fill all fields and select products.";
$msgClass = "error";
}
}
// 2. HANDLE DELETE
if (isset($_GET['delete'])) {
$id = $_GET['delete'];
$pdo->prepare("DELETE FROM bundles WHERE id=?")->execute([$id]);
header("Location: bundles.php?msg=deleted"); exit();
}
// 3. FETCH DATA
$products = $pdo->query("SELECT * FROM products WHERE is_active = 1")->fetchAll();
$bundles = $pdo->query("SELECT * FROM bundles ORDER BY id DESC")->fetchAll();
?>
Manage Bundles
Product Bundles
Create Bundle
Active Bundles
0): ?>
Bundle Name
Included Items
Price
Action
query("SELECT name FROM products WHERE id IN ($ids)")->fetchAll(PDO::FETCH_COLUMN);
$items_text = implode(" + ", $names);
} else {
$items_text = "No items";
}
?>