prepare("DELETE FROM products WHERE id = ?"); $stmt_delete->execute([$delete_id]); $message = "Outfit deleted successfully."; } catch (PDOException $e) { $error = "Failed to delete item: Some orders contain this product."; } } // Handle Add / Edit form submit if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['save_product'])) { $id = $_POST['product_id'] ?? ''; $name = trim($_POST['name']); $description = trim($_POST['description']); $price = floatval($_POST['price']); $stock = intval($_POST['stock']); $image_url = trim($_POST['image_url']); $category_id = intval($_POST['category_id']); if (empty($name) || empty($price) || $stock < 0) { $error = "Please fill in all required fields correctly."; } else { if (!empty($id)) { // Update $stmt = $pdo->prepare("UPDATE products SET name = ?, description = ?, price = ?, stock = ?, image_url = ?, category_id = ? WHERE id = ?"); $stmt->execute([$name, $description, $price, $stock, $image_url, $category_id, $id]); $message = "Outfit updated successfully."; } else { // Insert $stmt = $pdo->prepare("INSERT INTO products (name, description, price, stock, image_url, category_id) VALUES (?, ?, ?, ?, ?, ?)"); $stmt->execute([$name, $description, $price, $stock, $image_url, $category_id]); $message = "Outfit added successfully."; } } } // Fetch edit product details if requested $edit_product = null; if (isset($_GET['edit'])) { $edit_id = intval($_GET['edit']); $stmt_edit = $pdo->prepare("SELECT * FROM products WHERE id = ?"); $stmt_edit->execute([$edit_id]); $edit_product = $stmt_edit->fetch(); } // Fetch categories for dropdown $categories = $pdo->query("SELECT * FROM categories")->fetchAll(); // Fetch all products $products = $pdo->query("SELECT p.*, c.name as category_name FROM products p LEFT JOIN categories c ON p.category_id = c.id ORDER BY p.id DESC")->fetchAll(); ?>
Manage Store Clothes

Cancel Edit

Outfit Listing

Image Name Category Price Stock Actions
āļŋ