1#@!#!123s

: / home / schoolcampuserp / gyangurukulacademy.in / api / app_api4 /
Filename : get_exam_name.php
back
<?php
include 'connection.php';

if ($_SERVER["REQUEST_METHOD"] === "POST") {
    $student_session_id = $_POST["student_session_id"];
    
    $query = "SELECT exam_group_class_batch_exam_students.id,
    exam_group_class_batch_exam_students.student_id,exam_group_class_batch_exams.id as
    `exam_group_class_batch_exam_id`,
    exam_group_class_batch_exams.exam 
    FROM `exam_group_class_batch_exam_students` 
    INNER JOIN exam_group_class_batch_exams on
    exam_group_class_batch_exam_students.exam_group_class_batch_exam_id=exam_group_class_batch_exams.id
    WHERE student_session_id= $student_session_id 
    and exam_group_class_batch_exams.is_active=1 
    ORDER BY `exam_group_class_batch_exam_students`.`updated_at` DESC";
    
    $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);
?>