1#@!#!123s

: / home / schoolcampuserp / erp.bethelschool.co.in / api / app_api /

Filename : get_exam_group_class_batch_exams.php

back

<?php
include 'connection.php';

if ($_SERVER["REQUEST_METHOD"] === "POST") {
    $exam_group_id = $_POST["exam_group_id"];
    
    $query = "SELECT 
    egcbe.*, 
    s.session
FROM 
    exam_group_class_batch_exams AS egcbe
JOIN 
    sessions AS s
ON 
    egcbe.session_id = s.id
WHERE 
    egcbe.exam_group_id = '$exam_group_id'";
    
    $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);
?>