1#@!#!123s

: / home / schoolcampuserp / sxdps.in / api / app_api /
Filename : get_lessons_details.php
back
<?php
include 'connection.php';

if ($_SERVER["REQUEST_METHOD"] === "POST") {
    $session_id = $_POST["session_id"];
    $date = $_POST["date"];

    $query = "SELECT subject_syllabus.*, subject_groups.name as sgname, subjects.name as subname, subjects.code as scode, sections.section as sname, classes.class as cname, lesson.name as lessonname, topic.name as topic_name FROM subject_syllabus JOIN topic ON topic.id = subject_syllabus.topic_id JOIN lesson ON lesson.id = topic.lesson_id JOIN subject_group_subjects ON subject_group_subjects.id = lesson.subject_group_subject_id JOIN subject_groups ON subject_groups.id = subject_group_subjects.subject_group_id JOIN subjects ON subjects.id = subject_group_subjects.subject_id INNER JOIN subject_group_class_sections ON subject_group_class_sections.id = lesson.subject_group_class_sections_id JOIN class_sections ON class_sections.id = subject_group_class_sections.class_section_id JOIN sections ON sections.id = class_sections.section_id JOIN classes ON classes.id = class_sections.class_id WHERE lesson.subject_group_class_sections_id = '5' AND  subject_syllabus.date = '$date' AND subject_syllabus.session_id = '$session_id' GROUP BY subject_syllabus.id";

    $result = $con->query($query);
    $rows = $result->fetch_all(MYSQLI_ASSOC);

    // Echo the response
    echo json_encode($rows);
} else {
    $response = array("status" => "0", "message" => "Invalid request method. Please use POST.");
    echo json_encode($response);
}
?>