/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 vote283 views1 answer
Laravel fixed character limit
PHP Laravel
42 votes254 views6 answers
Laravel cache remember
PHP Laravel
6 votes201 views3 answers
Laravel ide helper
PHP Laravel
1 vote161 views1 answer
While loop in laravel
PHP Laravel
6 votes199 views2 answers
Findorfail laravel
PHP Laravel
0 vote160 views1 answer
Model find by certain column laravel
PHP Laravel
0 vote190 views1 answer
Confiruando passaport no laravel
PHP Laravel
-1 vote173 views1 answer
Laravel remove index.php from url
PHP Laravel
0 vote232 views1 answer
How to set db table type in laravel
PHP Laravel
1 vote145 views1 answer
Trim laravel
PHP Laravel