Commit | Line | Data |
---|---|---|
c49f7219 JB |
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); | |
f38123a5 | 4 | $form_previous_class_name = filter_input(INPUT_POST, "previous_class_name", FILTER_SANITIZE_STRING); |
c49f7219 JB |
5 | $form_class_name = filter_input(INPUT_POST, "class_name", FILTER_SANITIZE_STRING); |
6 | ||
f38123a5 JB |
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 | ||
8d17cae3 JB |
14 | $input_failure = false; |
15 | ||
16 | if (!$form_nb_place) { | |
17 | echo "Nombre de place(s) invalide. <br>"; | |
18 | $input_failure = true; | |
19 | } | |
20 | ||
a0e7c679 | 21 | if (!$input_failure && $is_logged_in && !empty($form_nb_place) && !empty($form_class_name) && !empty($form_previous_class_name)) { |
8d17cae3 JB |
22 | global $connection; |
23 | $client_id = get_client_id($_SESSION['email']); | |
a0e7c679 JB |
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 | } | |
8d17cae3 | 33 | $connection->prepare_query($sql_pquery); |
a0e7c679 JB |
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 | } | |
8d17cae3 JB |
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 | ||
c49f7219 | 48 | ?> |