成都市如家快捷酒店价格 (成都市如家快捷酒店)

connect_error) {die("连接失败: " . $conn->connect_error);}//获取查询参数$keyword = isset($_GET['keyword']) ? $_GET['keyword'] : '';$dateFrom = isset($_GET['date-from']) ? $_GET['date-from'] : '';$dateTo = isset($_GET['date-to']) ? $_GET['date-to'] : '';//构建查询语句$sql = "ｓｅｌｅｃｔ FROM hotel WHERE city='成都' AND brand='如家'";if ($keyword) {$sql .= " AND name LIKE '%$keyword%'";}if ($dateFrom) {$sql .= " AND date_from >= '$dateFrom'";}if ($dateTo) {$sql .= " AND date_to <= '$dateTo'";}//执行查询$result = $conn->query($sql);//输出查询结果if ($result->num_rows > 0) {while($row = $result->fetch_assoc()) {echo " ";}} else {echo "

没有符合条件的酒店

";}//关闭数据库连接 $conn->close();?>