简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Backend Development > PHP Tutorial > body text

php people nearby

WBOY
Release： 2016-07-25 08:47:33
Original
1047 people have browsed it
根据经纬度查找附近的人
                   
                               
                                       
                                       
            
  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. }
复制代码


Related labels：
php 附近的人
source：php.cn
Previous article：Single-file version of online code editor aceditor Next article：PHP+jQuery+POST collection web page example
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Composer update gives error phpunit/phpunit I recently installed php (8.1.7) and composer (2.3.7) with laravel9; now I am getting this...
From 2023-11-08 15:34:22
0
1
309
Why do so many JavaScript scripts append random numbers to things? collision? I've been learning JavaScript lately and have seen many examples of using Math.rand() to a...
From 2023-11-04 20:00:04
0
2
296
PHP Email Sending Tutorial: How to send email with attachments using PHP? I am using the following code to send an email with an attachment, but the correct file is...
From 2023-10-25 17:44:05
0
1
284
The rephrased title is: MySQL table name using double quotes I'm executing a mysql query like this: Select*from "User"; it returns: There is ...
From 2023-10-24 22:39:00
0
1
301
Rejections are not propagated in chained promises I can't understand why the rejection isn't passed through the promise chain and I'm hoping...
From 2023-10-23 17:50:47
0
2
257
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！