Jump to content

Plotting dynamic markers from MySQL DB in Google Maps


Texan78

Recommended Posts

Hello, 

 

I am working on a small project and looking for some suggestions on what would be a practical  and best way to approach this. I am not proficient at all in javascript and dread working with Google Maps. Here is what I am trying to do. I have a live streaming platform which has about 6 users. All the data I.E. lat/long, heading, geolocation etc is stored in a MySQL DB. The cords are inserted into the DB by a GPS client that is installed on the streamers computer that sends and updates the DB. All that is completed and works perfectly well and great there. What I need to do now is take that data from the DB and plot the users location on map via the cords in the DB but, since they are also constantly moving at times I need for the markers to refresh every X minutes or seconds and on mouseover on the marker show some other details like their name and geolocation which is also stored in the DB. There is a heading field and I have markers for that I need to convert to cardinal direction to display the correct heading icon. I have created a script that connects to the DB and returns a JSON response. What would be the best and easiest way to approach this? Use the JSON file or just use PHP to connect to the DB and create the variables to insert on the map? What is tricky about this is it is fully dynamic so I need some guidance on how to approach this as my Google search hasn't been very successful up to this point. The markers will only be plotted if a certain field in the table is returned as true. If it is true, then plot the marker from the cords in the DB and in the infobox show the other details I.E. Name, Geolocation, etc. One of the things I am struggling with on how to approach this is how to pull all the associated data for a certain user to creating the dynamic marker and infobox details dynamically triggered off a certain field in the DB. 

 

If anyone has any suggestions or guidance on how to approach this I would be greatly appreciative. I tried to hire someone to do this part of this small project but had a hard time finding someone that was interested so looks like I will have to do this myself. 

 

-Thanks in advance!

Link to comment
Share on other sites

Thanks, I have read through the Google Maps docs before. That would be useful for static markers but it doesn't help when it comes to dynamic markers and plotting more than one. 

 

Also no information on plotting markers from a DB or using JSON triggered off the value of a variable. 

 

Looking for suggestions. 

 

-Thanks

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.