X-Git-Url: https://git.piment-noir.org/?p=Project_webapp.git;a=blobdiff_plain;f=lib%2Futils.php;h=5ab99b599fa7301b864bec195c1c717917f3efa7;hp=9955458cffd1c7b8420082dec60dd75c1ceb7496;hb=22f1dc6402dbc9a9c5d2ed2f17ef54044d35ec2a;hpb=0a87f4538a04b4dba4888a6abdb166ba8f465ba4

diff --git a/lib/utils.php b/lib/utils.php
index 9955458..5ab99b5 100644
--- a/lib/utils.php
+++ b/lib/utils.php
@@ -95,12 +95,12 @@ function get_client_id($email)
  * @param  [type] $flight_id [description]
  * @return [type]            [description]
  */
-function nb_booked($client_id, $flight_id)
+function nb_booked($client_id, $flight_id, $class_name)
 {
     global $connection;
-    $sql_pquery = "select SUM(NbPlaces) from RESERVATIONS where NumCl = ? and NumVol = ?";
+    $sql_pquery = "select SUM(NbPlaces) from RESERVATIONS where NumCl = ? and NumVol = ? and Classe = ?";
     $connection->prepare_query($sql_pquery);
-    $connection->prepared_query_bind_param("is", array($client_id, $flight_id));
+    $connection->prepared_query_bind_param("iss", array($client_id, $flight_id, $class_name));
     $connection->run_prepared_query();
     $connection->get_pquery_result();
     $row = $connection->get_result_array();