/PHP/Get nearby from longitude and latitude in laravel

Get nearby from longitude and latitude in laravel

\DB::table("users")
     ->select("users.id", \DB::raw("6371 * acos(cos(radians(" . $this->lat . "))
     * cos(radians(users.latitude)) 
     * cos(radians(users.longitude) - radians(" . $this->lng . ")) 
     + sin(radians(" .$this->lat. ")) 
     * sin(radians(users.latitude))) AS distance"))
     ->having('distance', '<', $this->rad)
     ->first();

Source: stackoverflow.com

Similar codes

1 vote147 views1 answer
Php needle haystack
PHP
3 votes86 views1 answer
Count array laravel
PHP Laravel
0 vote167 views1 answer
Laravelda cortollerga keladigan zaproslarni cheklash
PHP
0 vote138 views1 answer
Check if object has method php
PHP
0 vote145 views1 answer
Wordpress disable errors
PHP
0 vote231 views4 answers
Findmany laravel
PHP Laravel
0 vote124 views1 answer
N months from today php
PHP
1 vote120 views1 answer
Php timer
PHP
15 votes141 views4 answers
Php delete file
PHP
0 vote128 views1 answer
How to create and access angular HTTP params in PHP
PHP