Tracking Unique Clicks

Posted on 16th Feb 2014 07:03 pm by admin

Hi guys and gals,

Basically I have a database which tracks clicks on my outbound links, I do this by linking to a page like so...

/redirect.php?id=1

The page then reads the id and increments the click column in the database before selecting the link and redirecting.

I need it to only count the click if its from a unique IP for the link, what would be the best way to do this?

I was thinking of having another table with columns "IP" and "link_id", Then I could check the IP against the list of IP's for the current link. If its not there then add it and add the click, otherwise only redirect.

I want to find the best method before I start to try and code this so any help is appreciated.

Your Answer:

Login to answer

Other forums

Stopped working!
So I had to change some stuff, none of it major. Stuff like the extension_dir and such. BEFORE I did

How many users online in the last 24-hours using time()?
I'm fairly new to PHP. I have a MySQL table called 'users' and a field called 'loggedin' which is in

Socket programming
Hello all,

I have a PHP socket script. GPS trackers connect to this socket. IMEI verification

Calling All PHPFREAKS Blackberry Users
Are you a member of PHPFreaks and have a blackberry? Well RIM just recently released Blackberry Mes

What are the two different files you download to update kernel?
What are the two different files you download to update kernel?

Help Import Animoto and Youtube
CAn someone help me urgently want to allow users on my website to import youtube/revver/dailymotion

Cant display mysql data
Hey all,

I am learning php and my first goal is to create a simple CMS. At the moment I am st

keeps going back to index.html ???????
ok so i started making my site using mostly.html files now i have added a fair chunk of php. My inde

get multiple rows
Hi I want to get multiple rows from a db

I am using this for the db query
Code: public

How to limit the calls to an API
Hello, in my simple script I call an api which effectively involves me getting an xml file.

H