地址: 半径 (米):

0) {echo '

查询结果:

';echo '

';foreach ($hotels as $hotel) {echo '
• ' . $hotel['name'] . ' (' . $hotel['distance'] . ' 米)
';}echo '

';} else {echo '没有找到匹配的酒店。';}}?>php prepare('SELECT name, ( 6371 acos( cos( radians(?) ) cos( radians( latitude ) ) cos( radians( longitude ) - radians(?) ) + sin( radians(?) ) sin( radians(latitude ) ) ) ) AS distance FROM hotels HAVING distance <= ? ORDER BY distance ASC');// 绑定参数$stmt->bind_param('ddd', $address, $address, $address, $radius);// 执行查询$stmt->execute();// 获取查询结果$result = $stmt->get_result();// 转换结果为数组$hotels = [];while ($row = $result->fetch_assoc()) {$hotels[] = $row;}// 关闭连接$stmt->close();$db->close();return $hotels; } ?>

上一篇：成都民宿在哪里订

下一篇：成都高铁东站附近的酒店