| 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 ré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 | <label> Nombre de place(s) : </label> |
| 29 | <input type="number" name="nb_place" min="1" max="9" value="<?php echo $rows[0]['NbPlaces'] ?>" required/> |
| 30 | <label> Classe : </label> |
| 31 | <select size="1" name="class_name" required> |
| 32 | <optgroup label="Sélectionner une classe"> |
| 33 | <?php |
| 34 | $sql_pquery = "select distinct Classe from DEFCLASSES where NumVol = ?"; |
| 35 | global $connection; |
| 36 | $connection->prepare_query($sql_pquery); |
| 37 | $connection->prepared_query_bind_param("s", array($flight_id)); |
| 38 | $connection->run_prepared_query(); |
| 39 | $connection->get_pquery_result(); |
| 40 | $classes = $connection->get_result_array(); |
| 41 | $connection->close_prepared_query(); |
| 42 | foreach ($classes as $class) { |
| 43 | if (strcmp($class[0], $rows[0]['Classe']) === 0) { |
| 44 | echo "<option value=\"$class[0]\" selected>$class[0]</option>\n"; |
| 45 | } else { |
| 46 | echo "<option value=\"$class[0]\">$class[0]</option>\n"; |
| 47 | } |
| 48 | } |
| 49 | ?> |
| 50 | </optgroup> |
| 51 | </select> |
| 52 | <input type="submit" value="Valider"> |
| 53 | </form> |