/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

0 vote116 views1 answer
Laravel nova card duplicate keys
PHP Laravel
1 vote106 views1 answer
Php has constant
PHP
0 vote106 views1 answer
Url decode function in php
PHP
0 vote98 views1 answer
Get 1 data from get laravel
PHP
0 vote104 views1 answer
Remove symbolsand spaces php
PHP
0 vote90 views1 answer
Evaluate home tilde ~ in php
PHP
0 vote91 views2 answers
Php loop backwards through array
PHP
0 vote60 views2 answers
Laravel collection->each
PHP
0 vote95 views1 answer
Php rsort retain keys
PHP
0 vote98 views1 answer
Php array_map passing parameters
PHP