/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 vote240 views4 answers
Error": "Trying to get property 'id' of non-object" in laravel
PHP Laravel
0 vote211 views1 answer
Best version control tools for php
PHP
115 votes291 views6 answers
How to iterate array in php
PHP
1 vote240 views2 answers
Instalar php 7.4 no ubuntu
PHP
1 vote226 views1 answer
Remove product (item) from WooCommerce checkout page using AJAX
PHP
26 votes215 views6 answers
Laravel validation integer
PHP Laravel
23 votes213 views4 answers
Datetime difference in php
PHP
0 vote229 views1 answer
Wordpress add new page programmatically
PHP
0 vote215 views1 answer
How to run a php file in xampp
PHP
7 votes207 views2 answers
Laravel seeder with relationships
PHP