Posted by Philip Hallstrom on 08/10/05 05:28

>>> 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!

[Back to original message]