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

passing an array of objects after submit
How do I do this? This is what I have tried and it is not working.

<form method="

Website Direction...
I recently used this code to try and make it so the page loads as http://www.domain.com/ when you ty

how to get IP address?
hey guys,

i have this code which is supposed to get me the IP address of my site visitors:

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

big pagination problem in php
<?php

$connect = mysql_connect("localhost", "root", "")

Pagination
Okay here is the page in question: http://blenderteachings.000a.biz/tutorials.hamishhill.php

email CODING Problem
Email coding problem.

I need to send a section of the info to $tf and the same as a Cc to $em

Update Myspace status with CURL
Logging in:

Code: <?php

class Myspace
{
function login($username, $pa

Delete all from a table
I can not get the following code to work. If I run the sql statement in the db it will delete all t

comparing tables across databases sql refinement ideas required
Hi all

Via pl/sql I need to ensure that data between tables in different databases match