/PHP/Laravel count distance lat/longtidue

Laravel count distance lat/longtidue

$lat = 41.118491 // user's latitude
$lng = 25.404509 // user's longitude

SELECT *, 
( 6371 * acos( cos( radians($lat) ) 
* cos( radians( latitude ) ) 
* cos( radians( longitude ) - radians($lng) ) + sin( radians($lat) ) 
* sin( radians( latitude ) ) ) ) 
AS calculated_distance 
FROM settings as T 
HAVING calculated_distance <= (SELECT distance FROM settings WHERE sid=T.sid) 
ORDER BY distance_calc

Source: stackoverflow.com

Similar codes

0 vote213 views1 answer
Make php website https
PHP
11 votes169 views5 answers
Php cors allow origin
PHP
0 vote173 views3 answers
Laravel where json array column
PHP
9 votes163 views1 answer
Get data in orderby in laravel
PHP
3 votes200 views4 answers
Get base url in wordpress
PHP Wordpress
0 vote149 views1 answer
Woocommerce_recently_viewed
PHP
0 vote175 views1 answer
The requested url was not found on this server. apache/2.4.46 (win64) openssl/1.1.1h php/8.0.1 server at localhost port 80
PHP
0 vote244 views1 answer
Laravel change string to text
PHP
4 votes175 views2 answers
Display all errors at once in laravel
PHP
0 vote163 views1 answer
Php fpm config file location
PHP