/PHP/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

2 votes315 views1 answer
Carbon time ago laravel
PHP Laravel
63 votes272 views6 answers
Laravel clear cache
PHP
7 votes318 views3 answers
Laravel random query
PHP Laravel
0 vote258 views1 answer
Get array key based on value php
PHP
16 votes275 views6 answers
Laravel validation array
PHP
0 vote274 views1 answer
Javascritp
PHP
22 votes267 views6 answers
Php foreach
PHP
44 votes388 views2 answers
Laravel version command
PHP Laravel
7 votes285 views2 answers
Laravel field types from database field type
PHP Laravel
19 votes301 views5 answers
Php check string
PHP