Chapter 18:
Further Adventures in PHP

Tracking Hits with a Database

Now start a new script, name it "tracker.php" and put this code in it:

<?php
// configuration data arrays
$se=Array("yahoo", "google", "altavista", "alltheweb", "msn"); $languages=Array("en-us"=>"English-US","en-gb"=>"English-GB", "en-au"=>"English-AUS","en-ca"=>"English-CA","en"=>"English", "de"=>"German", "zh"=>"Chinese", "es"=>"Spanish","fr"=>"French", "ja"=>"Japanese", "it"=>"Italian");

// Find IP address
$ip = $REMOTE_ADDR;
// Determine date and time
$date = date("Y-m-d h:i:s");
// Find browser and operating system
$agent=split("; ", getenv("HTTP_USER_AGENT"));
$browser=$agent[1];

$os=ereg_replace("\)", "", $agent[2]);

// Get referring page
$url = $HTTP_REFERER;
if($url == "") {$url="Not Available";}

// determine which search engine was used
foreach($se as $k => $v) {
  if (ereg($v, $url)) {$engine = $v; break;}
  else {$engine = "None or Unknown";}
}
$vars = split("&", $url);
foreach($vars as $k => $v) {
  if(ereg("\+", $v)) {
    $keywords = ereg_replace("\+", " ", ereg_replace(".*q\=", "", $v));
    break;
  }
}
$keywords = ereg_replace("\%\2\2", "", $keywords);

// Now get the user's language(s)
$language=getenv("HTTP_ACCEPT_LANGUAGE");
$lang=ereg_replace("\;\.\*", "", $language);
$lang=$languages[$lang];
if($lang == "") {$lang = "Other";}
// determine which page was viewed
$uri = $REQUEST_URI;
if($uri=="/") {$uri = "home page";}

// COOKIE SECTION
//Determine if user is new to the website
$visit1 = $_COOKIE["visit1"];
$visit2 = $_COOKIE["visit2"];
//Determine if user is new to the website
$newuser=($visit1=="")?"Yes":"No";
//Get date and time of last visit
$visit=($visit1)?$visit1:$date;
//Get number of days since last visit
$days_ago=($visit2!="")?intval((time()-intval($visit2))/(60*60*24)):0;
//If result is a decimal number, then set it to 0
if($days_ago<1) $days_ago=0;
//Set cookie expire time in (90 days * 24 hours * 3600 seconds per hour)
$cookie_expire=time()+(90*24*3600);
//Set last visit date and time in cookie
setcookie("visit1", $date, $cookie_expire);
//Set current timestamp in cookie
setcookie("visit2", time(), $cookie_expire);

// save the data in the database
$db_name = "traffic";
$db_host = "localhost";
$db_user = "MyUserName";
$db_pass = "MyPassWord";
$db_conn = @mysql_connect ($db_host, $db_user, $db_pass);
$db = @mysql_select_db($db_name, $db_conn);
$sql = "INSERT INTO hits(ip,date,browser,os,engine,lang,keywords,page,newuser,last_visit,days_ago) VALUES(\"$ip\",\"$date\",\"$browser\",\"$os\",\"$engine\",\"$lang\",\"$keywords\",\"$uri\",\"$newuser\",\"$visit\",\"$days_ago\")";
$result = @mysql_query($sql, $db_conn);
?>

WOW! That looks like a lot of code! And some of it may be unfamiliar to you - even after reading this far into the book. OK, let's take it from the top...

Copyright © 2004 Steve Humphrey