How to find Point of Interests in nearby location of a GPS coordinate?

August 27, 2014 | Siddiq Ansari | 0 comments

Global Positioning System- GPS is diversely used nowadays. Google Earth or Google Map is making life easier if someone want to view the road to a particular destination or when someone want to find out nearby hotels if he/she has his/her current GPS location coordinates. As a developer while using API of google map, when someone want to find out nearby places or point of interest within certain radius, then there is two ways which can be implemented. Both ways are about using mysql queries but only difference is the execution time.

Let’s start with an example.

If we have find out 10 nearby hotels and sort them by distance; we are provided with: a TABLE having hotel list with hotel name



Database based Nepali Date Converter

Convert Nepali date (B.S.) to English Date (A.D.) or Vice-Versa

Nepali Date
Gregorian Date

From 1900-01-01 A.D. to 2020-12-30 A.D.

From 1956/09/19 B.S. to 2077/09/15 B.S.


Download Nepali Date Converter

Like us on Facebook

Follow me on Google Plus

Follow me on Twitter