长沙汽车官网 (长沙东站汽车订票官网)

查询结果

0) {foreach ($results as $result) {echo "
• {$result['发车时间']} | {$result['票价']}元 | {$result['剩余票数']}张
";}} else {echo "
• 没有符合查询条件的车票
";}}// 查询车票函数function getTickets($departure, $destination, $date, $time, $passengers) {// 连接数据库$conn = new mysqli('localhost', 'root', '', 'bus');// 准备查询语句$stmt = $conn->prepare('SELECT FROM tickets WHERE departure = ? AND destination = ? AND date = ? AND time = ? AND passengers >= ?');// 绑定参数$stmt->bind_param('sssss', $departure, $destination, $date, $time, $passengers);// 执行查询$stmt->execute();// 获取查询结果$result = $stmt->get_result();// 关闭连接$conn->close();// 返回查询结果return $result->fetch_all(MYSQLI_ASSOC);}?>