Statistic from MySQL table using PHP and google charts
$30-100 USD
Completed
Posted about 14 years ago
$30-100 USD
Paid on delivery
Hi,
I need you to create a nice looking statistic site from a MySQL table.
I have got a flash catalogue which tracks the usage by submitting the user-emailadress once per minute into a MySQL table.
Now I need a nice looking statistic page which shows:
- A line chart showing how many minutes in total the catalogue was used at each day of the current month
- A list of users who used the catalogue at the current day ordered by minutes spent viewing the flash catalogue
I want to be able to change the current day / month to see older charts.
I want to be able to select a user from a dropdownlist which is auto filled using the email adresses from the statistic table. If a user was chosen only the data for this user should be used to draw the chart so I can control how a single user uses my catalogue.
I have attached a file with the structure of the MySQL table and some sample data.
The statistic page must be done in PHP. You can use the google charts api to draw the line chart.
Backroundcolor should be 333333, the fontcolor should be white.
Best,
Patrick.