/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 vote248 views1 answer
How to execute “php artisan migrate” and other Laravel commands in remote server?
PHP Laravel
1 vote220 views1 answer
Laravel validate enum field
PHP Laravel
1 vote225 views1 answer
How convert the date and time to integer in laravel
PHP Laravel
0 vote250 views1 answer
Laravel belongstomany prevent duplicates attach
PHP Laravel
0 vote245 views1 answer
Debugbar:clear in laravel
PHP Laravel
1 vote230 views2 answers
Get unique values in laravel
PHP Laravel
0 vote219 views1 answer
Laravel unique funcation
PHP Laravel
0 vote247 views2 answers
Global variable in laravel controller
PHP Laravel
0 vote238 views1 answer
How show livewire component in laravel
PHP Laravel
11 votes229 views3 answers
Laravel auth 6
PHP Laravel