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

code help - pagination
Hi all, I have this code, basically a user logs into my site and they get this page.

The pro

SOAP Issue
Hi,

I am facing some understanding problem with SOAP basic.kindly recommend some SOAP expert.

Session login issue
I'm wondering how to fix a problem I'm having with a session-based login system

Say I go to h

problems with php variables in mysql query
i can't seem to get the following query to work.

select $q1c from $vote_rate where id = $re

Good Programming and Web Design Books
Hi,

I recived a pm today from a fellow phpfreaker regarding php books, i replied with the fo

Multiple submit forms inside a mysql array page
Hi all,

Im having trouble to get the beneath script to work the thing i can't seem to get wor

Struct/union and scope problem!
HI all , I have
Code: in header.h typedef struct Node Link; /* ---------

quotes changing
hi all

in my content

opening quotes " changes to “

close qu

Using system() and bringing back the results
I am aware that you can use system() within PHP to execute system commands, but I was wondering if t

how to transport the Query and insfoset
Hi

I have created the query using SQ01........
How to created T-code for query..