南京到上海火车票价 (南京到上海火车时刻表查询)

此页面提供南京到上海火车的票价和时刻表查询服务。

票价查询

出行日期：

时刻表查询

出发时间：

结果

query($sql);// 获取查询结果$prices = $result->fetch_all(MYSQLI_ASSOC);// 关闭数据库连接$mysqli->close();// 输出结果echo "

南京到上海火车票价

";echo "";echo "";foreach ($prices as $price) {echo "";echo "";echo "";echo "";echo "";echo "";echo "";}echo "

车次	出发时间	抵达时间	一等座	二等座
" . $price['train_number'] . "	" . $price['departure_time'] . "	" . $price['arrival_time'] . "	" . $price['first_class_price'] . "	" . $price['second_class_price'] . "

"; } elseif (isset($_GET['departure_time'])) {// 时刻表查询$departure_time = $_GET['departure_time'];// 连接数据库$mysqli = new mysqli("localhost", "root", "password", "railway");// 准备 SQL 语句$sql = "SELECT FROM train_timetable WHERE origin = '南京' AND destination = '上海' AND departure_time = '$departure_time'";// 执行 SQL 语句$result = $mysqli->query($sql);// 获取查询结果$timetable = $result->fetch_all(MYSQLI_ASSOC);// 关闭数据库连接$mysqli->close();// 输出结果echo "

南京到上海火车时刻表

";echo "";echo "";foreach ($timetable as $train) {echo "";echo "";echo "";echo "";echo "";echo "";echo "";}echo "

车次	出发时间	抵达时间	一等座	二等座
" . $train['train_number'] . "	" . $train['departure_time'] . "	" . $train['arrival_time'] . "	" . $train['first_class_availability'] . "	" . $train['second_class_availability'] . "

"; } ?>