X-Git-Url: https://git.piment-noir.org/?a=blobdiff_plain;f=includes%2Fsearch.php;h=c7e761f5104eea28ab5d096f149fc48222ea0559;hb=0a87f4538a04b4dba4888a6abdb166ba8f465ba4;hp=03a956079e021cac06febe8b22112186155dba38;hpb=01135b89a6848059df608e8c23e8684233772b4f;p=Project_webapp.git

diff --git a/includes/search.php b/includes/search.php
index 03a9560..c7e761f 100644
--- a/includes/search.php
+++ b/includes/search.php
@@ -4,15 +4,45 @@
 
 <form action="index.php" id="search" method="post">
  <input type="hidden" name="form" value="search" />
- <input type="hidden" name="date_now" value="<?php echo date('Y-m-d\TH:i'); ?>" />
+ <input type="hidden" name="date_now" value="<?php echo date('Y-m-d\TH:i', time() - 600); ?>" />
  <label> De&#769;part : Ville -> </label>
- <input type="text" size="15" name="departure_city" required/>
+ <select size="1" name="departure_city" required>
+  <optgroup label="Se&#769;lectionner une ville">
+ <?php
+ $sql_pquery = "select distinct VilleD from VOLS";
+ global $connection;
+ $connection->prepare_query($sql_pquery);
+ $connection->run_prepared_query();
+ $connection->get_pquery_result();
+ $cities = $connection->get_result_array();
+ $connection->close_prepared_query();
+ foreach ($cities as $city) {
+     echo "<option value=\"$city[0]\">$city[0]</option>\n";
+ }
+ ?>
+  </optgroup>
+ </select>
  <label> Date -> </label>
  <input type="datetime-local" name="departure_date" value="<?php echo date('Y-m-d\TH:i'); ?>" required/>
  <label> Arrive&#769;e : Ville -> </label>
- <input type="text" size="15" name="arrival_city" required/>
+ <select size="1" name="arrival_city" required>
+  <optgroup label="Se&#769;lectionner une ville">
+ <?php
+ $sql_pquery = "select distinct VilleA from VOLS";
+ global $connection;
+ $connection->prepare_query($sql_pquery);
+ $connection->run_prepared_query();
+ $connection->get_pquery_result();
+ $cities = $connection->get_result_array();
+ $connection->close_prepared_query();
+ foreach ($cities as $city) {
+     echo "<option value=\"$city[0]\">$city[0]</option>\n";
+ }
+ ?>
+  </optgroup>
+ </select>
  <label> Date -> </label>
- <input type="datetime-local" name="arrival_date" value="<?php echo date('Y-m-d\TH:i', time() + 86400); ?>" required/>
- <input type="submit" value="Valider">
+ <input type="datetime-local" name="arrival_date" />
+ <input type="submit" value="Rechercher">
 </form>
 <br>