附近医院离我位置最近 (离我附近最近医院)

results[0]->geometry->location->lat;$lng = $json->results[0]->geometry->location->lng;// 准备 SQL 查询$query = "SELECT FROM hospitals WHERE (latitude BETWEEN " . ($lat - $radius) . " AND " . ($lat + $radius) . ") AND (longitude BETWEEN " . ($lng - $radius) . " AND " . ($lng + $radius) . ") ORDER BY distance ASC";// 连接数据库$mysqli = new mysqli("localhost", "root", "password", "hospital_db");// 执行查询$result = $mysqli->query($query);// 检查是否有结果if ($result->num_rows > 0) {echo " ";} else {echo " ";}// 关闭数据库连接$mysqli->close();}?>