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

Logic question
im wondering what's the best method to do the above list:

it is for alliance @ MMORPG game

firefox wouldnt stream mp3 files completely from my php page
hi everyone,
I have a php file trying to read and stream mp3 files. It works fine in IE but my pr

delete comma
HI,

How to delete "," at the end of the string.
Code: $match = 2009/02/03/a2corr

Windows 7
Windows 7 default user account control worries experts. Corporate IT departments should be pleased w

PHP Game
hy i was wondering what's the best method in order to make some automatic updates in a php game
<

The IE or FF detector
Hello Friends,

Problem of today ( we seek for php help ) as following ,

we know all th

IF STATEMENT HELP
Hi
i have created a calendar from a table:

Code: Calendar: October 2009
<table w

retrieving images from mysql database using php
So I've been trying to figure out how to store images in a mysql database, and as far as i can tell

socket communication between c++/java and sending image
hi,

i have a class in c++ called win32_sockserver which creates socket to java. i am trying

Problem in OnClientClick and OnClick sync
Hi,Strange and irritating problem: I have below button declaration in markup of the aspx page: