connect_error) { $students_error = 'Database connection failed: ' . $rmgt_conn->connect_error; $students = []; } else { // Determine the selected date (default to current date) $selected_date = isset($_GET['date']) ? $_GET['date'] : date('Y-m-d'); $selected_day = date('l', strtotime($selected_date)); // e.g., "Thursday" // Fetch students scheduled for the selected day, along with their latest progress $query = " SELECT s.student_id, s.forename, s.surname, s.time_slot, p.progress, p.datetimestamp FROM students s LEFT JOIN ( SELECT student_id, progress, datetimestamp FROM student_progress WHERE (student_id, datetimestamp) IN ( SELECT student_id, MAX(datetimestamp) FROM student_progress GROUP BY student_id ) ) p ON s.student_id = p.student_id WHERE s.active = 1 AND s.day_of_week = ? ORDER BY s.time_slot ASC "; $stmt = $rmgt_conn->prepare($query); $stmt->bind_param('s', $selected_day); $stmt->execute(); $result = $stmt->get_result(); if ($result === false) { $students_error = 'Error fetching students: ' . $rmgt_conn->error; $students = []; } else { $students = $result->fetch_all(MYSQLI_ASSOC); $students_error = empty($students) ? 'No students scheduled for this day.' : null; } $stmt->close(); $rmgt_conn->close(); } ?> Student Schedule

Student Schedule

Student Schedule for

  • -
    Last worked on:
    Updated:
    No progress recorded.
Accounts Financials RM Guitar Update Schedule