jiue123

Tính Khoảng Cách GoogleMap với SQL

Jul 22nd, 2015
31
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.29 KB | None | 0 0
  1. select
  2.                         *, (6371 * acos(cos(radians(".$_POST['latLocation'].")) * cos(radians(a.intLat)) * cos(radians(a.intLng) - radians(".$_POST['lngLocation'].")) + sin(radians(".$_POST['latLocation'].")) * sin(radians(a.intLat)))) as distance
  3.                 from
  4.         `table`
Add Comment
Please, Sign In to add comment