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

Custom CMS
This is a big custom CMS script I'd like to develop and would like some help atleast figuring out wh

checkbox update
I am having a brain fart right now and i cant remember how to do this. if anyone could help that wou

How do i do multi uploads?.
Hey i would like to do this : http://hosting.mrkrabz.net/

I've got the base down you can uplo

need help in php variable
i have a php variable on one page
Code: [Select]$lastId = mysql_insert_id($db);
echo $lastId;<

re calling a function without including file
Hi,
i am new to programming in php, i was just checking the wordpress code and found out in the w

Most basic form question ever?
Hello,

I want to use this snippet to make sure the fields in a form are ok before processing

Add User script "Could not execute query"
This should be an easy script but I can't get it to run. Can someone please help me?

<

Undefined index: username HELP NEWBIE
I am trying a simple login/logout for my website. It works well with checking if the username exists

Storing Values taken from a DB...
Using this code it will generate a short list from my database

<?php
mysql_connect

PHP webpage & array print issue
I have this code running, and it works perfectly … however, see my bottom bit about what I see