/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 votes223 views2 answers
Laravel migration update table column type
PHP Laravel
5 votes221 views6 answers
Csrf token laravel
PHP Laravel
1 vote303 views1 answer
Clear bootstrap cache laravel
PHP Laravel
9 votes277 views6 answers
Laravel 8 date format
PHP Laravel
8 votes234 views3 answers
Storage link laravel
PHP Laravel
0 vote255 views1 answer
Confiruando passaport no laravel
PHP Laravel
15 votes219 views6 answers
Laravel custom validation message
PHP Laravel
8 votes242 views5 answers
Laravel route model binding
PHP Laravel
0 vote229 views1 answer
Drop foreign key laravel eloquent
PHP Laravel
1 vote271 views4 answers
Laravel scheduler run
PHP Laravel