<?php
header('Content-Type: application/json');
header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Methods: GET, POST, OPTIONS');
header('Access-Control-Allow-Headers: Content-Type');

// Handle preflight OPTIONS request
if ($_SERVER['REQUEST_METHOD'] === 'OPTIONS') {
    http_response_code(200);
    exit();
}

try {
    // Database connection
    require_once '../../config/db.php';
    
    $college_id = isset($_GET['college_id']) ? (int)$_GET['college_id'] : null;
    
    if (!$college_id) {
        throw new Exception('College ID is required');
    }
    
    // Query to get courses by college
    $query = "SELECT c.course_id, c.course_name, c.course_code, c.total_semesters 
              FROM courses c 
              WHERE c.college_id = ? AND c.status = 'Active'
              ORDER BY c.course_name";
    
    $stmt = $pdo->prepare($query);
    $stmt->execute([$college_id]);
    $courses = $stmt->fetchAll(PDO::FETCH_ASSOC);
    
    echo json_encode([
        'status' => 'success',
        'data' => $courses,
        'message' => 'Courses retrieved successfully'
    ]);
    
} catch (Exception $e) {
    http_response_code(400);
    echo json_encode([
        'status' => 'error',
        'message' => $e->getMessage()
    ]);
}
?>