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

Activities

Add New Activity

#NameGroupSort