/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

2 votes188 views1 answer
Add Laravel .env variable to Vue component
PHP
0 vote242 views1 answer
Wp wc php out of stock product to bottom
PHP Wordpress
2 votes293 views1 answer
Symfony doctrine existing database
PHP Symfony
2 votes182 views1 answer
Call a function in php
PHP
0 vote211 views1 answer
Automatic Subdomain with PHP
PHP
5 votes224 views3 answers
Laravel grouping where
PHP
0 vote208 views1 answer
Woocommerce php customer reset password length
PHP
2 votes197 views5 answers
Php warning: php startup: unable to load dynamic library
PHP
0 vote207 views1 answer
Url() inside laravel config files
PHP
0 vote193 views1 answer
Php reverse dns lookup
PHP