Page 1 of 1

Good statistics script?

Posted: Fri May 20, 2005 7:11 am
by Mori
Well, I'm searching for a good statistics script (a free one). The most important thing for me is to track dynamic pages with parameters (for example: index.php?option=value). I would like to see daily stats for each one of them separatly (so hits to index.php, index.php?option=1 and index.php?option=2 would be separated).
Also - the statistics must not be included by JavaScript (I would like to use include/require).

So, if you know such script that I can download and use for free, please, leave a link.

Thanks in advance


Mori.

Posted: Fri May 20, 2005 7:14 am
by malcolmboston

Posted: Fri May 20, 2005 7:22 am
by Mori
No, none of the scripts I checked there was suitable for me...

And please, don't send me to a SE or scripts catalogue, I'm not that stupid, ok?

Posted: Fri May 20, 2005 7:24 am
by John Cartwright
No one suggested you are..

Posted: Fri May 20, 2005 7:32 am
by malcolmboston
Mori wrote:No, none of the scripts I checked there was suitable for me...

And please, don't send me to a SE or scripts catalogue, I'm not that stupid, ok?
code it yourself?

Posted: Fri May 20, 2005 7:50 am
by John Cartwright
Pretty easy actually.
On index.php you could have something along the lines of on every page call, insert into the database your query string ($_SERVER['QUERY_STRING']) as well as a timestamp.

Now when wanting to view the stats

a) Either flush out yesterday's stats and recompile them into a single row, instead of having to re-calculate the whole thing every time (which could be a hassle when you have 1 years worth of hits)
b) Have a query pull out all the rows in todays hits
c) Create a simple bar graph by calculating dimentions, or create a complex graph using JPGraph.