How to make dynamic google map's from database?

I have a database of addresses.  In my application (php/mysql) a user pulls up one address at a time.

When that address is pulled up, I want to display a google map with a marker of where that address is.

There are no lat / long in my database.  

How can I accomplish this?
dprundleAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
nizsmoDeveloperCommented:
I'm sure you can accomplish this using the Google API:
http://code.google.com/apis/maps/index.html
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
Loganathan NatarajanLAMP DeveloperCommented:
First go through the nizsmo's API URL

then, practice the samples there and workout few samples,

so, you can dynamically add lat / long by marking the location and store it in the database.  also for the lat/long you can store the address and it could be retrieved the marked locations...etc.,

look at this sample, http://maps.forum.nu/gm_markers_from_db.php
http://www.map-server.com/googlemaps/tutorial_api2.html


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.