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'; ?>
Update activity details.