<?php
session_start();

// Database configuration
$host = 'localhost';
$dbname = 'student_management';
$username = 'root';
$password = '';

try {
    // First, connect without selecting a database
    $pdo = new PDO("mysql:host=$host;charset=utf8mb4", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
    // Create database if it doesn't exist
    $pdo->exec("CREATE DATABASE IF NOT EXISTS `$dbname`");
    
    // Now connect to the specific database
    $pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8mb4", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
} catch (PDOException $e) {
    die("Database connection failed: " . $e->getMessage());
}

// Create tables if they don't exist
$createTables = "
CREATE TABLE IF NOT EXISTS students (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(100) UNIQUE NOT NULL,
    phone VARCHAR(20),
    course_level ENUM('PUC', 'UG', 'PG') NOT NULL,
    course_name VARCHAR(100) NOT NULL,
    year INT NOT NULL,
    photo_path VARCHAR(255),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE IF NOT EXISTS courses (
    id INT AUTO_INCREMENT PRIMARY KEY,
    course_level ENUM('PUC', 'UG', 'PG') NOT NULL,
    course_name VARCHAR(100) NOT NULL,
    years INT NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE IF NOT EXISTS admins (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) UNIQUE NOT NULL,
    password VARCHAR(255) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
";

try {
    $pdo->exec($createTables);
} catch (PDOException $e) {
    // Tables might already exist
}

// Insert default admin if no admin exists
$checkAdmin = $pdo->query("SELECT COUNT(*) FROM admins");
if ($checkAdmin->fetchColumn() == 0) {
    $default_password = password_hash('admin123', PASSWORD_DEFAULT);
    $stmt = $pdo->prepare("INSERT INTO admins (username, password) VALUES (?, ?)");
    $stmt->execute(['admin', $default_password]);
}

// Insert sample courses if empty
$checkCourses = $pdo->query("SELECT COUNT(*) FROM courses");
if ($checkCourses->fetchColumn() == 0) {
    $sampleCourses = [
        // PUC Courses - 2 Years
        ['PUC', 'ABES', 2],
        ['PUC', 'ABECs', 2],
        ['PUC', 'ABMS', 2],
        ['PUC', 'CEBA', 2],  // NEW: Added CEBA course
        ['PUC', 'HEBA', 2],
        ['PUC', 'HEPS', 2],  // NEW: Added HEPS course
        ['PUC', 'PCMB', 2],
        ['PUC', 'PCMCs', 2],
        ['PUC', 'PCME', 2],
        // UG Courses - 3 Years
        ['UG', 'B.Com', 3],
        ['UG', 'BBA', 3],
        ['UG', 'BCA', 3],
        ['UG', 'B.Sc-PMCs', 3],
        ['UG', 'B.Sc-BGBt', 3],
        // PG Courses - 2 Years
        ['PG', 'M.Com', 2],
        ['PG', 'M.Sc Computer Science', 2]
    ];
    
    $stmt = $pdo->prepare("INSERT INTO courses (course_level, course_name, years) VALUES (?, ?, ?)");
    foreach ($sampleCourses as $course) {
        $stmt->execute($course);
    }
}

// Initialize message variable
$message = '';

// Handle Admin Login
$login_error = '';
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['login'])) {
    $username = $_POST['username'];
    $password = $_POST['password'];
    
    $stmt = $pdo->prepare("SELECT * FROM admins WHERE username = ?");
    $stmt->execute([$username]);
    $admin = $stmt->fetch();
    
    if ($admin && password_verify($password, $admin['password'])) {
        $_SESSION['admin_logged_in'] = true;
        $_SESSION['admin_username'] = $admin['username'];
        header('Location: index.php');
        exit();
    } else {
        $login_error = "Invalid username or password!";
    }
}

// Handle Logout
if (isset($_GET['logout'])) {
    session_destroy();
    header('Location: index.php');
    exit();
}

// Check if admin is logged in
$is_admin = isset($_SESSION['admin_logged_in']) && $_SESSION['admin_logged_in'] === true;

// Handle Course Management
if ($_SERVER['REQUEST_METHOD'] === 'POST' && $is_admin) {
    // Add Course
    if (isset($_POST['add_course'])) {
        $course_level = $_POST['course_level'];
        $course_name = trim($_POST['course_name']);
        $years = intval($_POST['years']);
        
        try {
            $stmt = $pdo->prepare("INSERT INTO courses (course_level, course_name, years) VALUES (?, ?, ?)");
            $stmt->execute([$course_level, $course_name, $years]);
            $message = "Course added successfully!";
        } catch (PDOException $e) {
            $message = "Error adding course: " . $e->getMessage();
        }
    }
    
    // Edit Course
    if (isset($_POST['edit_course'])) {
        $id = intval($_POST['course_id']);
        $course_level = $_POST['course_level'];
        $course_name = trim($_POST['course_name']);
        $years = intval($_POST['years']);
        
        try {
            $stmt = $pdo->prepare("UPDATE courses SET course_level = ?, course_name = ?, years = ? WHERE id = ?");
            $stmt->execute([$course_level, $course_name, $years, $id]);
            $message = "Course updated successfully!";
        } catch (PDOException $e) {
            $message = "Error updating course: " . $e->getMessage();
        }
    }
    
    // Delete Course
    if (isset($_POST['delete_course'])) {
        $id = intval($_POST['course_id']);
        
        try {
            // Get course details first
            $stmt = $pdo->prepare("SELECT course_level, course_name FROM courses WHERE id = ?");
            $stmt->execute([$id]);
            $course = $stmt->fetch();
            
            if ($course) {
                // Check if course has students
                $stmt = $pdo->prepare("SELECT COUNT(*) FROM students WHERE course_level = ? AND course_name = ?");
                $stmt->execute([$course['course_level'], $course['course_name']]);
                $count = $stmt->fetchColumn();
                
                if ($count > 0) {
                    $message = "Cannot delete course '$course[course_name]'. It has $count students enrolled. Remove students first.";
                } else {
                    $stmt = $pdo->prepare("DELETE FROM courses WHERE id = ?");
                    $stmt->execute([$id]);
                    $message = "Course deleted successfully!";
                }
            }
        } catch (PDOException $e) {
            $message = "Error deleting course: " . $e->getMessage();
        }
    }
}

// Handle Student Management
if ($_SERVER['REQUEST_METHOD'] === 'POST' && $is_admin) {
    if (isset($_POST['action'])) {
        // Add Student
        if ($_POST['action'] === 'add') {
            $name = $_POST['name'];
            $email = $_POST['email'];
            $phone = $_POST['phone'];
            $course_level = $_POST['course_level'];
            $course_name = $_POST['course_name'];
            $year = $_POST['year'];
            
            // Handle photo upload
            $photo_path = '';
            if (isset($_FILES['photo']) && $_FILES['photo']['error'] === UPLOAD_ERR_OK) {
                $upload_dir = 'uploads/';
                if (!is_dir($upload_dir)) {
                    mkdir($upload_dir, 0777, true);
                }
                $file_extension = pathinfo($_FILES['photo']['name'], PATHINFO_EXTENSION);
                $photo_path = $upload_dir . uniqid() . '.' . $file_extension;
                move_uploaded_file($_FILES['photo']['tmp_name'], $photo_path);
            }
            
            try {
                $stmt = $pdo->prepare("INSERT INTO students (name, email, phone, course_level, course_name, year, photo_path) VALUES (?, ?, ?, ?, ?, ?, ?)");
                $stmt->execute([$name, $email, $phone, $course_level, $course_name, $year, $photo_path]);
                $message = "Student added successfully!";
            } catch (PDOException $e) {
                $message = "Error: " . $e->getMessage();
            }
        }
        
        // Delete Student
        if ($_POST['action'] === 'delete') {
            $id = $_POST['id'];
            try {
                // Get photo path to delete file
                $stmt = $pdo->prepare("SELECT photo_path FROM students WHERE id = ?");
                $stmt->execute([$id]);
                $student = $stmt->fetch();
                if ($student && $student['photo_path'] && file_exists($student['photo_path'])) {
                    unlink($student['photo_path']);
                }
                
                $stmt = $pdo->prepare("DELETE FROM students WHERE id = ?");
                $stmt->execute([$id]);
                $message = "Student deleted successfully!";
            } catch (PDOException $e) {
                $message = "Error: " . $e->getMessage();
            }
        }
        
        // Edit Student
        if ($_POST['action'] === 'edit') {
            $id = $_POST['id'];
            $name = $_POST['name'];
            $email = $_POST['email'];
            $phone = $_POST['phone'];
            $course_level = $_POST['course_level'];
            $course_name = $_POST['course_name'];
            $year = $_POST['year'];
            
            try {
                // Handle photo upload for edit
                $photo_path = null;
                if (isset($_FILES['photo']) && $_FILES['photo']['error'] === UPLOAD_ERR_OK) {
                    $upload_dir = 'uploads/';
                    if (!is_dir($upload_dir)) {
                        mkdir($upload_dir, 0777, true);
                    }
                    $file_extension = pathinfo($_FILES['photo']['name'], PATHINFO_EXTENSION);
                    $photo_path = $upload_dir . uniqid() . '.' . $file_extension;
                    move_uploaded_file($_FILES['photo']['tmp_name'], $photo_path);
                    
                    // Delete old photo
                    $stmt = $pdo->prepare("SELECT photo_path FROM students WHERE id = ?");
                    $stmt->execute([$id]);
                    $old_student = $stmt->fetch();
                    if ($old_student && $old_student['photo_path'] && file_exists($old_student['photo_path'])) {
                        unlink($old_student['photo_path']);
                    }
                }
                
                if ($photo_path) {
                    $stmt = $pdo->prepare("UPDATE students SET name=?, email=?, phone=?, course_level=?, course_name=?, year=?, photo_path=? WHERE id=?");
                    $stmt->execute([$name, $email, $phone, $course_level, $course_name, $year, $photo_path, $id]);
                } else {
                    $stmt = $pdo->prepare("UPDATE students SET name=?, email=?, phone=?, course_level=?, course_name=?, year=? WHERE id=?");
                    $stmt->execute([$name, $email, $phone, $course_level, $course_name, $year, $id]);
                }
                $message = "Student updated successfully!";
            } catch (PDOException $e) {
                $message = "Error: " . $e->getMessage();
            }
        }
    }
}

// Get course view parameters
$view_level = isset($_GET['view_level']) ? $_GET['view_level'] : '';
$view_course = isset($_GET['view_course']) ? $_GET['view_course'] : '';

// Get students for specific course view
$course_students = [];
$course_info = null;
if ($view_level && $view_course) {
    $stmt = $pdo->prepare("SELECT * FROM students WHERE course_level = ? AND course_name = ? ORDER BY year, name");
    $stmt->execute([$view_level, $view_course]);
    $course_students = $stmt->fetchAll();
    
    // Get course info
    $stmt = $pdo->prepare("SELECT * FROM courses WHERE course_level = ? AND course_name = ?");
    $stmt->execute([$view_level, $view_course]);
    $course_info = $stmt->fetch();
}

// Get all courses with student counts
$courseStats = $pdo->query("
    SELECT 
        c.id,
        c.course_level,
        c.course_name,
        c.years,
        COUNT(s.id) as student_count
    FROM courses c
    LEFT JOIN students s ON c.course_name = s.course_name AND c.course_level = s.course_level
    GROUP BY c.id, c.course_level, c.course_name, c.years
    ORDER BY c.course_level, c.course_name
")->fetchAll();

// Get all courses for management
$allCourses = $pdo->query("SELECT * FROM courses ORDER BY course_level, course_name")->fetchAll();

// Get courses for dropdowns
$courses = $pdo->query("SELECT DISTINCT course_level, course_name, years FROM courses ORDER BY course_level, course_name")->fetchAll();

// Get student for editing
$edit_student = null;
if (isset($_GET['edit'])) {
    $stmt = $pdo->prepare("SELECT * FROM students WHERE id = ?");
    $stmt->execute([$_GET['edit']]);
    $edit_student = $stmt->fetch();
}

// Get course for editing
$edit_course = null;
if (isset($_GET['edit_course'])) {
    $stmt = $pdo->prepare("SELECT * FROM courses WHERE id = ?");
    $stmt->execute([$_GET['edit_course']]);
    $edit_course = $stmt->fetch();
}

// Get total counts
$totalStudents = $pdo->query("SELECT COUNT(*) FROM students")->fetchColumn();
$totalCourses = $pdo->query("SELECT COUNT(*) FROM courses")->fetchColumn();
$pucCount = $pdo->query("SELECT COUNT(*) FROM students WHERE course_level = 'PUC'")->fetchColumn();
$ugCount = $pdo->query("SELECT COUNT(*) FROM students WHERE course_level = 'UG'")->fetchColumn();
$pgCount = $pdo->query("SELECT COUNT(*) FROM students WHERE course_level = 'PG'")->fetchColumn();

// Get year-wise counts
$pucYear1 = $pdo->query("SELECT COUNT(*) FROM students WHERE course_level = 'PUC' AND year = 1")->fetchColumn();
$pucYear2 = $pdo->query("SELECT COUNT(*) FROM students WHERE course_level = 'PUC' AND year = 2")->fetchColumn();
$ugYear1 = $pdo->query("SELECT COUNT(*) FROM students WHERE course_level = 'UG' AND year = 1")->fetchColumn();
$ugYear2 = $pdo->query("SELECT COUNT(*) FROM students WHERE course_level = 'UG' AND year = 2")->fetchColumn();
$ugYear3 = $pdo->query("SELECT COUNT(*) FROM students WHERE course_level = 'UG' AND year = 3")->fetchColumn();
$pgYear1 = $pdo->query("SELECT COUNT(*) FROM students WHERE course_level = 'PG' AND year = 1")->fetchColumn();
$pgYear2 = $pdo->query("SELECT COUNT(*) FROM students WHERE course_level = 'PG' AND year = 2")->fetchColumn();
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Student Management System - Admin Dashboard</title>
    <style>
        * {
            margin: 0;
            padding: 0;
            box-sizing: border-box;
        }
        body {
            font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
            background: #f0f2f5;
            padding: 20px;
        }
        .container {
            max-width: 1400px;
            margin: 0 auto;
        }
        
        /* Header Styles */
        .header {
            background: linear-gradient(135deg, #1a237e, #283593);
            border-radius: 10px;
            padding: 20px 30px;
            margin-bottom: 30px;
            display: flex;
            justify-content: space-between;
            align-items: center;
            flex-wrap: wrap;
            gap: 15px;
            box-shadow: 0 4px 15px rgba(26, 35, 126, 0.3);
        }
        .header-left {
            display: flex;
            align-items: center;
            gap: 15px;
        }
        .header-left h1 {
            color: white;
            font-size: 1.8em;
            margin: 0;
        }
        .header-left .subtitle {
            color: #9fa8da;
            font-size: 0.9em;
        }
        .header-right {
            display: flex;
            align-items: center;
            gap: 15px;
            flex-wrap: wrap;
        }
        .admin-badge {
            background: rgba(255,255,255,0.15);
            color: white;
            padding: 8px 18px;
            border-radius: 20px;
            font-size: 14px;
            display: flex;
            align-items: center;
            gap: 8px;
        }
        .admin-badge .icon {
            font-size: 18px;
        }
        .btn-login {
            background: #4caf50;
            color: white;
            padding: 10px 25px;
            border: none;
            border-radius: 25px;
            font-weight: 600;
            font-size: 14px;
            cursor: pointer;
            transition: all 0.3s;
            text-decoration: none;
            display: inline-flex;
            align-items: center;
            gap: 8px;
        }
        .btn-login:hover {
            background: #388e3c;
            transform: translateY(-2px);
            box-shadow: 0 4px 12px rgba(76, 175, 80, 0.4);
        }
        .btn-logout {
            background: #f44336;
            color: white;
            padding: 10px 25px;
            border: none;
            border-radius: 25px;
            font-weight: 600;
            font-size: 14px;
            cursor: pointer;
            transition: all 0.3s;
            text-decoration: none;
            display: inline-flex;
            align-items: center;
            gap: 8px;
        }
        .btn-logout:hover {
            background: #d32f2f;
            transform: translateY(-2px);
            box-shadow: 0 4px 12px rgba(244, 67, 54, 0.4);
        }
        .btn-back {
            background: #757575;
            color: white;
            padding: 8px 20px;
            border: none;
            border-radius: 20px;
            font-weight: 600;
            font-size: 13px;
            cursor: pointer;
            transition: all 0.3s;
            text-decoration: none;
            display: inline-flex;
            align-items: center;
            gap: 8px;
        }
        .btn-back:hover {
            background: #424242;
            transform: translateY(-2px);
        }

        /* Login Modal */
        .modal {
            display: none;
            position: fixed;
            z-index: 1000;
            left: 0;
            top: 0;
            width: 100%;
            height: 100%;
            background-color: rgba(0,0,0,0.5);
            animation: fadeIn 0.3s;
        }
        .modal.show {
            display: flex;
            align-items: center;
            justify-content: center;
        }
        @keyframes fadeIn {
            from { opacity: 0; }
            to { opacity: 1; }
        }
        @keyframes slideDown {
            from { transform: translateY(-50px); opacity: 0; }
            to { transform: translateY(0); opacity: 1; }
        }
        .modal-content {
            background: white;
            padding: 40px;
            border-radius: 15px;
            max-width: 420px;
            width: 90%;
            box-shadow: 0 10px 40px rgba(0,0,0,0.3);
            animation: slideDown 0.4s;
            position: relative;
        }
        .modal-content .close {
            position: absolute;
            top: 15px;
            right: 20px;
            font-size: 28px;
            font-weight: bold;
            color: #999;
            cursor: pointer;
            transition: color 0.3s;
        }
        .modal-content .close:hover {
            color: #333;
        }
        .modal-content h2 {
            color: #1a237e;
            margin-bottom: 5px;
        }
        .modal-content .modal-subtitle {
            color: #757575;
            margin-bottom: 25px;
            font-size: 14px;
        }
        .modal-content .form-group {
            margin-bottom: 18px;
        }
        .modal-content .form-group label {
            display: block;
            font-weight: 600;
            margin-bottom: 5px;
            color: #333;
        }
        .modal-content .form-group input {
            width: 100%;
            padding: 12px 15px;
            border: 2px solid #e0e0e0;
            border-radius: 8px;
            font-size: 14px;
            transition: border-color 0.3s;
        }
        .modal-content .form-group input:focus {
            border-color: #1a237e;
            outline: none;
        }
        .modal-content .btn-login-submit {
            width: 100%;
            padding: 12px;
            background: #1a237e;
            color: white;
            border: none;
            border-radius: 8px;
            font-size: 16px;
            font-weight: 600;
            cursor: pointer;
            transition: background 0.3s;
        }
        .modal-content .btn-login-submit:hover {
            background: #0d1445;
        }
        .modal-content .login-error {
            background: #ffcdd2;
            color: #b71c1c;
            padding: 10px;
            border-radius: 8px;
            margin-bottom: 15px;
            font-size: 14px;
        }
        .modal-content .default-credentials {
            margin-top: 15px;
            padding: 12px;
            background: #f5f5f5;
            border-radius: 8px;
            font-size: 13px;
            color: #555;
            text-align: center;
        }
        .modal-content .default-credentials strong {
            color: #1a237e;
        }

        /* Rest of the styles */
        .card {
            background: white;
            border-radius: 10px;
            box-shadow: 0 2px 10px rgba(0,0,0,0.1);
            padding: 25px;
            margin-bottom: 30px;
        }
        .card h2 {
            color: #1a237e;
            margin-bottom: 20px;
            border-bottom: 2px solid #e8eaf6;
            padding-bottom: 10px;
        }
        .form-grid {
            display: grid;
            grid-template-columns: repeat(auto-fit, minmax(200px, 1fr));
            gap: 15px;
        }
        .form-group {
            display: flex;
            flex-direction: column;
        }
        .form-group label {
            font-weight: 600;
            margin-bottom: 5px;
            color: #333;
        }
        .form-group input, .form-group select {
            padding: 10px;
            border: 1px solid #ddd;
            border-radius: 5px;
            font-size: 14px;
        }
        .form-group input[type="file"] {
            padding: 8px 0;
        }
        .btn {
            padding: 10px 20px;
            border: none;
            border-radius: 5px;
            cursor: pointer;
            font-weight: 600;
            transition: all 0.3s;
            text-decoration: none;
            display: inline-block;
        }
        .btn-primary {
            background: #1a237e;
            color: white;
        }
        .btn-primary:hover {
            background: #0d1445;
        }
        .btn-danger {
            background: #d32f2f;
            color: white;
        }
        .btn-danger:hover {
            background: #b71c1c;
        }
        .btn-success {
            background: #2e7d32;
            color: white;
        }
        .btn-success:hover {
            background: #1b5e20;
        }
        .btn-warning {
            background: #f57c00;
            color: white;
        }
        .btn-warning:hover {
            background: #e65100;
        }
        .btn-reset {
            background: #757575;
            color: white;
        }
        .btn-reset:hover {
            background: #424242;
        }
        .btn-sm {
            padding: 5px 10px;
            font-size: 12px;
        }
        .message {
            padding: 12px;
            border-radius: 5px;
            margin-bottom: 20px;
        }
        .message.success {
            background: #c8e6c9;
            color: #1b5e20;
        }
        .message.error {
            background: #ffcdd2;
            color: #b71c1c;
        }
        .stats-grid {
            display: grid;
            grid-template-columns: repeat(auto-fit, minmax(180px, 1fr));
            gap: 20px;
            margin-bottom: 30px;
        }
        .stat-box {
            background: white;
            padding: 20px;
            border-radius: 10px;
            box-shadow: 0 2px 8px rgba(0,0,0,0.1);
            text-align: center;
            cursor: pointer;
            transition: transform 0.3s;
        }
        .stat-box:hover {
            transform: translateY(-3px);
        }
        .stat-box .number {
            font-size: 2.5em;
            font-weight: 700;
            color: #1a237e;
        }
        .stat-box .label {
            color: #555;
            margin-top: 5px;
        }
        .stat-box.puc { border-left: 5px solid #1976d2; }
        .stat-box.ug { border-left: 5px solid #2e7d32; }
        .stat-box.pg { border-left: 5px solid #c62828; }
        .stat-box.total { border-left: 5px solid #f57c00; }
        .stat-box.courses { border-left: 5px solid #7b1fa2; }

        .course-category {
            margin-bottom: 30px;
        }
        .course-category h3 {
            color: #1a237e;
            margin-bottom: 15px;
            padding: 10px;
            background: #e8eaf6;
            border-radius: 5px;
        }
        .course-grid {
            display: grid;
            grid-template-columns: repeat(auto-fill, minmax(220px, 1fr));
            gap: 15px;
        }
        .course-card {
            background: white;
            padding: 15px;
            border-radius: 8px;
            box-shadow: 0 2px 5px rgba(0,0,0,0.08);
            border: 1px solid #e0e0e0;
            transition: transform 0.3s, box-shadow 0.3s;
        }
        .course-card:hover {
            transform: translateY(-3px);
            box-shadow: 0 4px 12px rgba(0,0,0,0.15);
        }
        .course-card .course-name {
            font-weight: 600;
            color: #1a237e;
            font-size: 1.1em;
        }
        .course-card .course-count {
            font-size: 2em;
            font-weight: 700;
            color: #1976d2;
            margin: 5px 0;
        }
        .course-card .course-detail {
            color: #757575;
            font-size: 0.9em;
        }
        .course-card .view-link {
            display: inline-block;
            margin-top: 10px;
            padding: 5px 15px;
            background: #e8eaf6;
            color: #1a237e;
            border-radius: 4px;
            text-decoration: none;
            font-size: 0.9em;
            transition: background 0.3s;
        }
        .course-card .view-link:hover {
            background: #c5cae9;
        }

        /* Course Management Table */
        .course-table {
            width: 100%;
            border-collapse: collapse;
            margin-top: 15px;
        }
        .course-table th {
            background: #1a237e;
            color: white;
            padding: 12px;
            text-align: left;
        }
        .course-table td {
            padding: 12px;
            border-bottom: 1px solid #e0e0e0;
        }
        .course-table tr:hover {
            background: #f5f5f5;
        }
        .course-table .actions {
            display: flex;
            gap: 5px;
            flex-wrap: wrap;
        }

        /* Course View Section */
        .course-view-header {
            display: flex;
            justify-content: space-between;
            align-items: center;
            flex-wrap: wrap;
            gap: 15px;
            margin-bottom: 20px;
        }
        .course-view-header h2 {
            margin: 0;
            color: #1a237e;
        }
        .course-view-header .course-meta {
            color: #757575;
            font-size: 14px;
        }

        .student-list-section {
            margin-top: 20px;
        }
        .student-table {
            width: 100%;
            border-collapse: collapse;
            margin-top: 15px;
        }
        .student-table th {
            background: #1a237e;
            color: white;
            padding: 12px;
            text-align: left;
        }
        .student-table td {
            padding: 12px;
            border-bottom: 1px solid #e0e0e0;
        }
        .student-table tr:hover {
            background: #f5f5f5;
        }
        .student-table .thumbnail {
            width: 50px;
            height: 50px;
            object-fit: cover;
            border-radius: 50%;
        }
        .student-table .actions {
            display: flex;
            gap: 5px;
            flex-wrap: wrap;
        }
        .no-students {
            text-align: center;
            padding: 40px;
            color: #757575;
            font-size: 1.2em;
        }
        .year-badge {
            display: inline-block;
            padding: 2px 10px;
            border-radius: 12px;
            font-size: 12px;
            font-weight: 600;
        }
        .year-badge.year-1 { background: #e3f2fd; color: #0d47a1; }
        .year-badge.year-2 { background: #e8f5e9; color: #1b5e20; }
        .year-badge.year-3 { background: #fff3e0; color: #e65100; }

        .level-badge {
            display: inline-block;
            padding: 2px 10px;
            border-radius: 12px;
            font-size: 12px;
            font-weight: 600;
        }
        .level-badge.puc { background: #e3f2fd; color: #0d47a1; }
        .level-badge.ug { background: #e8f5e9; color: #1b5e20; }
        .level-badge.pg { background: #fce4ec; color: #b71c1c; }

        .admin-tabs {
            display: flex;
            gap: 10px;
            margin-bottom: 20px;
            flex-wrap: wrap;
        }
        .admin-tabs .tab {
            padding: 10px 20px;
            background: #e8eaf6;
            color: #1a237e;
            border-radius: 5px;
            text-decoration: none;
            font-weight: 600;
            transition: background 0.3s;
        }
        .admin-tabs .tab:hover {
            background: #c5cae9;
        }
        .admin-tabs .tab.active {
            background: #1a237e;
            color: white;
        }

        @media (max-width: 768px) {
            .form-grid {
                grid-template-columns: 1fr;
            }
            .header {
                flex-direction: column;
                text-align: center;
            }
            .header-left h1 {
                font-size: 1.4em;
            }
            .student-table {
                font-size: 12px;
            }
            .student-table th, .student-table td {
                padding: 8px;
            }
            .stats-grid {
                grid-template-columns: repeat(2, 1fr);
            }
            .modal-content {
                padding: 25px;
            }
            .course-view-header {
                flex-direction: column;
                align-items: flex-start;
            }
            .admin-tabs {
                justify-content: center;
            }
        }
    </style>
</head>
<body>
    <div class="container">
        <!-- Modern Header with Login Button -->
        <div class="header">
            <div class="header-left">
                <div>
                    <h1>🎓 Student Management System</h1>
                    <div class="subtitle">Admin Dashboard - Manage Students & Courses</div>
                </div>
            </div>
            <div class="header-right">
                <?php if ($is_admin): ?>
                    <div class="admin-badge">
                        <span class="icon">👑</span>
                        Admin: <?php echo htmlspecialchars($_SESSION['admin_username']); ?>
                    </div>
                    <a href="?logout=1" class="btn-logout" onclick="return confirm('Are you sure you want to logout?')">
                        🚪 Logout
                    </a>
                <?php else: ?>
                    <button class="btn-login" onclick="openLoginModal()">
                        🔑 Login
                    </button>
                <?php endif; ?>
            </div>
        </div>

        <!-- Display Message if exists -->
        <?php if (!empty($message)): ?>
            <div class="message <?php echo strpos($message, 'Error') === false ? 'success' : 'error'; ?>">
                <?php echo htmlspecialchars($message); ?>
            </div>
        <?php endif; ?>

        <!-- Login Modal -->
        <div id="loginModal" class="modal">
            <div class="modal-content">
                <span class="close" onclick="closeLoginModal()">&times;</span>
                <h2>🔐 Admin Login</h2>
                <p class="modal-subtitle">Enter your credentials to access admin features</p>
                
                <?php if ($login_error): ?>
                    <div class="login-error">❌ <?php echo htmlspecialchars($login_error); ?></div>
                <?php endif; ?>
                
                <form method="POST" onsubmit="return validateLogin()">
                    <div class="form-group">
                        <label for="username">Username</label>
                        <input type="text" id="username" name="username" placeholder="Enter username" required>
                    </div>
                    <div class="form-group">
                        <label for="password">Password</label>
                        <input type="password" id="password" name="password" placeholder="Enter password" required>
                    </div>
                    <button type="submit" name="login" class="btn-login-submit">Login</button>
                    
                    <div class="default-credentials">
                        <strong>Default Login:</strong> Username: <strong>admin</strong> | Password: <strong>admin123</strong>
                    </div>
                </form>
            </div>
        </div>

        <!-- Statistics Dashboard -->
        <div class="stats-grid">
            <div class="stat-box total">
                <div class="number"><?php echo $totalStudents; ?></div>
                <div class="label">Total Students</div>
            </div>
            <div class="stat-box courses">
                <div class="number"><?php echo $totalCourses; ?></div>
                <div class="label">Total Courses</div>
            </div>
            <div class="stat-box puc">
                <div class="number"><?php echo $pucCount; ?></div>
                <div class="label">PUC Students</div>
                <div style="font-size:12px;color:#757575;margin-top:5px;">
                    I: <?php echo $pucYear1; ?> | II: <?php echo $pucYear2; ?>
                </div>
            </div>
            <div class="stat-box ug">
                <div class="number"><?php echo $ugCount; ?></div>
                <div class="label">UG Students</div>
                <div style="font-size:12px;color:#757575;margin-top:5px;">
                    I: <?php echo $ugYear1; ?> | II: <?php echo $ugYear2; ?> | III: <?php echo $ugYear3; ?>
                </div>
            </div>
            <div class="stat-box pg">
                <div class="number"><?php echo $pgCount; ?></div>
                <div class="label">PG Students</div>
                <div style="font-size:12px;color:#757575;margin-top:5px;">
                    I: <?php echo $pgYear1; ?> | II: <?php echo $pgYear2; ?>
                </div>
            </div>
        </div>

        <!-- Admin Dashboard - Only visible to admin -->
        <?php if ($is_admin): ?>
        <div class="card">
            <h2>⚙️ Admin Dashboard</h2>
            
            <!-- Admin Tabs -->
            <div class="admin-tabs">
                <a href="#students" class="tab <?php echo !isset($_GET['manage_courses']) ? 'active' : ''; ?>">📚 Manage Students</a>
                <a href="?manage_courses=1#courses" class="tab <?php echo isset($_GET['manage_courses']) ? 'active' : ''; ?>">📋 Manage Courses</a>
            </div>

            <!-- Student Management Section -->
            <?php if (!isset($_GET['manage_courses'])): ?>
            <div id="students">
                <h3 style="margin-bottom: 15px; color: #1a237e;">➕ Add / Edit Students</h3>
                <form method="POST" enctype="multipart/form-data">
                    <input type="hidden" name="action" value="<?php echo $edit_student ? 'edit' : 'add'; ?>">
                    <?php if ($edit_student): ?>
                        <input type="hidden" name="id" value="<?php echo $edit_student['id']; ?>">
                    <?php endif; ?>
                    <div class="form-grid">
                        <div class="form-group">
                            <label for="name">Full Name *</label>
                            <input type="text" id="name" name="name" required value="<?php echo $edit_student ? htmlspecialchars($edit_student['name']) : ''; ?>">
                        </div>
                        <div class="form-group">
                            <label for="email">Email *</label>
                            <input type="email" id="email" name="email" required value="<?php echo $edit_student ? htmlspecialchars($edit_student['email']) : ''; ?>">
                        </div>
                        <div class="form-group">
                            <label for="phone">Phone</label>
                            <input type="text" id="phone" name="phone" value="<?php echo $edit_student ? htmlspecialchars($edit_student['phone']) : ''; ?>">
                        </div>
                        <div class="form-group">
                            <label for="course_level">Course Level *</label>
                            <select id="course_level" name="course_level" required onchange="updateCourses()">
                                <option value="">Select Level</option>
                                <option value="PUC" <?php echo $edit_student && $edit_student['course_level'] === 'PUC' ? 'selected' : ''; ?>>PUC - Pre-University Course</option>
                                <option value="UG" <?php echo $edit_student && $edit_student['course_level'] === 'UG' ? 'selected' : ''; ?>>UG - Under Graduate</option>
                                <option value="PG" <?php echo $edit_student && $edit_student['course_level'] === 'PG' ? 'selected' : ''; ?>>PG - Post Graduate</option>
                            </select>
                        </div>
                        <div class="form-group">
                            <label for="course_name">Course Name *</label>
                            <select id="course_name" name="course_name" required>
                                <option value="">Select Course</option>
                                <?php if ($edit_student): ?>
                                    <option value="<?php echo htmlspecialchars($edit_student['course_name']); ?>" selected>
                                        <?php echo htmlspecialchars($edit_student['course_name']); ?>
                                    </option>
                                <?php endif; ?>
                            </select>
                        </div>
                        <div class="form-group">
                            <label for="year">Year *</label>
                            <select id="year" name="year" required>
                                <option value="">Select Year</option>
                                <?php if ($edit_student): ?>
                                    <option value="<?php echo $edit_student['year']; ?>" selected>
                                        <?php 
                                            $yearText = '';
                                            if ($edit_student['course_level'] === 'PUC') {
                                                $yearText = $edit_student['year'] == 1 ? 'I Year' : 'II Year';
                                            } elseif ($edit_student['course_level'] === 'UG') {
                                                $yearText = $edit_student['year'] == 1 ? 'I Year' : ($edit_student['year'] == 2 ? 'II Year' : 'III Year');
                                            } elseif ($edit_student['course_level'] === 'PG') {
                                                $yearText = $edit_student['year'] == 1 ? 'I Year' : 'II Year';
                                            }
                                            echo $yearText;
                                        ?>
                                    </option>
                                <?php endif; ?>
                            </select>
                        </div>
                        <div class="form-group">
                            <label for="photo">Photo</label>
                            <input type="file" id="photo" name="photo" accept="image/*">
                            <?php if ($edit_student && $edit_student['photo_path']): ?>
                                <small style="margin-top: 5px;">Current: <a href="<?php echo htmlspecialchars($edit_student['photo_path']); ?>" target="_blank">View Photo</a></small>
                            <?php endif; ?>
                        </div>
                        <div class="form-group" style="justify-content: flex-end;">
                            <?php if ($edit_student): ?>
                                <div style="display: flex; gap: 10px;">
                                    <button type="submit" class="btn btn-success">Update Student</button>
                                    <a href="index.php" class="btn btn-reset">Cancel</a>
                                </div>
                            <?php else: ?>
                                <button type="submit" class="btn btn-primary">Add Student</button>
                            <?php endif; ?>
                        </div>
                    </div>
                </form>
            </div>
            <?php endif; ?>

            <!-- Course Management Section -->
            <?php if (isset($_GET['manage_courses'])): ?>
            <div id="courses">
                <h3 style="margin-bottom: 15px; color: #1a237e;"><?php echo $edit_course ? '✏️ Edit Course' : '➕ Add New Course'; ?></h3>
                <form method="POST">
                    <?php if ($edit_course): ?>
                        <input type="hidden" name="course_id" value="<?php echo $edit_course['id']; ?>">
                        <input type="hidden" name="edit_course" value="1">
                    <?php else: ?>
                        <input type="hidden" name="add_course" value="1">
                    <?php endif; ?>
                    <div class="form-grid">
                        <div class="form-group">
                            <label for="course_level">Course Level *</label>
                            <select id="course_level" name="course_level" required>
                                <option value="">Select Level</option>
                                <option value="PUC" <?php echo $edit_course && $edit_course['course_level'] === 'PUC' ? 'selected' : ''; ?>>PUC - Pre-University Course</option>
                                <option value="UG" <?php echo $edit_course && $edit_course['course_level'] === 'UG' ? 'selected' : ''; ?>>UG - Under Graduate</option>
                                <option value="PG" <?php echo $edit_course && $edit_course['course_level'] === 'PG' ? 'selected' : ''; ?>>PG - Post Graduate</option>
                            </select>
                        </div>
                        <div class="form-group">
                            <label for="course_name">Course Name *</label>
                            <input type="text" id="course_name" name="course_name" required value="<?php echo $edit_course ? htmlspecialchars($edit_course['course_name']) : ''; ?>">
                        </div>
                        <div class="form-group">
                            <label for="years">Duration (Years) *</label>
                            <select id="years" name="years" required>
                                <option value="">Select Duration</option>
                                <option value="1" <?php echo $edit_course && $edit_course['years'] == 1 ? 'selected' : ''; ?>>1 Year</option>
                                <option value="2" <?php echo $edit_course && $edit_course['years'] == 2 ? 'selected' : ''; ?>>2 Years</option>
                                <option value="3" <?php echo $edit_course && $edit_course['years'] == 3 ? 'selected' : ''; ?>>3 Years</option>
                                <option value="4" <?php echo $edit_course && $edit_course['years'] == 4 ? 'selected' : ''; ?>>4 Years</option>
                            </select>
                        </div>
                        <div class="form-group" style="justify-content: flex-end;">
                            <?php if ($edit_course): ?>
                                <div style="display: flex; gap: 10px;">
                                    <button type="submit" class="btn btn-success">Update Course</button>
                                    <a href="?manage_courses=1#courses" class="btn btn-reset">Cancel</a>
                                </div>
                            <?php else: ?>
                                <button type="submit" class="btn btn-primary">Add Course</button>
                            <?php endif; ?>
                        </div>
                    </div>
                </form>

                <!-- Course List -->
                <h3 style="margin: 30px 0 15px; color: #1a237e;">📋 All Courses</h3>
                <?php if (count($allCourses) > 0): ?>
                    <div style="overflow-x: auto;">
                        <table class="course-table">
                            <thead>
                                <tr>
                                    <th>ID</th>
                                    <th>Level</th>
                                    <th>Course Name</th>
                                    <th>Duration</th>
                                    <th>Students</th>
                                    <th>Actions</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php foreach ($allCourses as $course): 
                                    // Get student count for this course
                                    $stmt = $pdo->prepare("SELECT COUNT(*) FROM students WHERE course_level = ? AND course_name = ?");
                                    $stmt->execute([$course['course_level'], $course['course_name']]);
                                    $studentCount = $stmt->fetchColumn();
                                ?>
                                    <tr>
                                        <td><?php echo $course['id']; ?></td>
                                        <td>
                                            <span class="level-badge <?php echo strtolower($course['course_level']); ?>">
                                                <?php echo htmlspecialchars($course['course_level']); ?>
                                            </span>
                                        </td>
                                        <td><strong><?php echo htmlspecialchars($course['course_name']); ?></strong></td>
                                        <td><?php echo $course['years']; ?> Year<?php echo $course['years'] > 1 ? 's' : ''; ?></td>
                                        <td><?php echo $studentCount; ?> student<?php echo $studentCount != 1 ? 's' : ''; ?></td>
                                        <td>
                                            <div class="actions">
                                                <a href="?manage_courses=1&edit_course=<?php echo $course['id']; ?>#courses" class="btn btn-warning btn-sm">Edit</a>
                                                <form method="POST" style="display: inline-block;" onsubmit="return confirm('Delete this course? This will remove all associated students.')">
                                                    <input type="hidden" name="delete_course" value="1">
                                                    <input type="hidden" name="course_id" value="<?php echo $course['id']; ?>">
                                                    <button type="submit" class="btn btn-danger btn-sm">Delete</button>
                                                </form>
                                            </div>
                                        </td>
                                    </tr>
                                <?php endforeach; ?>
                            </tbody>
                        </table>
                    </div>
                <?php else: ?>
                    <div class="no-students">
                        <p>No courses found. Add your first course!</p>
                    </div>
                <?php endif; ?>
            </div>
            <?php endif; ?>
        </div>
        <?php endif; ?>

        <!-- Course-wise Student Dashboard -->
        <div class="card">
            <h2>📊 Course-wise Student Distribution</h2>
            
            <?php
            $current_level = '';
            $level_labels = [
                'PUC' => 'Pre-University Course (2 Years)',
                'UG' => 'Under Graduate (3 Years)',
                'PG' => 'Post Graduate (2 Years)'
            ];
            foreach ($courseStats as $course):
                if ($current_level !== $course['course_level']):
                    if ($current_level !== ''): echo '</div></div>'; endif;
                    $current_level = $course['course_level'];
            ?>
                <div class="course-category">
                    <h3><?php echo $current_level; ?> - <?php echo $level_labels[$current_level]; ?></h3>
                    <div class="course-grid">
            <?php endif; ?>
                        <div class="course-card">
                            <div class="course-name"><?php echo htmlspecialchars($course['course_name']); ?></div>
                            <div class="course-count"><?php echo $course['student_count']; ?></div>
                            <div class="course-detail">
                                <?php echo $course['years']; ?> Year Program
                                <?php if ($course['years'] == 2): ?>
                                    (I & II Year)
                                <?php elseif ($course['years'] == 3): ?>
                                    (I, II & III Year)
                                <?php endif; ?>
                            </div>
                            <a href="?view_level=<?php echo $course['course_level']; ?>&view_course=<?php echo urlencode($course['course_name']); ?>" class="view-link">
                                View Students →
                            </a>
                        </div>
            <?php 
                endforeach;
                if ($current_level !== ''): echo '</div></div>'; endif;
            ?>
        </div>

        <!-- Course View Section - Shows when a course is selected -->
        <?php if ($view_level && $view_course): ?>
        <div class="card">
            <div class="course-view-header">
                <div>
                    <h2>
                        <span class="level-badge <?php echo strtolower($view_level); ?>">
                            <?php echo htmlspecialchars($view_level); ?>
                        </span>
                        <?php echo htmlspecialchars($view_course); ?>
                    </h2>
                    <div class="course-meta">
                        <?php if ($course_info): ?>
                            <?php echo $course_info['years']; ?> Year Program
                            <?php if ($course_info['years'] == 2): ?>
                                (I & II Year)
                            <?php elseif ($course_info['years'] == 3): ?>
                                (I, II & III Year)
                            <?php endif; ?>
                            | Total Students: <?php echo count($course_students); ?>
                        <?php endif; ?>
                    </div>
                </div>
                <a href="index.php" class="btn-back">← Back to Dashboard</a>
            </div>

            <!-- Student List for this course -->
            <div class="student-list-section">
                <?php if (count($course_students) > 0): ?>
                    <div style="overflow-x: auto;">
                        <table class="student-table">
                            <thead>
                                <tr>
                                    <th>Photo</th>
                                    <th>Name</th>
                                    <th>Email</th>
                                    <th>Phone</th>
                                    <th>Year</th>
                                    <th>Added</th>
                                    <?php if ($is_admin): ?>
                                        <th>Actions</th>
                                    <?php endif; ?>
                                </tr>
                            </thead>
                            <tbody>
                                <?php foreach ($course_students as $student): ?>
                                    <tr>
                                        <td>
                                            <?php if ($student['photo_path'] && file_exists($student['photo_path'])): ?>
                                                <img src="<?php echo htmlspecialchars($student['photo_path']); ?>" alt="Photo" class="thumbnail">
                                            <?php else: ?>
                                                <div style="width:50px;height:50px;border-radius:50%;background:#e8eaf6;display:flex;align-items:center;justify-content:center;font-size:24px;">👤</div>
                                            <?php endif; ?>
                                        </td>
                                        <td><strong><?php echo htmlspecialchars($student['name']); ?></strong></td>
                                        <td><?php echo htmlspecialchars($student['email']); ?></td>
                                        <td><?php echo htmlspecialchars($student['phone'] ?: 'N/A'); ?></td>
                                        <td>
                                            <span class="year-badge year-<?php echo $student['year']; ?>">
                                                <?php 
                                                    if ($student['course_level'] === 'PUC') {
                                                        echo $student['year'] == 1 ? 'I Year' : 'II Year';
                                                    } elseif ($student['course_level'] === 'UG') {
                                                        echo $student['year'] == 1 ? 'I Year' : ($student['year'] == 2 ? 'II Year' : 'III Year');
                                                    } elseif ($student['course_level'] === 'PG') {
                                                        echo $student['year'] == 1 ? 'I Year' : 'II Year';
                                                    }
                                                ?>
                                            </span>
                                        </td>
                                        <td><?php echo date('d M Y', strtotime($student['created_at'])); ?></td>
                                        <?php if ($is_admin): ?>
                                            <td>
                                                <div class="actions">
                                                    <a href="?edit=<?php echo $student['id']; ?>&view_level=<?php echo $view_level; ?>&view_course=<?php echo urlencode($view_course); ?>" class="btn btn-warning btn-sm">Edit</a>
                                                    <form method="POST" style="display: inline-block;" onsubmit="return confirm('Delete this student?')">
                                                        <input type="hidden" name="action" value="delete">
                                                        <input type="hidden" name="id" value="<?php echo $student['id']; ?>">
                                                        <button type="submit" class="btn btn-danger btn-sm">Delete</button>
                                                    </form>
                                                </div>
                                            </td>
                                        <?php endif; ?>
                                    </tr>
                                <?php endforeach; ?>
                            </tbody>
                        </table>
                    </div>
                <?php else: ?>
                    <div class="no-students">
                        <p>No students enrolled in this course yet.</p>
                        <?php if ($is_admin): ?>
                            <p style="margin-top: 10px;">Use the "Add New Student" form in the Admin Dashboard to add students to this course.</p>
                        <?php endif; ?>
                    </div>
                <?php endif; ?>
            </div>
        </div>
        <?php endif; ?>
    </div>

    <script>
        // Course data from PHP
        const coursesData = <?php echo json_encode($courses); ?>;

        function updateCourses() {
            const level = document.getElementById('course_level').value;
            const courseSelect = document.getElementById('course_name');
            const yearSelect = document.getElementById('year');
            
            // Keep current values for edit mode
            const currentCourse = courseSelect.value;
            const currentYear = yearSelect.value;
            
            courseSelect.innerHTML = '<option value="">Select Course</option>';
            yearSelect.innerHTML = '<option value="">Select Year</option>';
            
            if (level) {
                const filteredCourses = coursesData.filter(c => c.course_level === level);
                const uniqueCourses = [...new Set(filteredCourses.map(c => c.course_name))];
                
                uniqueCourses.forEach(course => {
                    const option = document.createElement('option');
                    option.value = course;
                    option.textContent = course;
                    if (course === currentCourse) {
                        option.selected = true;
                    }
                    courseSelect.appendChild(option);
                });
                
                // Update year dropdown based on selected course
                const updateYearDropdown = function() {
                    const selectedCourse = courseSelect.value;
                    const course = filteredCourses.find(c => c.course_name === selectedCourse);
                    if (course) {
                        yearSelect.innerHTML = '<option value="">Select Year</option>';
                        const yearLabels = {
                            1: 'I Year',
                            2: 'II Year',
                            3: 'III Year'
                        };
                        for (let i = 1; i <= course.years; i++) {
                            const option = document.createElement('option');
                            option.value = i;
                            option.textContent = yearLabels[i] || i + ' Year';
                            if (i == currentYear) {
                                option.selected = true;
                            }
                            yearSelect.appendChild(option);
                        }
                    }
                };
                
                updateYearDropdown();
                courseSelect.onchange = updateYearDropdown;
            }
        }

        // Login Modal Functions
        function openLoginModal() {
            document.getElementById('loginModal').classList.add('show');
            document.body.style.overflow = 'hidden';
            // Clear any previous error messages
            const errorDiv = document.querySelector('.login-error');
            if (errorDiv) errorDiv.style.display = 'none';
        }

        function closeLoginModal() {
            document.getElementById('loginModal').classList.remove('show');
            document.body.style.overflow = 'auto';
        }

        // Close modal when clicking outside
        window.onclick = function(event) {
            const modal = document.getElementById('loginModal');
            if (event.target === modal) {
                closeLoginModal();
            }
        }

        // Close modal with Escape key
        document.addEventListener('keydown', function(event) {
            if (event.key === 'Escape') {
                closeLoginModal();
            }
        });

        function validateLogin() {
            const username = document.getElementById('username').value.trim();
            const password = document.getElementById('password').value.trim();
            
            if (!username || !password) {
                alert('Please enter both username and password');
                return false;
            }
            return true;
        }

        // Initialize if level is pre-selected
        document.addEventListener('DOMContentLoaded', function() {
            const levelSelect = document.getElementById('course_level');
            if (levelSelect && levelSelect.value) {
                updateCourses();
            }
            
            // Auto-open login modal if there's a login error
            <?php if ($login_error): ?>
                openLoginModal();
            <?php endif; ?>
        });
    </script>
</body>
</html>