/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

12 votes301 views2 answers
Php array get value at index
PHP
0 vote342 views1 answer
How to take last entry in database in laravel Method Three
PHP
-2 votes319 views1 answer
Laravel model bind with route in model
PHP
46 votes404 views6 answers
Add new column in existing table in laravel migration
PHP Laravel
0 vote315 views1 answer
Laravel get biggest id
PHP
8 votes296 views3 answers
Connect php to db
PHP
1 vote377 views1 answer
Phpstorm serial key 2020.2.3
PHP
0 vote359 views1 answer
How to exclude csrf in a route laravel
PHP Laravel
0 vote319 views1 answer
Laravel parse markdown
PHP Laravel
0 vote368 views1 answer
Laravel pass multipale provider
PHP