/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

15 votes150 views6 answers
Laravel db transaction
PHP Laravel
1 vote159 views1 answer
Laravel password verification
PHP Laravel
2 votes159 views3 answers
Laravel where created_at today
PHP Laravel
0 vote149 views1 answer
Foreign key cosntraint laravel
PHP Laravel
0 vote148 views1 answer
If session is empty laravel
PHP Laravel
0 vote152 views2 answers
Laravel allow all fillable
PHP Laravel
0 vote143 views1 answer
Migration not found laravel
PHP Laravel
8 votes167 views5 answers
Laravel route model binding
PHP Laravel
3 votes168 views5 answers
Laravel set env to production
PHP Laravel
0 vote156 views1 answer
How to redirect to another page from laravel blade
PHP Laravel