/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

4 votes112 views5 answers
Laravel route multiple middleware
PHP
2 votes158 views2 answers
Validation not exist in table laravel
PHP Laravel
1 vote134 views1 answer
Not required a field when checked not applicable checkbox in laravel
PHP Laravel
0 vote120 views1 answer
Order by in datatable laravel
PHP Laravel
0 vote103 views1 answer
Laravel - Add conditional where clause in query
PHP
7 votes105 views2 answers
Artisan in route in laravel
PHP
0 vote135 views3 answers
Not Found The requested URL was not found on this server. Apache/2.4.47 (Win64) OpenSSL/1.1.1k PHP/8.0.6 Server at localhost Port 80
PHP
1 vote109 views1 answer
How to get current location in laravel
PHP
0 vote176 views1 answer
Php slots
PHP
0 vote133 views1 answer
Laravel where between cluse
PHP Laravel