Hit Counter

[forumnz]

How would I go about having a hit counter for a particular referral? Lets say I have a banner ad and I want to find out the amount of clicks it's getting. I want it to be something like mysite.com/ref.php?abc and then redirect to index.php.

 

How would that work?

 

Sam.

[davidmuir]

Would you prefer to store the number of referrals in a text file or mySQL database?

[forumnz]

Database I guess.

[davidmuir]

This is simple then. I am sure that you could find a tutorial on this somewhere. All you would need to do is have one table with one value in it that each time the page is called you would select the value, increment it, then update it.

[dingus]

i would have 2 tables in a database

______________________________

|      Site        |        Hits          |

----------------------------------

then as you suggested have something like

ref.php?site=abcd

 

in ref just have a short script something like this

 

$site = $_GET["site"];
mysql_query("UPDATE ref SET Hits = Hits+1 WHERE Site="$site; ");
header('Location: ' . $site);

 

its a simple in place update hope that helps

[d22552000]

A nice file alternative is:

 

FOR PHP 5:

$site = $_GET["site"];
$hits = file_get_contents('.\\hits\\'.$site);
if (empty($hits)) {$hits=0;} $hits += 1;
file_put_contents('.\\hits\\'.$site,$hits);
header('Location: ' . $site);
exit();

 

FOR PHP 4:

$site = $_GET["site"];
$hit = fopen('.\\hits\\'.$site,'r');
$hits = fread($hit,64);
fclose($hit);
if (empty($hits)) {$hits=0;} $hits += 1;
fopen('.\\hits\\'.$site,'w');
fwrite($hits); fclose();
header('Location: ' . $site);
exit();

[cooldude832]

also you should set a session so you don't get refreshing the page getting false records

[d22552000]

also you should set a session so you don't get refreshing the page getting false records

 

if (!@session_id()) {
session_start();
//CODE FOR COUNTER HERE
} else {
header('Location: '.$site);
}