Cancelado

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

I want Google Charts (<[url removed, login to view]>) to display different charts of the temperature profile.

I need two Webpages:

**Page 1 ([url removed, login to view]):**

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 ([url removed, login to view]):**

This page shows the Chart.

## Deliverables

There is a very simple mysql-Database.

The DB logs the current Temperature (in [degree][1] [Celsius][2] * 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 (<[url removed, login to view]>) to display different charts of the temperature profile.

I need two Webpages:

**Page 1 ([url removed, login to view]):**

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][3] [average][4] of the 24 datapoints of the day) )

* A

specific month (e.g. Dez 2010) ((One datapoint per day (the single datapoints are the [arithmetic][3] [average][4] of the 24 datapoints of the day)

* A specific year (One datapoint per day (the single datapoints are the [arithmetic][3] [average][4] of the 24 datapoints of the day)

* All time (One datapoint per day (the single datapoints are the [arithmetic][3] [average][4] of the 24 datapoints of the day)

**Page 2 ([url removed, login to view]):**

This page is displayed after the selecting a chart, the charts must meet the following [requirements][5]:

* 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.

Habilidades: Vale Tudo

Ver mais: google chart php mysql, want create chart, make charts, create bar chart, two hours, two day, labeling, dez, create two, charts, celsius, average php mysql, php test page, php display, dynamic google chart, mysql php single page, php apis, row text php, php google chart, find chart, php mysql dynamic selection, average function, mysql logs, dump create database, want google page

Acerca do Empregador:
( 1 comentário ) Germany

ID do Projeto: #3034706

2 freelancers estão ofertando em média $81 para este trabalho

newgroup4u

See private message.

$127.5 USD in 14 dias
(7 Comentários)
4.6
klvworker

See private message.

$34 USD in 14 dias
(3 Comentários)
0.0