Best php counter/stats tool?

[rob]

anyone have a recommendation for a FREE page counter/stats gathering tool. I imagine it has to to be php based since that's the service we have here. I've used statcounter.com but the free version tops out after 100 hits or whatever and im almost there within a week.
It should be easy to implement too, as i'm a complete newb with php and aint done much web dev stuff since html 2.0 (you know when the <blink> tag was cool/annoying!)
Thanks!

[lifesux]

id stay www.statcounter.com as it has stuff like visiotr path tracking etc etc, but its free service only has up to the last 100 pageviews

[UnlimitedMB]

www.webstat.net

[jpskeyclub]

statcounter is the best ive tried...ive tried webstat too...

statcounter gives you so many details all for free

you could also try google analytics, but thats invite-only..

[bax]

http://awstats.sourceforge.net/

[UnlimitedMB]

Please do not install php/mysql stats programs on the server.
They really slow it down.

Its best to use the free stats services.

[bax]

you're the captain =)

[themarkster]

You know, you can just make one yourself if you're experienced at PHP. :) I'm just getting to know the language right now, a real noob, but I've worked things out with external text files and there's even one on my site right now.

[Tyler]

You know, you can just make one yourself if you're experienced at PHP. :) I'm just getting to know the language right now, a real noob, but I've worked things out with external text files and there's even one on my site right now.
Please do not use stat programs, includes flat text files... on our servers... it will slow them down.

[themarkster]

Oh, it includes flat text files? Before I remove my counter, can I kindly ask how they can slow the server down? :)

BTW, are there any other examples you can give of these stat programs?

[arenlor]

I'm not sure what you're looking for but here is a good counter. [note: I hate counters and I just use this for fun, the important thing is putting it into MySQL for you to look at and run these things on]
all it requires is a database with the table ips with the keys of an int named whatever you want and auto_increment primary key, and a text or varchar length 15 named ip
$ip = $_SERVER['REMOTE_ADDR'];
$trace = "insert into ips values(NULL,'$ip')";
$save = mysql_query($trace);
$show = "select * from ips where ip = '$ip'";
$post = mysql_query($show);
$num = mysql_num_rows($post);
echo "<p>You have visited this page $num times</p>";
$totalget = "select distinct ip from ips";
$gettotal = mysql_query($totalget);
$totalnum = mysql_num_rows($gettotal);
echo "<p>$totalnum people have visited this page</p>";
$visits = "select * from ips";
$tell = mysql_query($visits);
$visnums = mysql_num_rows($tell);
echo "<p>And this page has been visited $visnums total times</p>";


If you need any explanations or help at all just contact me, I wrote that out of boredom the other day.

[Tyler]

Oh, it includes flat text files? Before I remove my counter, can I kindly ask how they can slow the server down? :)

BTW, are there any other examples you can give of these stat programs?
If you have tons and tons of people all writing to the files it will make it slower because it is done on every page they click on. Everytime they click something is recorded and if you have 1,000 visitors an hour that all click 10 pages then you will have a file being edited 10,000 times an hour.

[themarkster]

Whoa, 1,000 visitors? I only get like less than 15 different visitors a day. Anyway, what if I only tracked the splash page, rather than each page of the website?

[Tyler]

Use a free counter... they can tell you a ton more information then you could see using a basic flat text file counter.