0) {
$pdo->prepare("INSERT INTO items (groupID,itemName,sortOrder) VALUES (?,?,?)")->execute([$gid,$name,$order]);
flash('success', "Item '$name' added.");
} else { flash('error', 'Please fill all fields.'); }
}
if ($action === 'edit') {
$id = (int)$_POST['itemID'];
$name = trim($_POST['itemName'] ?? '');
$gid = (int)$_POST['groupID'];
$order = (int)($_POST['sortOrder'] ?? 0);
if ($name !== '') {
$pdo->prepare("UPDATE items SET itemName=?,groupID=?,sortOrder=? WHERE itemID=?")->execute([$name,$gid,$order,$id]);
flash('success', 'Item updated.');
} else { flash('error', 'Name required.'); }
}
if ($action === 'delete') {
$id = (int)$_POST['itemID'];
$pdo->prepare("DELETE FROM items WHERE itemID=?")->execute([$id]);
flash('success', 'Item deleted.');
}
header('Location: items.php'); exit;
}
$igroups = $pdo->query("SELECT * FROM item_groups ORDER BY sortOrder,groupID")->fetchAll();
$items = $pdo->query("
SELECT i.*, ig.groupName
FROM items i
JOIN item_groups ig ON ig.groupID = i.groupID
ORDER BY ig.sortOrder, i.sortOrder, i.itemID
")->fetchAll();
admin_head('Items', 'items.php');
show_alerts();
?>
Items