/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

4 votes111 views1 answer
Laravel schedule command every 8 hours laravel
PHP Laravel
1 vote153 views2 answers
Set nav link active on the basis of route laravel
PHP Laravel
0 vote200 views1 answer
Laravel simple
PHP Laravel
3 votes151 views2 answers
How get the size of image in laravel
PHP Laravel
4 votes154 views4 answers
Laravel update query builder
PHP Laravel
0 vote169 views2 answers
Unique sql queries laravel
PHP Laravel
3 votes165 views4 answers
Input if not null laravel
PHP Laravel
0 vote163 views1 answer
Laravel get all vendor files
PHP Laravel
5 votes170 views2 answers
Laravel 8 routes namespace
PHP Laravel
1 vote162 views1 answer
Laravel get first letter of each word
PHP Laravel