/PHP/Laravel/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 vote229 views1 answer
Laravel dompdf barcode
PHP Laravel
2 votes146 views2 answers
Check if date between two dates laravel
PHP Laravel
0 vote178 views1 answer
Laravel passport generate key
PHP Laravel
2 votes147 views2 answers
Echo query in laravel
PHP Laravel
-1 vote101 views1 answer
Laravel 7 generator
PHP Laravel
9 votes164 views5 answers
Laravel exist
PHP Laravel
0 vote146 views1 answer
Slow laravel testing
PHP Laravel
1 vote150 views1 answer
Laravel routing controller get and post method
PHP Laravel
0 vote184 views1 answer
Laravel deleted controller still cached
PHP Laravel
1 vote147 views1 answer
Laravel number add 0 before
PHP Laravel