prepare("DELETE FROM sizes WHERE id = ?"); $stmt_del->execute([$delete_id]); $success = 'Size tier removed successfully!'; echo ""; } catch (Exception $e) { $error = 'Failed to delete size: ' . $e->getMessage(); } } // Handle Form Submission (Add or Edit) if ($_SERVER['REQUEST_METHOD'] === 'POST') { $name = isset($_POST['name']) ? trim($_POST['name']) : ''; $action = isset($_POST['action']) ? $_POST['action'] : 'add'; $size_id = isset($_POST['size_id']) ? intval($_POST['size_id']) : 0; if (empty($name)) { $error = 'Size Name is required.'; } else { try { if ($action === 'edit' && $size_id > 0) { // Update existing size $stmt_update = $pdo->prepare("UPDATE sizes SET name = ? WHERE id = ?"); $stmt_update->execute([$name, $size_id]); $success = 'Size tier updated successfully!'; echo ""; } else { // Add new size // Check duplicate $stmt_check = $pdo->prepare("SELECT COUNT(*) FROM sizes WHERE name = ?"); $stmt_check->execute([$name]); if ($stmt_check->fetchColumn() > 0) { $error = 'A size tier with this name already exists.'; } else { $stmt_insert = $pdo->prepare("INSERT INTO sizes (name) VALUES (?)"); $stmt_insert->execute([$name]); $success = 'New size tier introduced successfully!'; echo ""; } } } catch (Exception $e) { $error = 'Database transaction failed: ' . $e->getMessage(); } } } // Check if we are in Edit Mode if (isset($_GET['edit'])) { $edit_id = intval($_GET['edit']); try { $stmt_edit = $pdo->prepare("SELECT * FROM sizes WHERE id = ?"); $stmt_edit->execute([$edit_id]); $editing_size = $stmt_edit->fetch(); } catch (Exception $e) { $error = 'Failed to load size for editing.'; } } // Fetch all sizes $sizes = []; try { $sizes = $pdo->query("SELECT * FROM sizes ORDER BY id ASC")->fetchAll(); } catch (Exception $e) { $error = 'Failed to retrieve catalog sizes: ' . $e->getMessage(); } ?>

Couture Sizes Management

Design, add, and refine the catalog sizes available for apparel, footwear, and accessory lines.

Active Size Tiers

No size tiers have been defined.

ID	Size Name / Tag	Actions
#		Edit Delete

Couture Sizes Management

Active Size Tiers

Refine Size Tier Details Add New Size Tier