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

echo "=== teacher_subjects ===\n";
$result = $mysqli->query("DESCRIBE teacher_subjects");
if ($result) {
    print_r($result->fetch_all(MYSQLI_ASSOC));
}

echo "=== class_students ===\n";
$result = $mysqli->query("DESCRIBE class_students");
if ($result) {
    print_r($result->fetch_all(MYSQLI_ASSOC));
}
$mysqli->close();
?>
