Create 2 PHP-Webpages with Google Charts and mysql-Data

I want Google Charts (<[login to view URL]>) to display different charts of the temperature profile. I need two Webpages: Page 1 ([login to view URL]): Display the latest temperature as text and a chart that shows the temperature of the last 24 hours. Also on this page you can make a selection what chart you want to display: * The last 7 days * The last 30 days * A specific month * A specific year * All time Page 2 ([login to view URL]): This page shows the Chart. ## Deliverables There is a very simple mysql-Database. The DB logs the current Temperature (in degree Celsius * 100. That meens you must divide the value with 100 to get the temperature). The DB upgrowth is one row per hour. In the attachment you can find a dump of the current DB. I want Google Charts (<[login to view URL]>) to display different charts of the temperature profile. I need two Webpages: Page 1 ([login to view URL]): Display the latest temperature as text and a chart that shows the temperature of the last 24 hours. Also on this page you can make a selection what chart you want to display: * The last 7 days * The last 30 days (One datapoint per day (the single datapoints are the arithmetic average of the 24 datapoints of the day) ) * A specific month (e.g. Dez 2010) (One datapoint per day (the single datapoints are the arithmetic average of the 24 datapoints of the day) * A specific year (One datapoint per day (the single datapoints are the arithmetic average of the 24 datapoints of the day) * All time (One datapoint per day (the single datapoints are the arithmetic average of the 24 datapoints of the day) Page 2 ([login to view URL]): This page is displayed after the selecting a chart, the charts must meet the following requirements: * Labeling of the x-axis and the y-axis * Meaningfull values on the x-axis and the y-axis * Bar chart from the x-axis to the datapoints (from zero up for positive temperature, from zero down for negative temperature, regard the unit is degree Celsius) * dynamic, meaningfull scaling of the y-axis In the attachment you can find a very ugly example (only for test the function) and a phpinfo from my environment.