<?php
$mysqli = new mysqli("localhost", "root", "", "mcc_lms");

echo "=== class_students ===\n";
print_r($mysqli->query("SELECT * FROM class_students")->fetch_all(MYSQLI_ASSOC));

echo "=== teacher_subjects ===\n";
print_r($mysqli->query("SELECT * FROM teacher_subjects")->fetch_all(MYSQLI_ASSOC));

echo "=== student_subjects ===\n";
print_r($mysqli->query("SELECT * FROM student_subjects")->fetch_all(MYSQLI_ASSOC));

echo "=== users (students) ===\n";
print_r($mysqli->query("SELECT id, username, class_level FROM users WHERE role='student'")->fetch_all(MYSQLI_ASSOC));

$mysqli->close();
?>
