php 附近的人

根据经纬度查找附近的人

1. $uid=$_POST[uid];
2. if($uid>0)
3. {
4. $re=mysql_query("select `lat`,`long` from pre_common_member where uid='$uid'")or die(mysql_error());
5. $row=mysql_fetch_assoc($re);
6. if(!empty($row[lat]) and !empty($row[long]))
7. {
8. $re0=mysql_query("select `username`,`lat`,`long` from pre_common_member where uid!='$uid'");
9. while($row0=mysql_fetch_assoc($re0))
10. {
11. $distance = getDistanceBetweenPointsNew($row['lat'], $row['long'], $row0['lat'], $row0['long']);
12. $row0[meter]=$distance[meters];
13. $arr[]=$row0;
14. }
15. $arr=array_sort($arr,'meter');
16. $arr = array_slice($arr,0,10);
17. $data=json_encode($arr);
18. $s=mysql_errno();
19. //echo $data;
20. echo "{\"s\":$s,\"data\":$data}";
21. }
22. }
24. // 比较两个地点的距离
25. function getDistanceBetweenPointsNew($latitude1, $longitude1, $latitude2, $longitude2)
26. {
27. $theta = $longitude1 - $longitude2;
28. $miles = (sin(deg2rad($latitude1)) * sin(deg2rad($latitude2))) + (cos(deg2rad($latitude1)) * cos(deg2rad($latitude2)) * cos(deg2rad($theta)));
29. $miles = acos($miles);
30. $miles = rad2deg($miles);
31. $miles = $miles * 60 * 1.1515;
32. $feet = $miles * 5280;
33. $yards = $feet / 3;
34. $kilometers = $miles * 1.609344;
35. $meters = $kilometers * 1000;
36. return compact('miles', 'feet', 'yards', 'kilometers', 'meters');
37. }
38. // 二维数组按某个key排序
39. function array_sort($arr,$keys,$type='asc')
40. {
41. $keysvalue = $new_array = array();
42. foreach ($arr as $k=>$v){
43. $keysvalue[$k] = $v[$keys];
44. }
45. if($type == 'asc'){
46. asort($keysvalue);
47. }else{
48. arsort($keysvalue);
49. }
50. reset($keysvalue);
51. foreach ($keysvalue as $k=>$v){
52. $new_array[$k] = $arr[$k];
53. }
54. return $new_array;
55. }

复制代码