I have a table in MySQL with the columns 'temperature', 'moisture' and 'date'. I would like to present this on a line chart using Google Charts, however the difficulty I'm facing is formatting my array of values from the database so that it can be used in a Google chart; as a Google Charts expert you'll know for sure that this DataTable has to be formatted in 'cols' and 'rows'. On the x-axis would be date, which is formatted date('Y/m/d H:i:s'), and on the y-axis will be temperature and moisture.
I would also like for this line chart to update itself every 60 seconds to reflect new data saved in the database, without having to reload the entire page. New data points should appear on the chart in real time, with old data points automatically scrolling out of view. Apparently you can use $.ajax and setInterval to simulate real time updates, but maybe you know a better way?
I'm expecting that this could be done within a couple of hours and I would like it done as soon as possible please, great opportunity for someone adept at Google Charts to earn a little extra cash.
14 freelancere byder i gennemsnit £33 på dette job
hi, i can help you with your project. send me more information about via freelancer.com chat. regards Habilidades y experiencia relevante linux php html5 bootstrap jquery mysql Htos propuestos £18 GBP - milestone
Hello there, I have worked with google maps and i can provide you the solution you need. Inbox me as soon as you can. Relevant Skills and Experience . Proposed Milestones £23 GBP - 1
Create line chart from MySQL table using Google Charts Relevant Skills and Experience MySQL, PHP, Software Architecture Proposed Milestones £18 GBP - Create line chart from MySQL table using Google Charts