X-Git-Url: https://git.piment-noir.org/?a=blobdiff_plain;f=includes%2Freservations.php;h=9458dc77e98f76eb96f245db05d8c950aa701584;hb=HEAD;hp=0416bd5af660a159d5777a2029ebf2723021282a;hpb=c49f721926f5d76a8eef80bd5174d68b5a151442;p=Project_webapp.git
diff --git a/includes/reservations.php b/includes/reservations.php
index 0416bd5..9458dc7 100644
--- a/includes/reservations.php
+++ b/includes/reservations.php
@@ -17,16 +17,16 @@ $oDateNow = new Datetime($date_now);
global $connection;
$sql_pquery = "select RESERVATIONS.NumVol as NumVol, VilleD, DateD, VilleA, DateA, RESERVATIONS.Classe, NbPlaces, round(CoutVol*CoeffPrix*NbPlaces, 2) as Prix
from RESERVATIONS join VOLS on RESERVATIONS.NumVol = VOLS.NumVol
- join DEFCLASSES on DEFCLASSES.NumVol = VOLS.NumVol and RESERVATIONS.Classe = DEFCLASSES.Classe
+ join DEFCLASSES on DEFCLASSES.NumVol = RESERVATIONS.NumVol and DEFCLASSES.NumVol = VOLS.NumVol and DEFCLASSES.Classe = RESERVATIONS.Classe
where NumCl = ? and DateD > ?
order by DateD, NumVol, Prix";
$connection->prepare_query($sql_pquery);
$connection->prepared_query_bind_param("is", array($client_id, $date_now));
$connection->run_prepared_query();
$connection->get_pquery_result();
-$rows = $connection->get_result_array();
+$reservations = $connection->get_result_array();
$connection->close_prepared_query();
-if (empty($rows)) {
+if (empty($reservations)) {
echo "Aucune(s) réservation(s) en cours pour le moment.
";
} else {
echo "
Prix | \n"; echo "Actions | \n"; echo " \n"; - foreach ($rows as $row) { - $oDepartureDate = new DateTime($row['DateD']); + foreach ($reservations as $reservation) { + $oDepartureDate = new DateTime($reservation['DateD']); echo "|||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
" . $row['NumVol'] . " | \n"; - echo "" . $row['VilleD'] . " | \n"; - echo "" . $row['DateD'] . " | \n"; - echo "" . $row['VilleA'] . " | \n"; - echo "" . $row['DateA'] . " | \n"; - echo "" . $row['Classe'] . " | \n"; - echo "" . $row['NbPlaces'] . " | \n"; - echo "" . $row['Prix'] . "€ | \n"; + echo "" . $reservation['NumVol'] . " | \n"; + echo "" . $reservation['VilleD'] . " | \n"; + echo "" . $reservation['DateD'] . " | \n"; + echo "" . $reservation['VilleA'] . " | \n"; + echo "" . $reservation['DateA'] . " | \n"; + echo "" . $reservation['Classe'] . " | \n"; + echo "" . $reservation['NbPlaces'] . " | \n"; + echo "" . $reservation['Prix'] . "€ | \n"; if ($oDepartureDate > $oDateNow) { echo "\n"; |