1000) {$radius = 1000;}// 连接数据库$conn = mysqli_connect("localhost", "root", "password", "hotel_db");// 准备 SQL 语句$sql = "select FROM hotels WHERE (latitude - ?) (latitude - ?) + (longitude - ?) (longitude - ?) <= ?";$stmt = mysqli_prepare($conn, $sql);// 绑定参数mysqli_stmt_bind_param($stmt, "dddd", $latitude, $latitude, $longitude, $longitude, $radius 2);// 执行查询mysqli_stmt_execute($stmt);// 获取结果$result = mysqli_stmt_get_result($stmt);// 输出结果if (mysqli_num_rows($result) > 0) {
echo "";echo "";while ($row = mysqli_fetch_assoc($result)) {$distance = sqrt(($latitude - $row["latitude"]) 2 + ($longitude - $row["longitude"]) 2) 1000;echo "";}echo "
";} else {echo "没有找到附近的酒店";}// 释放结果集和语句mysqli_stmt_close($stmt);// 关闭数据库连接mysqli_close($conn);?>
郑重声明:本文由:
成都旅游于(2024-10-18)发表了关于
附近酒店查询 (附近酒店查询500米内)的文章。如转载请注明出处!部分文章来源于网络,仅作为参考,如果网站中图片和文字侵犯了您的版权,请联系我们处理!