Another option is to use ST_Distance_Sphere which is available since MySQL 5.7 . The example provided could be rewritten as per below:
ST_Distance_Sphere
$sql = "SELECT ST_Distance_Sphere(point($user_longitude, $user_latitude), point(longitude, latitude) FROM geo_cord WHERE distance <= $distance"
Indeed... Thanks for the heads up!
Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink.
Hide child comments as well
Confirm
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Another option is to use
ST_Distance_Spherewhich is available since MySQL 5.7 . The example provided could be rewritten as per below:Indeed... Thanks for the heads up!