escape($conn, $_POST['name']), 'date' => $_POST['date'], 'time_in' => $_POST['time_in'], 'time_out' => $_POST['time_out'], 'description' => escape($conn, $_POST['description']), 'location' => escape($conn, $_POST['location']), 'required_students' => $_POST['required_students'], 'course_id' => $_POST['course_id'] ? intval($_POST['course_id']) : null, 'department_id' => $_POST['department_id'] ? intval($_POST['department_id']) : null, 'status' => isset($_POST['status']) ? 1 : 0 ]; // Validate time if (strtotime($activity_data['time_out']) <= strtotime($activity_data['time_in'])) { $message = 'Time Out must be later than Time In!'; $message_type = 'danger'; } else { $sql = "UPDATE activities SET name = '{$activity_data['name']}', date = '{$activity_data['date']}', time_in = '{$activity_data['time_in']}', time_out = '{$activity_data['time_out']}', description = '{$activity_data['description']}', location = '{$activity_data['location']}', required_students = '{$activity_data['required_students']}', course_id = " . ($activity_data['course_id'] ? $activity_data['course_id'] : 'NULL') . ", department_id = " . ($activity_data['department_id'] ? $activity_data['department_id'] : 'NULL') . ", status = {$activity_data['status']}, updated_at = NOW() WHERE id = $activity_id"; if (query($conn, $sql)) { $_SESSION['message'] = 'Activity updated successfully!'; $_SESSION['message_type'] = 'success'; header('Location: manage_activities.php'); exit(); } else { $message = 'Error updating activity: ' . mysqli_error($conn); $message_type = 'danger'; } } } } // Get dropdown data $courses = []; $departments = []; // Courses $result = query($conn, "SELECT * FROM courses WHERE status = 1 ORDER BY code"); while ($row = mysqli_fetch_assoc($result)) { $courses[] = $row; } // Departments $result = query($conn, "SELECT * FROM departments WHERE status = 1 ORDER BY code"); while ($row = mysqli_fetch_assoc($result)) { $departments[] = $row; } include '../includes/header.php'; ?>

Edit Activity

Update activity details.

Back to Activities
Edit Activity:
>
Cancel
function toggleParticipantSelection() { const participantType = document.getElementById("participantType").value; const courseSelection = document.getElementById("courseSelection"); const departmentSelection = document.getElementById("departmentSelection"); if (participantType === "specific_course") { courseSelection.style.display = "block"; departmentSelection.style.display = "none"; document.getElementById("courseSelect").required = true; document.getElementById("departmentSelect").required = false; } else if (participantType === "specific_department") { courseSelection.style.display = "none"; departmentSelection.style.display = "block"; document.getElementById("courseSelect").required = false; document.getElementById("departmentSelect").required = true; } else { courseSelection.style.display = "none"; departmentSelection.style.display = "none"; document.getElementById("courseSelect").required = false; document.getElementById("departmentSelect").required = false; } } // Time validation document.addEventListener("DOMContentLoaded", function() { // Initialize participant selection toggleParticipantSelection(); document.getElementById("editActivityForm").addEventListener("submit", function(e) { const timeIn = document.querySelector("input[name=\'time_in\']").value; const timeOut = document.querySelector("input[name=\'time_out\']").value; if (timeIn && timeOut && timeOut <= timeIn) { e.preventDefault(); alert("Time Out must be later than Time In!"); return false; } }); }); '; include '../includes/footer.php'; ?>