<?php
$mysqli = new mysqli("localhost", "root", "", "mcc_lms");
if ($mysqli->connect_error) {
    die("Connection failed: " . $mysqli->connect_error);
}

$tables = ['users', 'classes', 'teacher_assignments', 'student_subjects'];
foreach ($tables as $table) {
    echo "=== $table ===\n";
    $result = $mysqli->query("DESCRIBE $table");
    if ($result) {
        print_r($result->fetch_all(MYSQLI_ASSOC));
    } else {
        echo "Error: " . $mysqli->error . "\n";
    }
}
$mysqli->close();
?>
