includes/modify.php

   1 <?php
   2 global $is_logged_in;
   3 if (!$is_logged_in) {
   4     echo "Please login first. <br>";
   5     $_SESSION['login_referer'] = $_SERVER['HTTP_REFERER'];
   6     redirect("index.php?page=login", 2);
   7     include('footer.html');
   8     exit();
   9 }
  10 $flight_id = filter_input(INPUT_GET, "flight_id", FILTER_SANITIZE_STRING);
  11 $class_name = filter_input(INPUT_GET, "class_name", FILTER_SANITIZE_STRING);
  12 $client_id = get_client_id($_SESSION['email']);
  13 echo "<h1> Modification de la re&#769;servation sur le vol $flight_id </h2>\n";
  14 global $connection;
  15 $sql_pquery = "select NumCl, NumVol, Classe, NbPlaces
  16                from RESERVATIONS
  17                    where NumCl = ? and NumVol = ? and Classe = ?";
  18 $connection->prepare_query($sql_pquery);
  19 $connection->prepared_query_bind_param("iss", array($client_id, $flight_id, $class_name));
  20 $connection->run_prepared_query();
  21 $connection->get_pquery_result();
  22 $rows = $connection->get_result_array();
  23 $connection->close_prepared_query();
  24 ?>
  25 <form action="index.php" id="modify" method="post">
  26   <input type="hidden" name="form" value="modify" />
  27   <input type="hidden" name="flight_id" value="<?php echo $rows[0]['NumVol'] ?>" />
  28   <input type="hidden" name="previous_class_name" value="<?php echo $rows[0]['Classe'] ?>" />
  29   <label> Nombre de place(s) : </label>
  30   <input type="number" name="nb_place" min="1" max="9" value="<?php echo $rows[0]['NbPlaces'] ?>" required/>
  31   <label> Classe : </label>
  32   <select size="1" name="class_name" required>
  33    <optgroup label="Se&#769;lectionner une classe">
  34   <?php
  35   $sql_pquery = "select distinct Classe from DEFCLASSES where NumVol = ? order by Classe";
  36   global $connection;
  37   $connection->prepare_query($sql_pquery);
  38   $connection->prepared_query_bind_param("s", array($flight_id));
  39   $connection->run_prepared_query();
  40   $connection->get_pquery_result();
  41   $classes = $connection->get_result_array();
  42   $connection->close_prepared_query();
  43   foreach ($classes as $class) {
  44       if (strcmp($class[0], $rows[0]['Classe']) === 0) {
  45           echo "<option value=\"$class[0]\" selected>$class[0]</option>\n";
  46       } else {
  47           echo "<option value=\"$class[0]\">$class[0]</option>\n";
  48       }
  49   }
  50   ?>
  51    </optgroup>
  52   </select>
  53   <input type="submit" value="Valider">
  54 </form>