+ foreach ($flights as $flight) {
+ $sql_pquery = "select sum(NbPlaces) as BookedPlaces from RESERVATIONS where NumVol = ?";
+ $connection->prepare_query($sql_pquery);
+ $connection->prepared_query_bind_param("s", array($flight['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($flight['CapAv']) && isset($booked_places)) {
+ $free_places = $flight['CapAv'] - $booked_places;
+ } else {
+ $free_places = "Inconnu";
+ }