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

Hashing?
Hi, I was hoping to take a string value then convert it - consistently - across each of our pages in

PHP error. Need help urgently
Hi,

I am programming a php site and have a problem that i just cant find out how to fix. When

Lining up columns nicely.
Hello everyone, I'm having problems with making columns line up properly. Here is my code:

post to self
Trying to get my form to submit to itself. However I am also trying to use an image for my submit bu

Phase Error I can't seem to find :(`
Hey guys, I can seem to find my phase error on this. I am getting this error

[error]
Pars

Change Age automatically
hi guys . im new to php , is it possible to change age value in mysql automatically when year change

Spliting paragraph into sentences and attach in
Here is what I am trying to do

example: Para1[123.456.789!] 3 sentences
Para2

Passing variables with pagination - iterating through unique id per link
Hi everyone,
I have seen a few topics like this one. Still cant find the specific thing, so I am

Form validation with functions
Hi there

I am trying to make a very simple form validation function. I currently have the fol

Parse Error with doctype
I'm getting a parse error with this simple code. I don't get it. It worked one time then when I relo