1#@!#!123s

: / home / schoolcampuserp / nepsmunger.com / api / app_api /
Filename : get_timetables.php
back
<?php
include 'connection.php';

if ($_SERVER["REQUEST_METHOD"] === "POST") {
    $class_id = $_POST["class_id"];
    
    $query = "SELECT st.day, sbj.name AS subject, cls.class, st.time_from, st.time_to, st.room_no
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";
    
    $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);
?>