Create 2 PHP-Webpages with Google Charts and mysql-Data
$30-100 USD
En curso
Publicado hace alrededor de 13 años
$30-100 USD
Pagado a la entrega
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.