X-Git-Url: https://git.piment-noir.org/?p=Project_webapp.git;a=blobdiff_plain;f=includes%2Fformmodify.php;h=a09debeb035b46008d279e7df50a2262a87a5dd9;hp=6b6490612b85681dedc8cbc15bd7ca3fa4389a88;hb=a0e7c679474abba8e61aa6241f7a5293ab631cc1;hpb=f38123a5d3eafd9af6fb25e1dd5ccf29c5508b36

diff --git a/includes/formmodify.php b/includes/formmodify.php
index 6b64906..a09debe 100644
--- a/includes/formmodify.php
+++ b/includes/formmodify.php
@@ -18,14 +18,24 @@ if (!$form_nb_place) {
     $input_failure = true;
 }
 
-if (!$input_failure && $is_logged_in && !empty($form_nb_place) && !empty($form_class_name)) {
+if (!$input_failure && $is_logged_in && !empty($form_nb_place) && !empty($form_class_name) && !empty($form_previous_class_name)) {
     global $connection;
     $client_id = get_client_id($_SESSION['email']);
-    $sql_pquery = "update RESERVATIONS
-                   set NbPlaces = ?, Classe = ?
-                   where NumCl = ? and NumVol = ? and Classe = ?";
+    if (strcmp($form_class_name, $form_previous_class_name) === 0) {
+        $sql_pquery = "update RESERVATIONS
+                       set NbPlaces = ?
+                       where NumCl = ? and NumVol = ? and Classe = ?";
+    } else {
+        $sql_pquery = "update RESERVATIONS
+                       set NbPlaces = ?, Classe = ?
+                       where NumCl = ? and NumVol = ? and Classe = ?";
+    }
     $connection->prepare_query($sql_pquery);
-    $connection->prepared_query_bind_param("isiss", array($form_nb_place, $form_class_name, $client_id, $form_flight_id, $form_previous_class_name));
+    if (strcmp($form_class_name, $form_previous_class_name) === 0) {
+        $connection->prepared_query_bind_param("iiss", array($form_nb_place, $client_id, $form_flight_id, $form_previous_class_name));
+    } else {
+        $connection->prepared_query_bind_param("isiss", array($form_nb_place, $form_class_name, $client_id, $form_flight_id, $form_previous_class_name));
+    }
     $connection->run_prepared_query();
     $connection->close_prepared_query();
     echo "Modifications enregistre&#769;es. <br>";