/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

14 votes314 views2 answers
Laravel database select
PHP Laravel
0 vote377 views1 answer
Laravel cron job on shared hosting
PHP Laravel
0 vote323 views1 answer
Menyimpan get di laravel
PHP Laravel
8 votes370 views1 answer
Add sucssess message laravel
PHP Laravel
0 vote317 views2 answers
Laravel santum
PHP Laravel
3 votes321 views3 answers
Pluck array in laravel
PHP Laravel
0 vote352 views1 answer
Redirect 404 in laravel
PHP Laravel
3 votes344 views1 answer
Laravel validate max file size
PHP Laravel
0 vote325 views1 answer
Beanstalk run laravel command
PHP Laravel
1 vote331 views2 answers
Laravel view with data in blade
PHP Laravel