fetchOne("SELECT * FROM students WHERE roll_number = '0026730012'"); if ($student) { $studentId = $student['id']; echo "

Student Basic Info:

";
        print_r($student);
        echo "

"; echo "

Student Results Table Records:

";
        print_r($db->fetchAll("SELECT * FROM student_results WHERE student_id = ?", [$studentId]));
        echo "

"; echo "

Subjects & Marks Entry Fallback Records:

";
        print_r($db->fetchAll("SELECT s.*, m.obtained_marks 
                               FROM subjects s 
                               LEFT JOIN marks_entry m ON s.id = m.subject_id AND m.student_id = ? 
                               WHERE s.course_id = ? 
                               ORDER BY s.type, s.subject_name", [$studentId, $student['course_id']]));
        echo "

"; } else { echo "Student not found."; } } catch (Exception $e) { echo "Error: " . $e->getMessage(); } ?>