/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

16 votes200 views4 answers
Wherenotnull laravel
PHP Laravel
0 vote211 views1 answer
Validate user password laravel8
PHP Laravel
0 vote191 views1 answer
Laravel project in css
PHP Laravel
3 votes197 views1 answer
Laravel get route in unauthenticated
PHP Laravel
14 votes186 views6 answers
Transaction in laravel
PHP Laravel
0 vote222 views1 answer
Change request value laravel
PHP Laravel
18 votes199 views6 answers
Laravel model
PHP Laravel
0 vote226 views1 answer
Laravel\Socialite\Two\InvalidStateException
PHP Laravel
23 votes191 views6 answers
Laravel model insert
PHP Laravel
7 votes252 views5 answers
Search laravel
PHP Laravel