/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

2 votes122 views2 answers
Laravel abort with message
PHP Laravel
4 votes115 views2 answers
Laravel sum column values
PHP Laravel
0 vote128 views2 answers
How to use flash message in laravel
PHP Laravel
16 votes74 views2 answers
How to save information on pdf file in laravel project
PHP Laravel
3 votes197 views2 answers
Using laravel back function on blade
PHP Laravel
0 vote105 views2 answers
Laravel PackageManifest.php: Undefined index: name
PHP Laravel
0 vote166 views1 answer
Laravel collection min
PHP Laravel
1 vote114 views1 answer
Laravel redirect external url
PHP Laravel
0 vote119 views1 answer
Url() inside laravel config files
PHP Laravel
1 vote126 views1 answer
How to add properties to the request object in laravel
PHP Laravel