Calculate distance between 2 points (latitude-longitude) with Mysql ST_Distance_Sphere method
If you want to measure distance between 2 points, you can use Mysql’ ST_Distance_Sphere method – comes with Mysql 5.7+. Assume that, you want to get closest user to given point: 41.0049823,28.7319855 <?php $latitude = 41.0049823; $longitude = 28.7319855; $sql…