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

need good snippet manager
Hi. as i am coding and learning more, it is becoming difficult to manage code snippets. how you mana

Form a inline view based on the results of the previous query?
Hi Experts,
Can we form a inline view on the results of a previous query (another inline view)?

Retrieving the 25 most recently added entries from all tables in a MySQL databas
Hello,

The code below works great. It creates a table that shows the 25 most recently added t

Multi image upload
I have a gallery to build and want to build a dynamic upload form to allow for $var number of fields

very easy question about SQL info
Hello,
I think that I have a very easy question.
I know how to create a form using php SQL and

Form File Upload
I've read through tons of resources and tutorials and as far as I can tell, my code is accurate, but

Creating web pages by php
Hello again,
I was just wondering us there a way to use a php script to create a new web page. I

Oracle Text CTX_DOC.snippet slow
I have a table (FILE_TABLE) that contains a blob column (ft_file) and I have created the following O

Printing a webpage
I use this to print the webpage: o

check comment for html
hi, I just wanted to check if a comment a user posts contains HTML, and if it does, to not allow it