Create line chart from MySQL table using Google Charts

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.

Evner: MySQL, PHP, Software Arkitektur

Se mere: php mysql line chart, google chart table mysql, using google charts confluence, google charts api mysql, google charts api legend pie chart, fpdf create mysql table, create cvs file create chart line excel, connect google map mysql table, create excel file mysql table php, create mysql table csv, create look table mysql webpage, create table mysql codeigniter, using charts flex mysql, google analytics ecommerce mysql table, create mysql table xml, fpdf create pdf mysql table, create google map categories mysql, vb6 create mysql table, php mysql table chart, create intranet using google

Om arbejdsgiveren:
( 4 bedømmelser ) Honiton, United Kingdom

Projekt ID: #14724512

Tildelt til:


javascript setInterval is the best way with using $.ajax to take the data. Data taken in PHP which takes data from db and provides JSON for the chart. Will be ready in a couple of hours. Relevant Skills and Experience Flere

£10 GBP på 1 dag
(2 bedømmelser)

14 freelancere byder i gennemsnit £33 på dette job


How are you I can do it !! Chose me

£15 GBP in 0 dage
(39 bedømmelser)

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

£18 GBP in 3 dage
(14 bedømmelser)

Hello, This is Quentin We are the team of 20 developers based in Rancho Palos Verdes CA . Initiate the chat to discuss your requirement in detail.. Relevant Skills and Experience Some of my skills are mentione Flere

£61 GBP på 1 dag
(31 bedømmelser)

Greetings, we are a team of 35 developers and 20 designers and each having more than 8 years experience. I would very much happy to work with you on your project and I have already checked detail your requirement and Flere

£18 GBP på 1 dag
(14 bedømmelser)
£100 GBP på 1 dag
(39 bedømmelser)

Hello, I am expert in Google Api and can help you to display information from the DB to Line chart. Please come on chat to discuss in detail. Relevant Skills and Experience Google graph chart Api Proposed Milestones Flere

£100 GBP på 1 dag
(15 bedømmelser)

Hello, I will deliver the BEST OUTCOME with in the time and budget, really looking forward to working on this project and I am very interested. Thank you. Relevant Skills and Experience I am a coder with 9+ years of e Flere

£35 GBP på 1 dag
(10 bedømmelser)

Hi, I have experience in working with ajax in accordance with mysql and jquery which i will does the job for this task. Most importantly i am from uk too which i believe will make it easier in regards to communicat Flere

£15 GBP på 1 dag
(7 bedømmelser)
£18 GBP på 1 dag
(6 bedømmelser)

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

£23 GBP på 1 dag
(7 bedømmelser)

I've 5 year of experience in development and I've already implemented these graphs

£18 GBP på 1 dag
(1 bedømmelse)

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

£18 GBP in 3 dage
(3 bedømmelser)

Build charts from data taken from database. Make it refresh automatically (real time) without refreshing the site. Relevant Skills and Experience I have worked with charts about 3 years, doing some reports, statistics Flere

£18 GBP in 5 dage
(0 bedømmelser)