/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 vote170 views1 answer
Diffforhumans laravel
PHP Laravel
13 votes164 views6 answers
Find auth laravel
PHP Laravel
8 votes162 views2 answers
Laravel drop multiple columns
PHP Laravel
1 vote148 views3 answers
Convert date to timestamp in laravel builder
PHP Laravel
1 vote147 views1 answer
Laravel read file from tmp
PHP Laravel
0 vote133 views1 answer
What is Trustproxies handle in laravel
PHP Laravel
5 votes159 views1 answer
Laravel get random row
PHP Laravel
5 votes157 views5 answers
Unique laravel migration
PHP Laravel
8 votes159 views1 answer
Laravel command to create symlink storage
PHP Laravel
0 vote149 views1 answer
SoapClient Laravel 8
PHP Laravel