1#@!#!123s

: / home / schoolcampuserp / saraswatigurukulmanjhaul.co.in / api / app_api /
Filename : get_exam_info.php
back
<?php
include 'connection.php';

if ($_SERVER["REQUEST_METHOD"] === "POST") {
    $exam_group_class_batch_exams_id = $_POST["exam_group_class_batch_exams_id"];
    
    $query = "SELECT exam_group_class_batch_exam_subjects.exam_group_class_batch_exams_id, 
    exam_group_class_batch_exam_subjects.subject_id, 
    exam_group_class_batch_exam_subjects.date_from, 
    exam_group_class_batch_exam_subjects.time_from, 
    exam_group_class_batch_exam_subjects.room_no, `subjects`.`name` as `subject_name`,
    exam_group_class_batch_exams.exam, exam_group_class_batch_exams.is_active
    FROM `exam_group_class_batch_exam_subjects` 
    JOIN `subjects` ON `subjects`.`id` = `exam_group_class_batch_exam_subjects`.`subject_id` 
    JOIN exam_group_class_batch_exams on exam_group_class_batch_exams.id = exam_group_class_batch_exam_subjects.exam_group_class_batch_exams_id
    WHERE `exam_group_class_batch_exam_subjects`.`exam_group_class_batch_exams_id`= $exam_group_class_batch_exams_id
    ORDER BY `exam_group_class_batch_exam_subjects`.`exam_group_class_batch_exams_id` DESC, 
    `exam_group_class_batch_exam_subjects`.`date_from` ASC";
    
    $result = $con->query($query);

    if ($result && $result->num_rows > 0) {
        $itemData = $result->fetch_all(MYSQLI_ASSOC);
        $response = array("status" => "1", "message" => "Matching items retrieved successfully", "data" => $itemData);
    } else {
        $response = array("status" => "0", "message" => "No matching items found");
    }
} else {
    $response = array("status" => "0", "message" => "Invalid request method. Please use POST.");
}

echo json_encode($response);
?>