搜索结果

prepare($sql);$stmt->bind_param("ddddd", $location, $location, $location, $location, $radius $radius);// 执行查询$stmt->execute();$result = $stmt->get_result();// 遍历结果while ($row = $result->fetch_assoc()) {// 计算距离$distance = number_format(sqrt(($location - $row['latitude']) ($location - $row['latitude']) + ($location - $row['longitude']) ($location - $row['longitude'])), 2, '.', '');// 输出结果echo "
• {$row['name']}, 距离：{$distance} 公里
";}// 关闭连接$conn->close();?>