";
$input_failure = true;
}
if ($oDepartureDate < $oDateNow) {
echo "The departure date is before the current date.
";
$input_failure = true;
}
if ($oArrivalDate <= $oDepartureDate) {
echo "Arrival date is before departure date.
";
$input_failure = true;
}
?>
Rechercher un vol
= ? 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();
$rows = $connection->get_result_array();
$connection->close_prepared_query();
//var_dump($rows);
if (empty($rows)) {
echo "Aucun vol ne correspond aux critères de recherche.
";
} else {
echo "\n";
echo " \n";
echo " | Numéro de vol | \n";
echo " Ville de départ | \n";
echo " Date de départ | \n";
echo " Ville d'arrivée | \n";
echo " Date d'arrivée | \n";
echo " Classe | \n";
echo " Prix d'une place | \n";
echo " Réserver | \n";
echo "
\n";
foreach ($rows as $row) {
echo " \n";
echo " | " . $row['NumVol'] . " | \n";
echo " " . $row['VilleD'] . " | \n";
echo " " . $row['DateD'] . " | \n";
echo " " . $row['VilleA'] . " | \n";
echo " " . $row['DateA'] . " | \n";
echo " " . $row['Classe'] . " | \n";
echo " " . $row['Prix'] . "€ | \n";
echo "
| \n";
echo "
\n";
}
echo "
";
}
}
?>