<?php
include "../ConnectDB.php";

$destinationCity = $_REQUEST["destinationCity"];
$departureCity = $_REQUEST["departureCity"];


$start=microtime(true);
$sql = "SELECT
transport_flight.flight_id,
transport_flight.flight_code,
departure_city.name AS from_name,
arrival_city.name AS dest_name,
transport_airline.name AS air_name
FROM
transport_flight
JOIN
transport_airport AS departure_airport ON transport_flight.from_airport_id = departure_airport.airport_id
JOIN
transport_airport AS arrival_airport ON transport_flight.dest_airport_id = arrival_airport.airport_id
JOIN
transport_airline ON transport_flight.airline_id = transport_airline.airline_id
JOIN
cities AS departure_city ON departure_airport.city_id = departure_city.id
JOIN
cities AS arrival_city ON arrival_airport.city_id = arrival_city.id
WHERE arrival_city.name LIKE '%".$destinationCity."%' AND departure_city.id='".$departureCity."'";

$result = $conn->query($sql);
$end = microtime(true);
$execution_time = $end - $start;
$data = array();
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        $data[] = $row;
    }
} else {
    $data[] = "No result";
}

echo json_encode(array("data" => $data,"time"=>$execution_time));
?>