Nearest location using php

SELECT id, ( 3959 * acos( cos( radians(37) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(-122) ) + sin( radians(37) ) * sin( radians( lat ) ) ) ) AS distance FROM markers HAVING distance < 25 ORDER BY distance LIMIT 0 , 20;

Source: stackoverflow.com

Similar codes

2 votes306 views1 answer
How to put value of one variable into another in bash
Shell/Bash
0 vote331 views2 answers
Python google sheets api packages
Shell/Bash
1 vote314 views1 answer
Stop docker image from exiting
Shell/Bash
0 vote283 views1 answer
Ssh reset password
Shell/Bash
1 vote294 views1 answer
How to merge remote branch
Shell/Bash
0 vote300 views1 answer
Dgvai/laravel-adminlte-components
Shell/Bash
5 votes297 views2 answers
How to install npm in centos
Shell/Bash
0 vote316 views1 answer
Bash change variable in while loop
Shell/Bash
0 vote326 views1 answer
How to install centos 9 stream
Shell/Bash
0 vote303 views1 answer
How to list files starting with a in linux
Shell/Bash