北京到成都双流机场航班查询 (北京到成都双流机场机票)

出发日期:
返回日期:
人数: 1 2 3 4 5

connect_error) {die("连接失败: " . $conn->connect_error);}// 根据表单数据查询航班if (isset($_POST['departure_date']) && isset($_POST['return_date']) && isset($_POST['num_passengers'])) {$departure_date = $_POST['departure_date'];$return_date = $_POST['return_date'];$num_passengers = $_POST['num_passengers'];$sql = "SELECT FROM flights WHERE departure_airport = '北京' AND arrival_airport = '成都双流机场' AND departure_date = '$departure_date' AND return_date= '$return_date' AND num_passengers = '$num_passengers'";$result = $conn->query($sql);if ($result->num_rows > 0) {echo "";echo "";while($row = $result->fetch_assoc()) {echo "";}echo "

航班号	出发机场	到达机场	出发日期	返回日期	人数	价格
" . $row["flight_number"] . "	" . $row["departure_airport"] . "	" . $row["arrival_airport"] . "	" . $row["departure_date"] . "	" . $row["return_date"] . "	" . $row["num_passengers"] . "	" . $row["price"] . "

";} else {echo "没有找到航班。";}}$conn->close();?>