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

本文主要是介绍分享一段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);