分享一段mysql，mongodb 实现LBS搜索的简单代码

#仅支持myisam




CREATE TABLE  address (

 

     address CHAR (80) NOT NULL ,

 

     address_loc POINT  NOT NULL ,

 

     PRIMARY KEY (address)

 

);

ALTER TABLE  address  ADD SPATIAL  INDEX (address_loc);

INSERT INTO  address  VALUES ( 'Foobar street 12' , GeomFromText( 'POINT(30.620076 104.067221)' ));

 

INSERT INTO  address  VALUES ( 'Foobar street 13' , GeomFromText( 'POINT(31.720076 105.167221)' ));

查询10公里内的

SELECT  *

     FROM    address

     WHERE   MBRContains

                     (

                     LineString

                             (

                             Point

                                     (

                                     30.620076 + 10 / ( 111.1 / COS(RADIANS(104.067221))),

                                     104.067221 + 10 / 111.1

                                     ),

                             Point

                                     (

                                     30.620076 - 10 / ( 111.1 / COS(RADIANS(104.067221))),

                                     104.067221 - 10 / 111.1

                                     )

                             ),

                     address_loc

<?php
$m = new MongoClient();
$d = $m->user;
$r = $d->command(array(
    'geoNear' => "user",       // 在 poiConcat 集合中
    'near' => array(104.065847, 30.657554), // 经纬度附近
    'spherical' => true,              // 启用特殊搜索 弧度
    'maxDistance' => 1.5/6371,              // 搜索区域
    'distanceMultiplier' => 6371,           // 返回公里数，自动转换
    'num' => 5,                             // 最多返回5个文档
));
print_r($r);

                     )

MongoDb



1、先建立一张简单的集合user,两条数据如下：

{

   "_id" : ObjectId( "518b1f1a83ba88ca60000001" ),

   "account" : "simplephp1@163.com" ,

   "gps" : [

     104.067221,

     30.620076

   ]

}

 

{

   "_id" : ObjectId( "518b1dae83ba88d660000000" ),

   "account" : "simplephp6@163.com" ,

   "gps" : [

     104.07958,

     30.653936

   ]

db. user .ensureIndex({ "gps" : "2d" },{ "min" :-180, "max" :180})

#查询5公里内的，只返回常规数据

db. user .find({ gps :{ $near : [104.065847, 30.657554] , $maxDistance : 5/111.12} })

#查询5公里内的，且返回距离

db.runCommand({ geoNear : "user", near : [104.065847, 30.657554], spherical : true, maxDistance : 5/6371, distanceMultiplier: 6371})

#php实现