/PHP/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 vote365 views1 answer
Laravel date rule before 18 years ago
PHP Laravel
2 votes311 views3 answers
Where is in array laravel
PHP
1 vote318 views2 answers
Class 'App\Http\Controllers\Session' not found
PHP
3 votes322 views1 answer
How to use where relationship laravel
PHP
0 vote352 views1 answer
Codeigniter echo set content type
PHP CodeIgniter
0 vote305 views2 answers
Wordpress post revisions config
PHP
3 votes290 views1 answer
How to named route resource laravel
PHP
2 votes355 views2 answers
How to use stored procedure in laravel
PHP Laravel
0 vote323 views1 answer
Laravel collection reverse
PHP
0 vote307 views1 answer
Undefined type excel
PHP