File "get_exam_subjects.php"

Full path: /home2/santhos2/public_html/bharath-coe.firstmatrix.in.net/api/mark_entry/get_exam_subjects.php
File size: 1.45 KiB (1481 bytes)
MIME-type: text/x-php
Charset: utf-8

Download   Open   Back

<?php
require_once '../../config/config.php';
header('Content-Type: application/json');

try {
    $academic_year = isset($_GET['academic_year']) ? $_GET['academic_year'] : '';
    $exam_type_id = isset($_GET['exam_type_id']) ? (int)$_GET['exam_type_id'] : 0;

    $sql = "SELECT es.exam_subject_id, 
                   CONCAT(s.subject_name, ' - ', e.exam_name, ' (', et.type_name, ')') as display_name,
                   s.subject_name,
                   e.exam_name,
                   et.type_name as exam_type,
                   e.academic_year
            FROM exam_subjects es
            JOIN subjects s ON es.subject_id = s.subject_id
            JOIN exams e ON es.exam_id = e.exam_id
            JOIN exam_types et ON e.exam_type_id = et.exam_type_id
            WHERE 1=1";

    $bindings = [];
    
    if ($academic_year) {
        $sql .= " AND e.academic_year = ?";
        $bindings[] = $academic_year;
    }
    
    if ($exam_type_id > 0) {
        $sql .= " AND e.exam_type_id = ?";
        $bindings[] = $exam_type_id;
    }

    $sql .= " ORDER BY s.subject_name, e.exam_name";

    $stmt = $pdo->prepare($sql);
    $stmt->execute($bindings);
    $data = $stmt->fetchAll(PDO::FETCH_ASSOC);

    echo json_encode([
        'status' => 'success',
        'data' => $data
    ]);

} catch (Exception $e) {
    echo json_encode([
        'status' => 'error',
        'message' => $e->getMessage()
    ]);
}
?>