Re: graph - dowloads/hr

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



i'd like to create a graph with the amount of downloads per hour, i am a little confused how i should go about this.

i know i can use rrdtool/mrtg, but im looking for more 'user friendly' graphs with custom colors,etc.

each time someone downloads a file it is incremented in the db and the last time the file was downloaded. i am unsure about the data i would need to store to create and if what i am storing is enough to do this. any suggestions or tools that already exists to create this types of graph?


jpgraph can do it... as can a lot of other graph/chart libraries...

http://www.aditus.nu/jpgraph/

yeah, i found that, but i dont know what type of data i would need to store to get the downloads an hour (24 hours). likewise, i only increment a counter and last time file was download and im pretty sure this isn't enough to generate such graphs.

Ah... then in that case you need to keep a log of downloads by hour. If I were you I'd create a database with a table that kept track of this stuff. Each row would contain the downloaded file ID, the date, the hour (set minutes to 00) and the number of times downloaded.

You could then query this table to get a downloads by hour graph or a downloads by date graph or whatever else you might want.

good luck!

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux