1#@!#!123s

: / home / schoolcampuserp / erp.bethelschool.co.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'];
    $Session_id= $_POST['session_id'];

    $query = "SELECT
    subjects.name,
    subjects.id,
    subject_group_subjects.id as subject_group_subject_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'
    AND subject_group_subjects.session_id = '$Session_id'";
    $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);

?>