"; $_SESSION['login_referer'] = $_SERVER['HTTP_REFERER']; redirect("index.php?page=login", 2); } $input_failure = false; if (!$form_place_price) { echo "Prix invalide.
"; $input_failure = true; } if (!$form_nb_place) { echo "Nombre de place(s) invalide.
"; $input_failure = true; } if (is_null($form_return_flight)) { $form_return_flight = false; } elseif (!$form_return_flight) { echo "Vol retour invalide.
"; $input_failure = true; } if (!$input_failure && $is_logged_in && !empty($form_nb_place) && !empty($form_class_name)) { global $connection; $client_id = get_client_id($_SESSION['email']); $nb_booked = nb_booked($client_id, $form_flight_id, $form_class_name); if (!empty($nb_booked)) { echo "Vous avez déjà réservé ce vol, vous allez être redirigé vers la liste de vos réservations dans 2 secondes.
"; redirect("index.php?page=reservations", 2); include('footer.html'); exit(); } $sql_pquery = "insert into RESERVATIONS (NumCl, NumVol, Classe, NbPlaces) values (?, ?, ?, ?)"; $connection->prepare_query($sql_pquery); $connection->prepared_query_bind_param("issi", array($client_id, $form_flight_id, $form_class_name, $form_nb_place)); $connection->run_prepared_query(); $connection->close_prepared_query(); $sql_pquery = "select VilleD, DateD, VilleA, DateA from VOLS, DEFCLASSES where DEFCLASSES.NumVol = VOLS.NumVol and VOLS.NumVol = ? and Classe = ?"; $connection->prepare_query($sql_pquery); $connection->prepared_query_bind_param("ss", array($form_flight_id, $form_class_name)); $connection->run_prepared_query(); $connection->get_pquery_result(); $rows = $connection->get_result_array(); $connection->close_prepared_query(); foreach ($rows as $row) { echo "(Simulation de validation et paiement d'une réservation)
"; echo "Vous avez réservé et payé " . $form_nb_place . " place(s) sur le vol " .$form_flight_id . " au départ de " . $row['VilleD']. " à " . $row['DateD'] . " arrivant à " . $row['VilleA'] . " à " . $row['DateA'] . " pour un montant total de " . $form_place_price * $form_nb_place . "€.
"; } if ($form_return_flight) { $_SESSION['return_flight_departure_city'] = $row['VilleA']; $_SESSION['return_flight_arrival_city'] = $row['VilleD']; $_SESSION['return_flight_departure_date'] = $row['DateA']; $_SESSION['return_flight_nb_place'] = $form_nb_place; redirect("index.php?page=search&action=return_flight", 3); } else { redirect("index.php?page=reservations", 3); } } else { echo "Make an error message.
"; } ?>