/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

5 votes133 views2 answers
Laravel check method is post
PHP Laravel
3 votes230 views2 answers
Two condition in one laravel query
PHP Laravel
0 vote142 views1 answer
Eager load relationships by default in the model laravel
PHP Laravel
0 vote138 views1 answer
@lang laravel blade
PHP Laravel
9 votes136 views2 answers
Laravel Str::random
PHP Laravel
2 votes155 views4 answers
Laravel hash password check
PHP Laravel
0 vote142 views1 answer
Validate file count with validate in laravel
PHP Laravel
0 vote134 views1 answer
Laravel check if postback
PHP Laravel
0 vote123 views1 answer
Laravel apache public folder
PHP Laravel
0 vote127 views1 answer
Laravel withcount change name
PHP Laravel