Show GPS Position from a MySQL Database on a Site with Refresh and to insert in each HTML Site
$10-30 USD
Cancelado
Publicado hace alrededor de 9 años
$10-30 USD
Pagado a la entrega
I have a Database with a Table form a GPS Server. In this Table i get all Infos about Position and some additional Values. I wish to have a Script, what i can insert in each Website i want. It must automatic refresh by Seconds, wthout new loading the Site.
I also will have in Script some Config - Database Parameter must be hidden in mainfile (load from different file), Marker Graphic must be to change, Also it must show me all Infos from Datarecord - It must have Language select (only some Words) Refresh time must be to handle, OpenSeaMap Overlay must be on Map.
Zooming and geocoding a Address from Position (for Germany)
I also must can add multiple Device ID´s in Script to show more than one GPS Devices in one Shot - and also i need each Device to have its own Graphic!
Normal this is a mini Job for a Coder what has Knowledge. I will append the Table to understand the Database here.
From Interest are this Fields - if no content, than it must insert N/A
altitude - hold the altitude
cource - hold the course
latitude - latitude
longitude - longitude
other - need only the value of protokoll here
power - is Power level
speed is actual speed
time is timestamp, here i need alltime only the actual VAlue (latest Entry)
valid - if 1 than is valid if 0 than not valid
device_id is the Device ID from one GPS.
To make it easier for you we have here another table what holds the Device ID and what it is.
ID is here the same number we use for device_ID in other table
So than you get here the follow Infos
IconType - IconType i use in Main Program, but not relevant here, we use additional Icons
idleSpeedTreshold - not relevant for me
name - this is the real name of the ID, that we use also to show the Name of the GPS Device,
UniqeId - is not relevant for now here but is unique Device ID
latestPosition_id - this is relevant for you to know, which record you must load for GPS / Position lat/lon !!!
Sometimes this Value in this table will reset, if we delete old Datas from Database. So you have with this VAlue anytime the right latest record.
Hello!
With 99% completion rate, 750 successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page https://www.freelancer.com/u/rajeshsonisl.html !!)... you can never go wrong choosing me :)
I look forward to your reply.
Thanks.
Kind Regards,
Rajesh Soni
Hello! It's an easy task. I can be done with pure HTML, CSS, PHP and MySQL. It could be refreshing without loading the whole website by using jQuery, and it would also be easy. Please, message me to discuss it.
Hi,
I have some experience working with HTML5, Javascript and SQLite. I would love to take on this challenge, to start off my freellancing career.
I'm a electrical engineer working full time with embedded systems, looking to find extra work for my free time. I choose 7 days to deliver since I might need slightly more time than someone doing similar projects regulararly and since I'm working full time.
Regards,
Anders