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();
// Edit mode?
$editing = null;
if (isset($_GET['edit'])) {
$stmt = $pdo->prepare("SELECT * FROM activity_groups WHERE groupID=?");
$stmt->execute([(int)$_GET['edit']]);
$editing = $stmt->fetch();
}
admin_head('Activity Groups', 'activity_groups.php');
show_alerts();
?>
Activity Groups
| # | Name | Sort | Activities | |
|---|
prepare("SELECT COUNT(*) FROM activities WHERE groupID=?");
$cnt->execute([$g['groupID']]);
$actCount = $cnt->fetchColumn();
?>
|
|
|
|
Edit
|