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

Typedef struct vs just struct
Anyone know the rationale for using typedef for structs when a struct is itself a typedef? I have s

php code generators
All

Whilst enjoying learning a new language i have come accross a number of free code generat

Rounding a number queried from a database
I know that to display a rounded number you just do echo "round($number)";. But how would

Kill a process
I have a question - how can I kill a process from a command line or by using Oracle SQL Developer? I

Mail functionality from localhost to server
Hi

I am facing problem of mail functionality.

When i tested mail functionality in my

dropdown menu
Hello everbody,

I am php newbie.
I need to develop a program that once click the drop do

timed header image rotation
I have a joomla site and I was trying to setup a rotating image based on timing NOT just refreshing

pull content
I have an existing page, domain/adverts.php which has a good PR. I've just rebuilt my site and the n

file downloaded can't be read !!
<?php
$fileName = 'mypic.jpg';
$mimeType = 'image/jpeg';
header('content-dispositio

xApp Analytics in BI 7.0
Dear all,

I am trying to implement xApp Analytics in BI 7.0. After I installed the analyt