/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

0 vote308 views3 answers
Method put laravel
PHP Laravel
6 votes366 views1 answer
Laravel add attribute migration column
PHP Laravel
5 votes314 views2 answers
Check session in blade laravel
PHP Laravel
13 votes344 views6 answers
Laravel api routes
PHP Laravel
1 vote289 views1 answer
Messed up pagination laravel
PHP Laravel
23 votes288 views6 answers
Updateorcreate laravel
PHP Laravel
1 vote316 views1 answer
Laravel string builder
PHP Laravel
1 vote283 views5 answers
Laravel collection methods
PHP Laravel
4 votes358 views2 answers
Validate year laravel
PHP Laravel
0 vote339 views1 answer
Iqbal Laravel save record in two table in one line
PHP Laravel