如何使用php和mysql动态计算lat的距离？ [重复]

Question

This question already has an answer here:

• How to calculate distance from lat/long in php? 8 answers

In location table i have these columns:lat,long,date,userid

i want to display how much distance covered by particular user with my location table.

How to calculate distance in kilometer with help of lat long and query for this to display this data front side.

please refer below image for the same.

</div>

Answer 1

I would consider this a duplicate question.

Please see: Measuring the distance between two coordinates in PHP

Or google the Haversine formula.