1#@!#!123s

: / home / schoolcampuserp / erp.bethelschool.co.in / api / app_api /
Filename : get_student_details.php
back
<?php
include 'connection.php';

// Check if student_id or user_id is received via POST
if (isset($_POST['student_id'])) {
    $studentId = isset($_POST['student_id']);

    $query ="SELECT * FROM student_session WHERE student_id = '$studentId'";
    $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 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();

            // Fetch data from the users table
            $userQuery = "SELECT * FROM users WHERE user_id = '$studentId' LIMIT 1";
            $userResult = $con->query($userQuery);
            $userData = $userResult->fetch_assoc();

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

            $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 or user ID via POST.");
}

echo json_encode($response);
?>