"; $input_failure = true; } if ($oDepartureDate < $oDateNow) { echo "The departure date is before the current date.
"; $input_failure = true; } if (!($action === "return_flight") && $oArrivalDate <= $oDepartureDate) { echo "Arrival date is before departure date.
"; $input_failure = true; } if (empty($form_arrival_date)) { // Limit to a 6 months interval from the departure date. $oArrivalDate = $oDepartureDate; $oArrivalDate->add(new DateInterval("P6M")); $form_arrival_date = $oArrivalDate->format('Y-m-d\TH:i'); } ?>

Rechercher un vol

"; } ?> Départ : Ville -> Date -> Arrivée : Ville -> Date -> />

= ? and VilleD = ? and DateA <= ? and VilleA = ? order by DateD, NumVol, Prix"; $connection->prepare_query($sql_pquery); $connection->prepared_query_bind_param("ssss", array($form_departure_date, $form_departure_city, $form_arrival_date, $form_arrival_city)); $connection->run_prepared_query(); $connection->get_pquery_result(); $flights = $connection->get_result_array(); $connection->close_prepared_query(); //var_dump($flights); if (empty($flights)) { echo "Aucun vol ne correspond aux critères de recherche.
"; } else { if ($action === "return_flight" && isset($_SESSION['return_flight_nb_place'])) { $nb_places = $_SESSION['return_flight_nb_place']; unset($_SESSION['return_flight_nb_place']); } else { $nb_places = 1; } echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; foreach ($flights as $flight) { $sql_pquery = "select sum(NbPlaces) as BookedPlaces from RESERVATIONS where NumVol = ?"; $connection->prepare_query($sql_pquery); $connection->prepared_query_bind_param("s", array($flight['NumVol'])); $connection->run_prepared_query(); $connection->get_pquery_result(); $rows = $connection->get_result_array(); $connection->close_prepared_query(); $booked_places = $rows[0][0]; if (is_null($booked_places)) { $booked_places = 0; } if (isset($flight['CapAv']) && isset($booked_places)) { $free_places = $flight['CapAv'] - $booked_places; } else { $free_places = "Inconnu"; } echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; } echo "

Numéro de vol	Ville de départ	Date de départ	Ville d'arrivée	Date d'arrivée	Classe	Prix d'une place	Réserver
" . $flight['NumVol'] . "	" . $flight['VilleD'] . "	" . $flight['DateD'] . "	" . $flight['VilleA'] . "	" . $flight['DateA'] . "	" . $flight['Classe'] . "	" . $flight['Prix'] . "€	Nombre de places libres : " . $free_places . " Place(s) : \n"; if ($action !== "return_flight") { echo " Vol retour : \n"; echo " \n"; } if ($free_places !== 0 \|\| $free_places === "Inconnu") { echo " \n"; } echo "

\n"; } } ?>