Skip to content
  • P
    Projects
  • G
    Groups
  • S
    Snippets
  • Help

ruzalo / airline-booking

  • This project
    • Loading...
  • Sign in
Go to a project
  • Project
  • Repository
  • Issues 0
  • Merge Requests 0
  • Pipelines
  • Wiki
  • Snippets
  • Members
  • Activity
  • Graph
  • Charts
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
  • Files
  • Commits
  • Branches
  • Tags
  • Contributors
  • Graph
  • Compare
  • Charts
Switch branch/tag
  • airline-booking
  • php_files
  • booking_page_database.php
Find file
BlameHistoryPermalink
  • Ryo's avatar
    Uploaded php_files folder · 71111947
    Ryo committed 5 years ago
    71111947
booking_page_database.php 2.63 KB
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84
<?php
//This is only displayed if the user submitted the form
if (isset($_POST['flight_search'])){
  echo "<h2>Results</h2><p>";

  //If the user did not enter a search term, they receive an error
  if ($_POST['departure'] and $_POST['arrival']== ""){
    echo "<p>Please enter a search term";
    exit;
  }

  // Otherwise we connect to the database
  $con = mysqli_connect("anysql.itcollege.ee", "WT16", "iLtQlUerkT", "WT16");

  // Check connection
  if (mysqli_connect_errno()){
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

  if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $departure = ($_POST["departure"]);
    $arrival = ($_POST["arrival"]);
    $date_going = ($_POST["trip_going"]);
    $date_back = ($_POST["trip_back"]);
  }

  //echo "$departure";
  //echo "$arrival";

  //Now we search for our search term, in the field the user specified
  //if Morning_AfterNoon_Night = Morning
  //$data = mysqli_query($con, "SELECT * FROM FlightData WHERE departure = '$departure' AND arrival = '$arrival'");
  $int = 0;
  foreach ($_POST['check_list'] as $select){
    if ($int > 0){
      $filter = $filter . " or Morning_AfterNoon_Night ='" . $select . "'" ;
    }
    else {
      $filter = " and Morning_AfterNoon_Night ='" . $select . "'" ;
    }
    $int = $int + 1;
  }

  //$a = $a . ")";

  if(isset($_POST['radio'])){
    echo "You have selected :".$_POST['radio'];
  }
  if ($_POST['radio'] === 'htolcost'){
    $order = " ORDER BY Price DESC" ;
  }
  else {
    $order = " ORDER BY Price" ;
  }

  //echo "SELECT * FROM FlightData WHERE departure = '$departure' AND arrival = '$arrival' " . "$a";
  //$data = mysqli_query($con, "SELECT * FROM FlightData WHERE departure = '$departure' AND arrival = '$arrival'");

  $data = mysqli_query($con, "SELECT * FROM FlightData WHERE departure = '$departure' AND arrival = '$arrival' " . "$filter" . "$order");
  //And display the results

  while($row = mysqli_fetch_array( $data )){
    echo "$row[1]". " " ."$row[2]". " " . "$row[3]". " " . "$row[4]". " " . "$row[5]". " " . "$row[6]". " " . "$row[7]". " " . "$row[8]". " " . "$row[9]" . " " . "$date_going". " " . "$date_back". " " ."<a href='loginform2.php?Flight_Id=$row[0]' >". "SELECT" ."</a>";
    echo "<br>";
  }

  //This counts the number or results. If there aren't any, it gives the user a "no match" message
  $anymatches=mysqli_num_rows($data);
  if ($anymatches == 0){
    echo "Sorry, but we can not find an entry to match your query<br><br>";
  }

  //And reminds the user what they searched for
  echo "<b>Searched For:</b> " . "$find";
}

//break;

if (isset($_GET['Flight_Id#'])) {
  $Flight_Id = $_GET['Flight_Id'];
  echo $Flight_Id;
}

?>