X-Git-Url: https://git.piment-noir.org/?a=blobdiff_plain;f=includes%2Fformbooking.php;fp=includes%2Fformbooking.php;h=373e18bfbbe1fa1520ee9ba8a25489ae255bbd19;hb=33eb6f2ab954597a257e9eb8f793a9bc52dd9524;hp=0000000000000000000000000000000000000000;hpb=d5622f71ef49ac2313f5b98385bab231a9d64692;p=Project_webapp.git
diff --git a/includes/formbooking.php b/includes/formbooking.php
new file mode 100644
index 0000000..373e18b
--- /dev/null
+++ b/includes/formbooking.php
@@ -0,0 +1,68 @@
+";
+ $input_failure = true;
+}
+
+if (!$form_nb_place) {
+ echo "Nombre de place(s) invalide.
";
+ $input_failure = true;
+}
+
+if (!$form_return_flight) {
+ echo "Vol retour invalide.
";
+ $input_failure = true;
+}
+
+if (!$input_failure && !empty($form_nb_place) && !empty($form_class_name)) {
+ global $connection;
+ $client_id = get_client_id($_SESSION['email']);
+ $nb_booked = nb_booked($client_id, $form_flight_id);
+ if (!empty($nb_booked)) {
+ echo "Vous avez déjà réservé ce vol, vous allez être redirigé vers la liste de vos réservations dans 2 secondes.
";
+ redirect("index.php?page=reservations", 2);
+ }
+ $sql_pquery = "insert into RESERVATIONS (NumCl, NumVol, Classe, NbPlaces)
+ values (?, ?, ?, ?)";
+ $connection->prepare_query($sql_pquery);
+ $connection->prepared_query_bind_param("issi", array($client_id, $form_flight_id, $form_class_name, $form_nb_place));
+ $connection->run_prepared_query();
+ $connection->close_prepared_query();
+ $sql_pquery = "select VilleD, DateD, VilleA, DateA from VOLS, DEFCLASSES
+ where DEFCLASSES.NumVol = VOLS.NumVol and
+ VOLS.NumVol = ? and Classe = ?";
+ $connection->prepare_query($sql_pquery);
+ $connection->prepared_query_bind_param("ss", array($form_flight_id, $form_class_name));
+ $connection->run_prepared_query();
+ $connection->get_pquery_result();
+ $rows = $connection->get_result_array();
+ $connection->close_prepared_query();
+ foreach ($rows as $row) {
+ echo "Vous avez réservé et payé " . $form_nb_place . " place(s) sur le vol " .$form_flight_id .
+ " au départ de " . $row['VilleD']. " à " . $row['DateD'] . " arrivant à " . $row['VilleA'] . " à " . $row['DateA'] .
+ " pour un montant de " . $form_place_price * $form_nb_place . "€.
";
+ }
+ if ($form_return_flight) {
+ redirect("index.php?page=search", 3);
+ $_SESSION['current_flight_id'] = $form_flight_id;
+ $_SESSION['return_flight'] = $form_return_flight;
+ } else {
+ redirect("index.php?page=reservations", 3);
+ }
+}
+
+?>