黄陂酒店住宿价格 (黄陂酒店住宿价格查询)

您可以使用本页面查询黄陂的酒店住宿价格。请输入您的入住日期和退房日期，然后点击 "查询" 按钮。

入住日期: 退房日期:

connect_error) {die("连接数据库失败: " . $conn->connect_error);}// Prepare the SQL statement$sql = "SELECT FROM hotel_prices WHERE check_in >= ? AND check_out <= ?";// Create a prepared statement$stmt = $conn->prepare($sql);// Bind parameters to the prepared statement$stmt->bind_param("ss", $check_in, $check_out);// Execute the prepared statement$stmt->execute();// Get the results$result = $stmt->get_result();// Check if any results were returnedif ($result->num_rows > 0) {echo "

酒店住宿价格

";echo "";echo "";echo "";echo "";echo "";echo "";echo "";echo "";echo "";echo "";echo "";// Output the resultswhile ($row = $result->fetch_assoc()) {echo "";echo "";echo "";echo "";echo "";echo "";echo "";}echo "";echo "

酒店	房型	价格	入住日期	退房日期
" . $row['hotel'] . "	" . $row['room_type'] . "	" . $row['price'] . "	" . $row['check_in'] . "	" . $row['check_out'] . "

";} else {echo "

没有符合您搜索条件的酒店住宿。

";}// Close the prepared statement$stmt->close();// Close the database connection$conn->close();}?>