1#@!#!123s

: / home / bmsnrajganj / public_html / erp / api / app_api /
Filename : get_driver_location.php
back
<?php
include 'connection.php';

if ($_SERVER["REQUEST_METHOD"] === "POST") {
    $student_id = $_POST["student_id"];
    $session_id = $_POST["session_id"];
    
    $query = "SELECT
	s.id,
    s.firstname,
    s.admission_no,
    s.route_id,
    s.vehroute_id,
     ss.session_id,
    v.vehicle_no,
    v.vehicle_model,
    v.driver_name,
    v.driver_licence,
    v.driver_contact,
    dcl.current_location,
    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
LEFT JOIN student_session ss ON s.id = ss.student_id 
LEFT JOIN driver_current_location dcl ON s.route_id = dcl.route_id
WHERE s.id = '$student_id' AND ss.session_id ='$session_id'";
    $result = $con->query($query);
    $row = $result->fetch_all(MYSQLI_ASSOC);

    if (empty($row)) {
        $response = array("status" => "0", "message" => "Its empty", "data" => $row);
    } else {
        $response = array("status" => "1", "message" => "Its Available", "data" => $row);
    }

} else {
    $response = array("status" => "0", "message" => "Invalid request method. Please use POST.");
}

echo json_encode($response);
?>