/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 vote202 views1 answer
How to wirte laravel dd function in php
PHP Laravel
0 vote207 views1 answer
Setup cron on macos for laravel
PHP Laravel
1 vote212 views2 answers
Laravel view with data in blade
PHP Laravel
2 votes178 views1 answer
Get the current route in laravel
PHP Laravel
32 votes225 views1 answer
How to count the characters in laravel
PHP Laravel
0 vote224 views1 answer
Laravel vue csrf
PHP Laravel
1 vote221 views2 answers
Laravel Cannot add foreign key constraint
PHP Laravel
0 vote154 views1 answer
Laravel collection take
PHP Laravel
3 votes222 views3 answers
Laravel carbon count days between dates
PHP Laravel
0 vote208 views2 answers
Default language laravel
PHP Laravel