问在谷歌地图上查询MySQL中的位置数据

EN

select latitude, longitude from users where latitude between (user.latitude + whateverrangeyouwant and user.latitude - whateverrangeyouwant) AND longitude between (user.longitude + whateverrangeyouwant AND user.longitude - whateverrangeyouwant);

 $minLat = $_REQUEST['lat'] - ($_REQUEST['dl'] / 2);
 $maxLat = $_REQUEST['lat'] + ($_REQUEST['dl'] / 2);
 $minLon = $_REQUEST['lon'] - $_REQUEST['dln'];
 $maxLon = $_REQUEST['lon'] + $_REQUEST['dln'];

 $query = 'SELECT  locations.latitude,
                   locations.longitude
           FROM locations
           WHERE (latitude BETWEEN ' . $minLat . '  AND  ' .  $maxLat . ') AND
                 (longitude BETWEEN ' . $minLon . ' AND ' . $maxLon. ')';

    }

    $query = DB::query($query);

    $json = array();

    while($location = $query->fetch_assoc()) {
        $json[] = $location;
    }

    header('Content-Type: application/json');
    echo json_encode($json);
    exit();