1#@!#!123s

: / home / schoolcampuserp / navalokenglishacademy.in / api / app_api1 /
Filename : get_timetables.php
back
<?php
include 'connection.php';

if ($_SERVER["REQUEST_METHOD"] === "POST") {
    $class_id = $_POST["class_id"];
    $section_id = $_POST["section_id"];
    $session_id = $_POST["session_id"];
    
    $query = "SELECT DISTINCT st.day, 
                sbj.name AS subject, 
                cls.class, 
                st.time_from, 
                st.time_to, 
                st.room_no,
                st.session_id,
                st.class_id,
                st.section_id
FROM subject_timetable st
JOIN subject_group_subjects sgs ON st.subject_group_subject_id = sgs.id
JOIN subjects sbj ON sgs.subject_id = sbj.id
JOIN subject_group_class_sections sgcs ON st.subject_group_id = sgcs.subject_group_id
JOIN class_sections csec ON sgcs.class_section_id = csec.id
JOIN classes cls ON csec.class_id = cls.id 
WHERE st.class_id = $class_id  AND st.section_id=$section_id AND st.session_id =$session_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);
?>