成都巴适公交在线查询 (成都巴适公交app下载)

connect_error) {die("连接失败: " . $conn->connect_error);}// 获取公交站信息$sql = "SELECT FROM stops WHERE name LIKE '%$from%'";$result = $conn->query($sql);if ($result->num_rows > 0) {$from_id = $result->fetch_assoc()["id"];} else {die("起点不存在");}$sql = "SELECT FROM stops WHERE name LIKE '%$to%'";$result = $conn->query($sql);if ($result->num_rows > 0) {$to_id = $result->fetch_assoc()["id"];} else {die("终点不存在");}// 获取公交线路信息$sql = "SELECT FROM routes WHERE from_id = $from_id AND to_id = $to_id";$result = $conn->query($sql);if ($result->num_rows > 0) {$route_id = $result->fetch_assoc()["id"];} else {die("没有找到公交线路");}// 获取公交班次信息$sql = "SELECT FROM schedules WHERE route_id = $route_id AND date = '$date' AND time >= '$time'";$result = $conn->query($sql);if ($result->num_rows > 0) {echo "";echo "";while($row = $result->fetch_assoc()) {echo "";}echo "

班次	发车时间	到达时间
" . $row["id"] . "	" . $row["time"] . "	" . $row["arrival_time"] . "

";} else {echo "没有找到公交班次";}// 关闭连接$conn->close();?>