| 1 | <?php |
| 2 | $form_flight_id = filter_input(INPUT_POST, "flight_id", FILTER_SANITIZE_STRING); |
| 3 | $form_nb_place = filter_input(INPUT_POST, "nb_place", FILTER_VALIDATE_INT); |
| 4 | $form_previous_class_name = filter_input(INPUT_POST, "previous_class_name", FILTER_SANITIZE_STRING); |
| 5 | $form_class_name = filter_input(INPUT_POST, "class_name", FILTER_SANITIZE_STRING); |
| 6 | |
| 7 | global $is_logged_in; |
| 8 | if (!$is_logged_in) { |
| 9 | echo "Please login first. <br>"; |
| 10 | $_SESSION['login_referer'] = $_SERVER['HTTP_REFERER']; |
| 11 | redirect("index.php?page=login", 2); |
| 12 | } |
| 13 | |
| 14 | $input_failure = false; |
| 15 | |
| 16 | if (!$form_nb_place) { |
| 17 | echo "Nombre de place(s) invalide. <br>"; |
| 18 | $input_failure = true; |
| 19 | } |
| 20 | |
| 21 | if (!$input_failure && $is_logged_in && !empty($form_nb_place) && !empty($form_class_name) && !empty($form_previous_class_name)) { |
| 22 | global $connection; |
| 23 | $client_id = get_client_id($_SESSION['email']); |
| 24 | if (strcmp($form_class_name, $form_previous_class_name) === 0) { |
| 25 | $sql_pquery = "update RESERVATIONS |
| 26 | set NbPlaces = ? |
| 27 | where NumCl = ? and NumVol = ? and Classe = ?"; |
| 28 | } else { |
| 29 | $sql_pquery = "update RESERVATIONS |
| 30 | set NbPlaces = ?, Classe = ? |
| 31 | where NumCl = ? and NumVol = ? and Classe = ?"; |
| 32 | } |
| 33 | $connection->prepare_query($sql_pquery); |
| 34 | if (strcmp($form_class_name, $form_previous_class_name) === 0) { |
| 35 | $connection->prepared_query_bind_param("iiss", array($form_nb_place, $client_id, $form_flight_id, $form_previous_class_name)); |
| 36 | } else { |
| 37 | $connection->prepared_query_bind_param("isiss", array($form_nb_place, $form_class_name, $client_id, $form_flight_id, $form_previous_class_name)); |
| 38 | } |
| 39 | $connection->run_prepared_query(); |
| 40 | $connection->close_prepared_query(); |
| 41 | echo "Modifications enregistrées. <br>"; |
| 42 | redirect("index.php?page=reservations", 3); |
| 43 | } else { |
| 44 | echo "Make an error message. <br>"; |
| 45 | echo "<a href=\"javascript:history.go(-1)\">Retour</a>"; |
| 46 | } |
| 47 | |
| 48 | ?> |