X-Git-Url: https://git.piment-noir.org/?p=Project_webapp.git;a=blobdiff_plain;f=includes%2Fmodify.php;fp=includes%2Fmodify.php;h=aeb9741444e0b39a1df6028e9bab8c5f5b6f83ee;hp=0000000000000000000000000000000000000000;hb=c49f721926f5d76a8eef80bd5174d68b5a151442;hpb=77c2d82c70ae6b1629d372b3c4642cdc2a994698

diff --git a/includes/modify.php b/includes/modify.php
new file mode 100644
index 0000000..aeb9741
--- /dev/null
+++ b/includes/modify.php
@@ -0,0 +1,45 @@
+<?php
+$flight_id = filter_input(INPUT_GET, "flight_id", FILTER_SANITIZE_STRING);
+$class_name = filter_input(INPUT_GET, "class_name", FILTER_SANITIZE_STRING);
+$client_id = get_client_id($_SESSION['email']);
+echo "<h1> Modification de la re&#769;servation sur le vol $flight_id</h2>\n";
+global $connection;
+$sql_pquery = "select NumCl, NumVol, Classe, NbPlaces
+               from RESERVATIONS
+       		   where NumCl = ? and NumVol = ? and Classe = ?";
+$connection->prepare_query($sql_pquery);
+$connection->prepared_query_bind_param("iss", array($client_id, $flight_id, $class_name));
+$connection->run_prepared_query();
+$connection->get_pquery_result();
+$rows = $connection->get_result_array();
+$connection->close_prepared_query();
+?>
+<form action="index.php" id="modify" method="post">
+  <input type="hidden" name="form" value="modify" />
+  <input type="hidden" name="flight_id" value="<?php echo $rows[0]['NumVol'] ?>" />
+  <label> Nombre de place(s) : </label>
+  <input type="number" name="nb_place" min="1" max="9" value="<?php echo $rows[0]['NbPlaces'] ?>" required/>
+  <label> Classe : </label>
+  <select size="1" name="class_name" required>
+   <optgroup label="Se&#769;lectionner une classe">
+  <?php
+  $sql_pquery = "select distinct Classe from DEFCLASSES where NumVol = ?";
+  global $connection;
+  $connection->prepare_query($sql_pquery);
+  $connection->prepared_query_bind_param("s", array($flight_id));
+  $connection->run_prepared_query();
+  $connection->get_pquery_result();
+  $classes = $connection->get_result_array();
+  $connection->close_prepared_query();
+  foreach ($classes as $class) {
+      if (strcmp($class[0], $rows[0]['Classe']) === 0) {
+          echo "<option value=\"$class[0]\" selected>$class[0]</option>\n";
+      } else {
+          echo "<option value=\"$class[0]\">$class[0]</option>\n";
+      }
+  }
+  ?>
+   </optgroup>
+  </select>
+  <input type="submit" value="Valider">
+</form>