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

styling a RadioButtonList
HiI need to have a radio button and close to it, its lable, then a space then another set of those.

NOOB needs help with upload file
The intent of this form is to create a folder for a client and upload an image into another folder '

Why use OOP?
Can someone explain to me why I should use OOP instead of procedure based code.

Im building a

bit of help needed
Im about to sort out my registration page for my website by customising a "registration" s

Object Interfaces
EDIT: Never mind, I just updated to php 5.

Hey all,

I'm currently experimenting with p

Session problem?!?
Hello All! I am very new to the php world but I am working on fixing things that a previous programm

help removing unwanted graphic
How do I remove the small elongated rectangular shape between the "Latest post" and "

Table trouble
i have been reading the forum for a few weeks and decided to join. i like the format and the advice

Need help-Error istream header declaration
Hi Everyone ,

I am having issue with istream declaration. I am new to C programming.
can a

Edit MySQL Row Using PHP and HTML Form
Hello,

Here's what I'm trying to do. Build a page where a user enters a MySQL row number in.