Hello

I decided to implement a Chart vision of the access to a address of the last 30 days. THe system that I choosed is Open Flash Chart.

The new methods:
getAccess($id) – Return an Associative Array with the access by date and the total
formatData($data) – Receive the access of getAccess and transform it in a Numeric Array.
criarLabels() – Create the labels to the bottom part of the chart.

If you want to access it, you have to manually get the ID and use http://www.example.com/diretorio/chart.php?id=ID where ID is UID from the MySQL table.

Example:

URL Shortener with Statistics and Chart.

Creating your own Url shortener
Statistics on your URL Shortener

Best Regards,
Matheus

PS: Don’t forget the Rewrite Rules.

Hello,

I will just show how to quickly install Apache 2, PHP5, MYSQL and PHPmyAdmin in Ubuntu.

Install apache2 with:

$ sudo apt-get install apache2

Install PHP5:

$ sudo apt-get install php5 php5-common php5-cli

Install MYSQL:

$ sudo apt-get install mysql-client mysql-server

(During the installation it will ask you password for root user of MySQL)

Install PHPMyAdmin:

$ sudo apt-get install phpmyadmin

(It will ask the MySQL password and of the PHPMyAdmin user)

Best Regards,
Matheus