Counting Link Clicks

[Radon3k]

I was wondering how you would go about checking to see how many times a link is clicked. Thanks. 🙂

[zhabala]

It is probably quite easy. Each link is not link to the place where you want to go, but is it a link to the script which can count the clicks and then do the transfer with header Location to the page you want to go.

<a href="http://this.site.com/redirect.php?url=http://www.somewhere.com">www.somewhere.com</a>

Then the script redirect.php have to count the click (in DB or in file) and then do the redirect.

Zdenek

[Radon3k]

Yes but could you show an example of the code? I just need to know how to record the click, the rest I can do. Thanks. 🙂

[zhabala]

Wow, why you need to see so simple part ?

create a DB table like

create table links ( id integer,
site varchar(255),
clicks integer ).

Then in the redirect.php you have to:

UPDATE links
SET clicks = clicks + 1
WHERE site = $URL

and then

header('Location: '.$url);
exit;

What more ?

[Radon3k]

Thanks for that. It may be simple to you but I was thinking of a different way to do it.

[zhabala]

Not at all, maybe you could tell us your idea to discuss about that.