/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

18 votes215 views1 answer
Schema::default string laravel
PHP Laravel
0 vote197 views1 answer
Laravel carbon Could not parse '28/09/2021, 12:00:00 pm': DateTime::__construct(): Failed to parse time string (28/09/2021, 12:00:00 pm) at position 0 (2): Unexpected character
PHP Laravel
0 vote157 views2 answers
Recaptcha v3 laravel 8
PHP
0 vote202 views1 answer
Dump die laravel
PHP Laravel
1 vote195 views1 answer
Fix excel file wrong language php
PHP
0 vote184 views1 answer
Get am pm 12 hour timee laravel
PHP
1 vote166 views1 answer
Laravel select all except some columns
PHP
2 votes173 views1 answer
Web api return json example in php
PHP
0 vote221 views1 answer
Check if any field update laravel
PHP Laravel
3 votes228 views6 answers
Laravel jwt token
PHP