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

echo "=== CLASS_STUDENTS ===\n";
$result = $mysqli->query("DESCRIBE class_students");
if ($result) {
    while($row = $result->fetch_assoc()) { print_r($row); }
} else { echo "Error: " . $mysqli->error . "\n"; }

echo "=== STUDENT_SUBJECTS ===\n";
$result = $mysqli->query("DESCRIBE student_subjects");
if ($result) {
    while($row = $result->fetch_assoc()) { print_r($row); }
} else { echo "Error: " . $mysqli->error . "\n"; }

$mysqli->close();
