Library to plot a themperature chart
Posted: Fri Dec 19, 2008 4:39 am
Hello,
I am having my temperature reading in MySQL database and would like to make a chart based on this data.
The only problem is that I can't make a simple x,y chart because I do not have temperature reading every constants step.
I am having in MySQL something like that:
Sensor ID | Themp | Date
001 | 22,5 | 2008-12-15 10:20:15
001 | 21,1 | 2008-12-15 10:28:19
002 | 16,2 | 2008-12-15 10:31:14
001 | 21,7 | 2008-12-15 10:48:09
002 | 17,1 | 2008-12-15 10:52:01
001 | 21,8 | 2008-12-15 11:12:29
And for example if I would like to make a chart from last 24 hours I have a 100 readings from sensor 001 and let’s say 150 readings from sensor 2. And it is hard to make a one chart with both sensors. At the moment I am having something like this (using Open Flash Chart):
http://maxjar.no-ip.org/chart.php
So I am looking for any PHP-based library with time-based x axis.
Sorry form my English, I am not a native speaker.
I will appreciate any help.
Kind Regards,
Piotr
I am having my temperature reading in MySQL database and would like to make a chart based on this data.
The only problem is that I can't make a simple x,y chart because I do not have temperature reading every constants step.
I am having in MySQL something like that:
Sensor ID | Themp | Date
001 | 22,5 | 2008-12-15 10:20:15
001 | 21,1 | 2008-12-15 10:28:19
002 | 16,2 | 2008-12-15 10:31:14
001 | 21,7 | 2008-12-15 10:48:09
002 | 17,1 | 2008-12-15 10:52:01
001 | 21,8 | 2008-12-15 11:12:29
And for example if I would like to make a chart from last 24 hours I have a 100 readings from sensor 001 and let’s say 150 readings from sensor 2. And it is hard to make a one chart with both sensors. At the moment I am having something like this (using Open Flash Chart):
http://maxjar.no-ip.org/chart.php
So I am looking for any PHP-based library with time-based x axis.
Sorry form my English, I am not a native speaker.
I will appreciate any help.
Kind Regards,
Piotr