1#@!#!123s

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


if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST)) {
    $Class = $_POST['class'];
    $Section = $_POST['section'];

    $query = "SELECT
    subjects.name,
    subjects.id,
    subject_group_subjects.subject_group_id,
    subject_group_subjects.session_id,
    class_sections.class_id,
    class_sections.section_id,
    classes.class,
    sections.section
FROM 
    class_sections
JOIN 
    subject_group_class_sections ON class_sections.id = subject_group_class_sections.class_section_id
JOIN 
    subject_group_subjects ON subject_group_class_sections.subject_group_id = subject_group_subjects.subject_group_id
JOIN 
    subjects ON subject_group_subjects.subject_id = subjects.id
JOIN 
    classes ON class_sections.class_id = classes.id
JOIN 
    sections ON class_sections.section_id = sections.id
WHERE 
    classes.class ='$Class' 
    AND sections.section = '$Section'";
    $result = $con->query($query);
    $row = $result->fetch_all(MYSQLI_ASSOC);

    if (empty($row)) {
        $response = array("status" => "0", "message" => "No records found", "subject" => $row);
    } else {
        $response = array("status" => "1", "message" => "Data retrieved successfully", "subject" => $row);
    }
} else {
    $response = array("status" => "0", "message" => "Invalid request. Please provide a student_session_id via POST.");
}

echo json_encode($response);

?>