Hi,

I need to try and track visitors to a specific page. Im asking here as i generally use php for my pages.

I dont want to use webtrends as its not accurate enough, i thought about maybe just a page counter that was hidden? But that only gives visitor numbers, i was thining that i might be able to get visits per day, or some more interesting, but legal information.

Basically its to track an adverts effectiveness.

Thanks for any info.

Simon

This is one I use on my PHP sites. saves to a MySQL database.

PHP Code:

function tracker() {
global $HTTP_SERVER_VARS;
//$page =  "'" . substr($page,0) . "'" ;
if (array_key_exists("HTTP_REFERER",$_SERVER)) {
    $referer = "'". $HTTP_SERVER_VARS["HTTP_REFERER"] . "'";
} else {
    $referer = "'--'";
}
if (array_key_exists("QUERY_STRING",$_SERVER)) {
    $querystring = "'". $HTTP_SERVER_VARS["QUERY_STRING"] . "'";
} else {
    $querystring = "'--'";
}
$today = "'" . date('Y/m/d') . "'" ;
$now = "'" . date('H:i:s') . "'" ;
$remoteip = "'" . $HTTP_SERVER_VARS["REMOTE_ADDR"] . "'" ;
$page = "'" . $HTTP_SERVER_VARS["PHP_SELF"] . "'" ;
$method = "'" . $HTTP_SERVER_VARS["REQUEST_METHOD"] . "'" ;
$useragent = "'" . $HTTP_SERVER_VARS["HTTP_USER_AGENT"] . "'" ;
$db = mysql_connect("server", "user", "pass");
mysql_select_db("database", $db);
$sql ="SELECT * FROM table";
$result = mysql_query($sql);

$sql = "INSERT INTO table (accessdate,accesstime,remoteip,refererurl,siteurl,querystr,method,useragent) VALUES ($today,$now,$remoteip,$referer,$page,$querystring,$method,$useragent)";
//echo $sql;
$result = mysql_query($sql);
mysql_close($db);
} 


table structure is

id bigint auto_increment
accessdate date
accesstime time
remoteip char(15)
refereurl char(254)
siteurl char(254)
querystr char(254)
method char(6)
useragent char(254)
pagename char(50)

one day I'll get around to adding some javascript to get more client side data