page - hit counter in mysql

Who would ever think me releasing something

Being a newbie at php/mysql programming i had help from tutorials all over the place and from freakysid from SPF forums

1. MySQL based counter

You need:
1. phpmyadmin - http://sourceforge.net/projects/phpmyadmin/ -phpmyadmin install and use guide to add a table named mycounter to your existing vB database.

you need to select you vb database name listed in the left of phpmyadmin and run the following queries once in phpmyadmin

CREATE TABLE mycounter (count INT(11) UNSIGNED NOT NULL);
INSERT INTO mycounter SET count = 0;

i.e. if my vb database is named usertest you should enter like this the screen cap below or here.

2. need to edit your phpinclude template and add the following in:

PHP Code:

$result = mysql_query("SELECT count FROM mycounter");
$mycounter = mysql_result($result, 0) + 1;
$result = mysql_query("UPDATE mycounter SET count = count + 1"); 


save changes

3. then place $mycounter in your footer template

[Ruth]

looks nice,

is there a demo?

and how does it work? based on logins? or specified ip adress?

[eva2000]

based a raw pageview hits... you can see it working on my vB at the bottom of each page http://animeboards.com/

i'm still a newbie with php but working on it

[merk]

A sugestion eva2k...

Im after a counter script myself, which yours is great for, but i need one to also record the HTTP_REFFERER, and useragent, and i dont really want to us webtrends :/

I could try to add these features for you if you want me to?

[eva2000]

Originally posted by merk
A sugestion eva2k...

Im after a counter script myself, which yours is great for, but i need one to also record the HTTP_REFFERER, and useragent, and i dont really want to us webtrends :/

I could try to add these features for you if you want me to?

sure why not.. i'm planning to do this too but i have to learn how to do it first (it's only been 48 hrs since i started learning php )

[merk]

Ive done php for some time, but never have gotten around do doing anything of any importance :/

[FWC]

Who would ever think me releasing something

That's a nice hack. I installed it.

lol eva

the counter on AB is just like a stopwatch almost, it goes up like 2 every second (3 if you include me =)

[Bane]

Originally posted by merk
A sugestion eva2k...

Im after a counter script myself, which yours is great for, but i need one to also record the HTTP_REFFERER, and useragent, and i dont really want to us webtrends :/

I could try to add these features for you if you want me to?

In case anyone is interested, I am putting together something like this. You can view an example of the output at:

http://www.talkloud.net/forums/vbstats.php

As far as the referrer check

http://www.talkloud.net/forums/vbsta...ction=incoming

[dxb]

hi there eva

you did it at last

thanks for the counter

and Bane the stats look really great ....yes I'm intersted in and I will be waiting for if

but could you make it so that you can add it to a VB page and a non VB page if it's possible