1#@!#!123s

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

// Check if student_id is received via POST
if (isset($_POST['student_id']) && isset($_POST['session_id'])) {
    $studentId = $_POST['student_id'];
    $sessionId = $_POST['session_id'];
    
    $query = "SELECT * FROM student_session WHERE student_id = '$studentId' AND session_id = '$sessionId'";
    $result = $con->query($query);
    $row = $result->fetch_all(MYSQLI_ASSOC);

    if (empty($row)) {
        $response = array("status" => "0", "message" => "No records found for the student ID", "student_session" => $row);
    } else {
        $studentSessionData = array();
        foreach ($row as $studentSession) {
            $sessionId = $studentSession['session_id'];
            $classId = $studentSession['class_id'];
            $sectionId = $studentSession['section_id'];

            // Fetch data from the sessions table
            $sessionQuery = "SELECT * FROM sessions WHERE id = '$sessionId'";
            $sessionResult = $con->query($sessionQuery);
            $sessionData = $sessionResult->fetch_assoc();
            
            
            // Fetch data from the sessions table
            $classSecQuery = "SELECT * FROM `class_sections` WHERE class_id ='$classId' AND section_id ='$sectionId'";
            $classSecResult = $con->query($classSecQuery);
            $classSecData = $classSecResult->fetch_assoc();

            // Fetch data from the classes table
            $classQuery = "SELECT * FROM classes WHERE id = '$classId'";
            $classResult = $con->query($classQuery);
            $classData = $classResult->fetch_assoc();

            // Fetch data from the sections table
            $sectionQuery = "SELECT * FROM sections WHERE id = '$sectionId'";
            $sectionResult = $con->query($sectionQuery);
            $sectionData = $sectionResult->fetch_assoc();

            // Combine the fetched data into the student_session data
            $studentSession['session_data'] = $sessionData;
            $studentSession['class_data'] = $classData;
            $studentSession['section_data'] = $sectionData;
            $studentSession['class_sec_data'] = $classSecData;

            $studentSessionData[] = $studentSession;
        }

        $response = array("status" => "1", "message" => "Data retrieved successfully", "student_session" => $studentSessionData);
    }
} else {
    $response = array("status" => "0", "message" => "Invalid request. Please provide a student ID via POST.");
}

// Add the 'student_session_id' to the final response
if (!empty($studentSessionData)) {
    $response['last_student_session_id'] = $studentSessionData[0]['id'];
}

echo json_encode($response);
?>