/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 vote288 views1 answer
Laravel collection pop
PHP Laravel
2 votes281 views1 answer
Laravel pivot table model
PHP Laravel
0 vote292 views2 answers
Concat in where clause laravel query builder
PHP Laravel
3 votes305 views1 answer
Validate each value from array laravel
PHP Laravel
0 vote265 views1 answer
$loop laravel list
PHP Laravel
0 vote255 views1 answer
The Laravel installer requires PHP 7.3.0 or greater. Please use "composer create-project laravel/laravel" instead.
PHP Laravel
51 votes372 views6 answers
Create model with controller laravel
PHP Laravel
39 votes309 views6 answers
Laravel foreign key constraint
PHP Laravel
-1 vote260 views2 answers
How to Delete Multiple Records using Checkbox in Laravel
PHP Laravel
1 vote301 views1 answer
Laravel routing controller get and post method
PHP Laravel