1#@!#!123s

: / home / schoolcampuserp / erp.bnninternationalschool.com / api / app_api /
Filename : get_student_info.php
back
<?php
include 'connection.php';

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

    $query = "SELECT
    s.*,
    c.category AS category_name,
    sh.house_name AS school_house_name,
    hr.room_no,
    v.vehicle_no,
    v.vehicle_model,
    v.driver_name,
    v.driver_licence,
    v.driver_contact,
    tr.route_title AS vehicle_route_title
FROM students s
LEFT JOIN categories c ON s.category_id = c.id
LEFT JOIN school_houses sh ON s.school_house_id = sh.id
LEFT JOIN hostel_rooms hr ON s.hostel_room_id = hr.id
LEFT JOIN vehicle_routes vr ON s.vehroute_id = vr.id
LEFT JOIN vehicles v ON vr.vehicle_id = v.id
LEFT JOIN transport_route tr ON vr.route_id = tr.id
WHERE s.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_session_id", "student_attendance" => $row);
    } else {
        $response = array("status" => "1", "message" => "Data retrieved successfully", "student_attendance" => $row);
    }
} else {
    $response = array("status" => "0", "message" => "Invalid request. Please provide a student_session_id via POST.");
}

echo json_encode($response);

?>