Commit | Line | Data |
---|---|---|
c49f7219 | 1 | <?php |
8d17cae3 JB |
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 | } | |
c49f7219 JB |
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']); | |
8d17cae3 | 13 | echo "<h1> Modification de la réservation sur le vol $flight_id </h2>\n"; |
c49f7219 JB |
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> |