+ foreach ($fligths as $fligth) {
+ $sql_pquery = "select sum(NbPlaces) from RESERVATIONS where NumVol = ?";
+ $connection->prepare_query($sql_pquery);
+ $connection->prepared_query_bind_param("s", array($fligth['NumVol']));
+ $connection->run_prepared_query();
+ $connection->get_pquery_result();
+ $rows = $connection->get_result_array();
+ $connection->close_prepared_query();
+ $booked_places = $rows[0][0];
+ if (is_null($booked_places)) {
+ $booked_places = 0;
+ }
+ if (isset($fligth['CapAv']) && isset($booked_places)) {
+ $free_places = $fligth['CapAv'] - $booked_places;
+ } else {
+ $free_places = "Inconnu";
+ }