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
);
9 echo "Please login first. <br>";
10 $_SESSION['login_referer'] = $_SERVER['HTTP_REFERER'];
11 redirect("index.php?page=login", 2);
14 $input_failure = false;
16 if (!$form_nb_place) {
17 echo "Nombre de place(s) invalide. <br>";
18 $input_failure = true;
21 if (!$input_failure && $is_logged_in && !empty($form_nb_place) && !empty($form_class_name) && !empty($form_previous_class_name)) {
23 $client_id = get_client_id($_SESSION['email']);
24 if (strcmp($form_class_name, $form_previous_class_name) === 0) {
25 $sql_pquery = "update RESERVATIONS
27 where NumCl = ? and NumVol = ? and Classe = ?";
29 $sql_pquery = "update RESERVATIONS
30 set NbPlaces = ?, Classe = ?
31 where NumCl = ? and NumVol = ? and Classe = ?";
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));
37 $connection->prepared_query_bind_param("isiss", array($form_nb_place, $form_class_name, $client_id, $form_flight_id, $form_previous_class_name));
39 $connection->run_prepared_query();
40 $connection->close_prepared_query();
41 echo "Modifications enregistrées. <br>";
42 redirect("index.php?page=reservations", 3);
44 echo "Make an error message. <br>";
45 echo "<a href=\"javascript:history.go(-1)\">Retour</a>";