hey guys i am developing a final year location-based project(gps) in android.I have to create a server using php and mysql which contains name and location(in latitude and longitude) of important hospitals in Mumbai.The android client should be able to retrieve the the latitude and longitude of locations in mysql(external) database and then plot it on a google map.
Could u plzz tell me whether this is possible?If yes, then how? Any help would be appreciated....cheers
Your projject would in fact consist of two application. A client running on android, and a server php-mysql application. The client would most likely talk to server using standard http requests.
What is the reason for using the PHP/MySQL combination to achieve this? Unless the list of hospitals is very dynamic it would be far more convenient to just but the data in an SQLite database that Android comes with.
If this is no an option I would put up a simple web service from where you could retrieve your data.
actually sqlite being an embedded db for android, the task of retrieving data becomes easy...so was told 2 ask to connect to an external db like mysql to fetch data using web services like rest or soap...but i dont have any knowledge(practically) of such services...so wanted 2 know whether such a thing can be achieved using web services...and its not only d hospitals but also atm centres, police stations and petrol pump stations that i have 2 locate on d map...so ya in a way its a bit dynamic...