/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

3 votes112 views3 answers
Html special characters php
PHP
0 vote129 views1 answer
Laravel group concat values showing duplicate
PHP
1 vote144 views2 answers
Page expire in laravel
PHP Laravel
0 vote111 views1 answer
Phpspreadsheet set cell by column and row
PHP
1 vote120 views1 answer
$_server 'remote_addr' not working properly
PHP
0 vote125 views1 answer
Set Countries To Appear At The Top Of The Caldera Forms Phone Field List
PHP
0 vote126 views1 answer
Order by in datatable laravel
PHP Laravel
0 vote117 views1 answer
Laravel collection has
PHP
1 vote139 views2 answers
Cart::subtotal in laravel
PHP Laravel
0 vote107 views1 answer
Adding n days to a DATETIME format value
PHP