query("SELECT * FROM vendors WHERE is_active=1")->fetchAll(); // 1. Delete Product if (isset($_GET['delete_id'])) { $pid = $_GET['delete_id']; // Delete product (Cascade will delete variants automatically if DB is set up right, but let's be safe) $pdo->prepare("DELETE FROM product_variants WHERE product_id = ?")->execute([$pid]); $pdo->prepare("DELETE FROM products WHERE id = ?")->execute([$pid]); header("Location: products.php?msg=deleted"); exit(); } // 2. Delete Variant if (isset($_GET['delete_variant'])) { $vid = $_GET['delete_variant']; $pid = $_GET['return_id']; // Return to the edit page $pdo->prepare("DELETE FROM product_variants WHERE id = ?")->execute([$vid]); header("Location: products.php?edit_id=" . $pid . "&msg=variant_deleted"); exit(); } // 3. Save Product (Add or Update) if (isset($_POST['save_product'])) { $name = trim($_POST['name']); $slug = strtolower(str_replace(' ', '-', $name)); $desc = $_POST['description']; $img = $_POST['thumbnail_url']; $cat = $_POST['category_id']; $status = isset($_POST['is_active']) ? 1 : 0; if (!empty($_POST['product_id'])) { // UPDATE $id = $_POST['product_id']; $stmt = $pdo->prepare("UPDATE products SET name=?, slug=?, description=?, thumbnail_url=?, category_id=?, is_active=? WHERE id=?"); $stmt->execute([$name, $slug, $desc, $img, $cat, $status, $id]); } else { // INSERT $stmt = $pdo->prepare("INSERT INTO products (name, slug, description, thumbnail_url, category_id, is_active) VALUES (?, ?, ?, ?, ?, ?)"); $stmt->execute([$name, $slug, $desc, $img, $cat, $status]); $id = $pdo->lastInsertId(); } // Redirect to Edit page to add variants header("Location: products.php?edit_id=" . $id . "&msg=saved"); exit(); } // 4. Add Variant if (isset($_POST['add_variant'])) { $pid = $_POST['product_id']; $v_name = $_POST['v_name']; $v_price = $_POST['v_price']; $v_stock = $_POST['v_stock']; // -1 for unlimited $stmt = $pdo->prepare("INSERT INTO product_variants (product_id, name, price, stock_qty) VALUES (?, ?, ?, ?)"); $stmt->execute([$pid, $v_name, $v_price, $v_stock]); header("Location: products.php?edit_id=" . $pid . "&msg=variant_added"); exit(); } // --- FETCH DATA --- $product_to_edit = null; $variants = []; // If Editing, Fetch Product Data if (isset($_GET['edit_id'])) { $edit_id = $_GET['edit_id']; $stmt = $pdo->prepare("SELECT * FROM products WHERE id = ?"); $stmt->execute([$edit_id]); $product_to_edit = $stmt->fetch(); // Fetch Variants for this product $vStmt = $pdo->prepare("SELECT * FROM product_variants WHERE product_id = ? ORDER BY price ASC"); $vStmt->execute([$edit_id]); $variants = $vStmt->fetchAll(); } // Fetch Categories for Dropdown $categories = $pdo->query("SELECT * FROM categories")->fetchAll(); // Fetch All Products for List $all_products = $pdo->query(" SELECT p.*, c.name as cat_name FROM products p LEFT JOIN categories c ON p.category_id = c.id ORDER BY p.id DESC ")->fetchAll(); ?> Manage Products
Action Completed Successfully.

Cancel Edit

Pricing Options (Variants)

0): ?>
Plan Name Price (₹) Stock Action
₹ Delete
No variants added. This product won't be buyable yet.

Product Inventory

ID Image Name Category Status Actions
# Active' : 'Hidden'; ?> Edit Delete