$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();
- $fligths = $connection->get_result_array();
+ $flights = $connection->get_result_array();
$connection->close_prepared_query();
- //var_dump($fligths);
- if (empty($fligths)) {
+ //var_dump($flights);
+ if (empty($flights)) {
echo "Aucun vol ne correspond aux critères de recherche. <br>";
} else {
if ($action === "return_flight" && isset($_SESSION['return_flight_nb_place'])) {
echo " <th>Prix d'une place</th>\n";
echo " <th>Réserver</th>\n";
echo " </tr>\n";
- foreach ($fligths as $fligth) {
+ 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($fligth['NumVol']));
+ $connection->prepared_query_bind_param("s", array($flight['NumVol']));
$connection->run_prepared_query();
$connection->get_pquery_result();
$rows = $connection->get_result_array();
if (is_null($booked_places)) {
$booked_places = 0;
}
- if (isset($fligth['CapAv']) && isset($booked_places)) {
- $free_places = $fligth['CapAv'] - $booked_places;
+ if (isset($flight['CapAv']) && isset($booked_places)) {
+ $free_places = $flight['CapAv'] - $booked_places;
} else {
$free_places = "Inconnu";
}
echo " <tr>\n";
- echo " <td>" . $fligth['NumVol'] . "</td>\n";
- echo " <td>" . $fligth['VilleD'] . "</td>\n";
- echo " <td>" . $fligth['DateD'] . "</td>\n";
- echo " <td>" . $fligth['VilleA'] . "</td>\n";
- echo " <td>" . $fligth['DateA'] . "</td>\n";
- echo " <td>" . $fligth['Classe'] . "</td>\n";
- echo " <td>" . $fligth['Prix'] . "€</td>\n";
+ echo " <td>" . $flight['NumVol'] . "</td>\n";
+ echo " <td>" . $flight['VilleD'] . "</td>\n";
+ echo " <td>" . $flight['DateD'] . "</td>\n";
+ echo " <td>" . $flight['VilleA'] . "</td>\n";
+ echo " <td>" . $flight['DateA'] . "</td>\n";
+ echo " <td>" . $flight['Classe'] . "</td>\n";
+ echo " <td>" . $flight['Prix'] . "€</td>\n";
echo " <td>
Nombre de places libres : " . $free_places . "
<form action=\"index.php\" id=\"booking\" method=\"post\">
<input type=\"hidden\" name=\"form\" value=\"booking\" />
- <input type=\"hidden\" name=\"flight_id\" value=\"" . $fligth['NumVol'] . "\" />
- <input type=\"hidden\" name=\"class_name\" value=\"" . $fligth['Classe'] . "\" />
- <input type=\"hidden\" name=\"place_price\" value=\"" . $fligth['Prix'] . "\" />
+ <input type=\"hidden\" name=\"flight_id\" value=\"" . $flight['NumVol'] . "\" />
+ <input type=\"hidden\" name=\"class_name\" value=\"" . $flight['Classe'] . "\" />
+ <input type=\"hidden\" name=\"place_price\" value=\"" . $flight['Prix'] . "\" />
<label> Place(s) : </label>
<input type=\"number\" name=\"nb_place\" min=\"1\" max=\"9\" value=\"" . $nb_places . "\" required/>\n";
if ($action !== "return_flight") {