includes/formmodify.php

   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 enregistre&#769;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 ?>