| 1 | <?php |
| 2 | $form_flight_id = filter_input(INPUT_POST, "flight_id", FILTER_SANITIZE_STRING); |
| 3 | $form_class_name = filter_input(INPUT_POST, "class_name", FILTER_SANITIZE_STRING); |
| 4 | $form_cancel = filter_input(INPUT_POST, "cancel", FILTER_SANITIZE_STRING); |
| 5 | |
| 6 | global $is_logged_in; |
| 7 | if (!$is_logged_in) { |
| 8 | echo "Please login first. <br>"; |
| 9 | $_SESSION['login_referer'] = $_SERVER['HTTP_REFERER']; |
| 10 | redirect("index.php?page=login", 2); |
| 11 | } |
| 12 | |
| 13 | if (isset($form_cancel) && isset($form_flight_id) && isset($form_class_name) && |
| 14 | $is_logged_in) { |
| 15 | $client_id = get_client_id($_SESSION['email']); |
| 16 | global $connection; |
| 17 | $sql_pquery = "delete from RESERVATIONS |
| 18 | where NumCl = ? and NumVol = ? and Classe = ?"; |
| 19 | $connection->prepare_query($sql_pquery); |
| 20 | $connection->prepared_query_bind_param("iss", array($client_id, $form_flight_id, $form_class_name)); |
| 21 | $connection->run_prepared_query(); |
| 22 | $connection->close_prepared_query(); |
| 23 | echo "Votre réservation a été annulée. <br>"; |
| 24 | redirect("index.php?page=reservations", 3); |
| 25 | } else { |
| 26 | echo "Make an error message. <br>"; |
| 27 | echo "<a href=\"javascript:history.go(-1)\">Retour</a>"; |
| 28 | } |
| 29 | |
| 30 | ?> |