prepare("INSERT INTO activity_groups (groupName, sortOrder) VALUES (?,?)") ->execute([$name, $order]); flash('success', "Group '$name' added."); } else { flash('error', 'Group name cannot be empty.'); } } if ($action === 'edit') { $id = (int)$_POST['groupID']; $name = trim($_POST['groupName'] ?? ''); $order = (int)($_POST['sortOrder'] ?? 0); if ($name !== '') { $pdo->prepare("UPDATE activity_groups SET groupName=?, sortOrder=? WHERE groupID=?") ->execute([$name, $order, $id]); flash('success', 'Group updated.'); } else { flash('error', 'Group name cannot be empty.'); } } if ($action === 'delete') { $id = (int)$_POST['groupID']; $pdo->prepare("DELETE FROM activity_groups WHERE groupID=?")->execute([$id]); flash('success', 'Group deleted.'); } header('Location: activity_groups.php'); exit; } $groups = $pdo->query("SELECT * FROM activity_groups ORDER BY sortOrder, groupID")->fetchAll(); admin_head('Activity Groups', 'activity_groups.php'); show_alerts(); ?>

Activity Groups

Add New Group

prepare("SELECT COUNT(*) FROM activities WHERE groupID=?"); $cnt->execute([$g['groupID']]); $actCount = $cnt->fetchColumn(); $id = $g['groupID']; ?>
#NameSortActivities