查询结果
connect_error) {die("数据库连接失败: " . $conn->connect_error);}// 准备 SQL 查询$sql = "select FROM `宾馆`WHERE `经度` BETWEEN ? AND ?AND `纬度` BETWEEN ? AND ?AND `价格` <= ?ORDER BY `价格` ASC";// 计算查询范围$minLon = $_GET['lon'] - $radius / 111111;$maxLon = $_GET['lon'] + $radius / 111111;$minLat = $_GET['lat'] - $radius / (111111 cos($_GET['lon'] M_PI / 180));$maxLat = $_GET['lat'] + $radius / (111111 cos($_GET['lon'] M_PI / 180));// 绑定参数$stmt = $conn->prepare($sql);$stmt->bind_param('dddd', $minLon, $maxLon, $minLat, $maxLat, $price);// 执行查询$stmt->execute();$result = $stmt->get_result();// 输出查询结果echo "
";while ($row = $result->fetch_assoc()) {echo "
-
" . $row['名称'] . " - " . $row['价格'] . "元 - " . $row['地址'] . "
";}echo "
";// 关闭连接$stmt->close();$conn->close();
?>
本文由:成都民宿于(2024-11-06)发表了关于
附近宾馆查询500米内哪里有 (附近宾馆查询500米内100元左右)的文章
。如转载请注明出处:http://www.cdcy-mail.com
如果您对此感兴趣,可以通过以下联系方式与我们联系:
成都区销售
重庆区销售
云贵区销售
华南区销售
华北区销售
华东区销售
华为企业邮箱销售热线:400-0828-083