1. 1
2. 2
3. 3
4. 4
5. 5
6. 6
7. 7
8. 8
9. 9
10. 10
11. 11
12. 12
13. 13
14. 14
15. 15
16. 16
17. 17
18. 18
19. 19
20. 20
21. 21
22. 22
23. 23
24. 24
25. 25
26. 26
27. 27
28. 28
29. 29
30. 30
31. 31
32. 32
33. 33
34. 34
35. 35
36. 36
37. 37
38. 38
39. 39
40. 40
41. 41
42. 42
43. 43
44. 44
45. 45
46. 46
47. 47
48. 48
49. 49
50. 50
51. 51
52. 52
53. 53
54. 54
55. 55
56. 56
57. 57
58. 58
59. 59
60. 60
61. 61
62. 62
63. 63
64. 64
65. 65
66. 66
67. 67
68. 68
69. 69
70. 70
71. 71
72. 72
73. 73
74. 74
75. 75
76. 76
77. 77
78. 78
79. 79
80. 80
81. 81
82. 82
83. 83
84. 84
85. 85
86. 86
87. 87
88. 88
89. 89
90. 90
91. 91

$searchCondition1 = ''; 
 $searchCondition2 = ''; 
 $searchCondition3 = ''; 
 $flag = false; 
 $sql = 'SELECT f.flight_id,
               (SELECT city
                FROM airports
                WHERE airport_id = f.from) as _from,
               (SELECT city
                FROM airports
                WHERE airport_id = f.to) as _to,
                f.flight_date as fdate,
                f.flight_time,
                f.distance,
                p.plain_name as plain
        FROM flight f JOIN planes p
            ON f.plain_id = p.plain_id
        WHERE '; 
 $fields = 0; 
 if($_POST['txtSearch']){ 
     if($_POST['txtFrom'] != ''){ 
         $searchCondition1 = " city = '".$_POST['txtFrom']."'"; 
         $flag = true; // set flag to TRUE
         $fields++; 
     }
     if($_POST['txtTo'] != ''){ // if To field is not empty
         $searchCondition2 = " city = '".$_POST['txtTo']."'"; 
         $flag = true;  // set flag to TRUE
         $fields++; 
     }
     if ($_POST['txtDate'] != ''){ // if Date field is not empty
         $searchCondition3 = " DATE(f.flight_date) = '".$_POST['txtDate']."'";
         $fields++; // and inc 
     }
     if($fields == 0){                             
         echo "<br/><div style=\"color:red\">Please, enter at least one filed to search</div>"; 
     }else{ 
         if($searchCondition1 != '' && $searchCondition2 == ''){ 
         $sql .= " f.from IN (SELECT airport_id
                                    FROM airports
                                    WHERE ".$searchCondition1.")"; 
         }
         if($searchCondition1 == '' && $searchCondition2 != ''){ 
             $sql .= " f.to IN (SELECT airport_id
                                        FROM airports
                                        WHERE ".$searchCondition2.")"; 
         }                                                              
         if($searchCondition1 != '' && $searchCondition2 != ''){ 
             $sql .= " f.from IN (SELECT airport_id
                                        FROM airports
                                        WHERE ".$searchCondition1.")
                             AND f.to IN (SELECT airport_id
                                        FROM airports
                                        WHERE ".$searchCondition2.")"; 
         }
         if($searchCondition3 != ''){ 
             if($flag){ 
                 $sql .= " AND ".$searchCondition3; 
             }else{
                 $sql .= $searchCondition3; 
             }

         }
         include_once('database.php'); 
         $db = createPDO();
         $result = $db->query($sql);
         echo '<table>
              <tr>
                <th>
                    From
                </th>
                <th>
                    To
                </th>
                <th>
                    Flight Date
                </th>
                <th>
                    Flight Time
                </th>
                <th>
                    Distance
                </th>
                <th>
                    Plane
                </th>
                <th>
                    Action
                </th>
            </tr>'; // create an HTML table with headers
         while($row = $result->fetch()){...}