Referring Website trouble

Smudly

I am trying to capture the website's name that links to my website. When a person clicks that link, it should add it to my database. For some reason though, it isn't working. Any suggestions?

<?php
include('inc/connect.php');

$today = date("Y-m-d");
$ip = $_SERVER['REMOTE_ADDR'];
$referrer = getenv('HTTP_REFERER');
$referrerfinal = parse_url($url, PHP_URL_HOST);

echo $referrerfinal;
$check = mysql_query("SELECT * FROM uniquevisitors WHERE ip='$ip'");
$unique = mysql_num_rows($check);
if ($unique==0)
{
  $insert = mysql_query("INSERT INTO uniquevisitors VALUES ('',now(),'$ip','$referrerfinal')");
}
else
{
  exit();
}

?>

Database:

countid  	int(11)   	No   	    	 
date 	datetime 	No  	0000-00-00 00:00:00  	 
ip 	varchar(20) 	No  	  	 
referrer 	varchar(255) 	No

Thanks

dagon

$url is not defined,

HTTP_REFERER will not always be set

Smudly

Ok, i change $url to: $referrer

But it still isn't working.

What is wrong with it?

dagon

have you checked if the HTTP_REFERER is set? parse_url returns an array

Smudly

i'm not sure if it is set. not sure how to check ><

dagon

echo

Smudly

Yes it is echoing already.

echo $referrerfinal;

dagon

sooooo $referrerfinal appears on screen but is not inserted in the db? your trying with a unique ip?

Smudly

It actually isn't even posting to the screen. And yes, i am testing it with a unique ip. and I always delete any IPs that are in it when testing.

dagon

Smudly;10955270 wrote:
It actually isn't even posting to the screen.

well its not set then.

HTTP_REFERER will not always be set

its set by the browser, striped in many cases by a firewall. can't ever be relied on, for logging just accept it wont always be set.