/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

1 vote228 views2 answers
Laravel get query output
PHP Laravel
-1 vote263 views2 answers
Laravel OrderBy on Eloquent whereHas relationship
PHP Laravel
1 vote274 views2 answers
How to validate video laravel
PHP Laravel
0 vote233 views1 answer
Laravel polymorphic relationship why we need this relation orm,
PHP Laravel
6 votes227 views4 answers
Laravel get env variable
PHP Laravel
3 votes256 views1 answer
Wherehas laravel search
PHP Laravel
40 votes238 views6 answers
Laravel drop column
PHP Laravel
2 votes255 views2 answers
In PackageManifest.php line 131: Undefined index: name laravel 7
PHP Laravel
16 votes242 views6 answers
Laravel redirect back
PHP Laravel
0 vote229 views2 answers
Laravel sortby varchar date
PHP Laravel