Newbie question: Logging in-site movements

maddaze

When a user visits my site, I'd like to log his movements within the site. In particular I'd like to log selected data when he arrives on a page. I've found several scripts at PHPClasses.org that provide the basic functionality to do this.

I'd also like to log selected data when he leaves a page, whether by clicking on a submit button, a link, his browser's Back button, or whatever. Is that possible? If so, where do I look to learn more about how to do it?

Harvey

swatisonee

I DONT use classes but i created a file called protect.php and it is the FIRST line in all my scripts

<? include("protect.php") ?>

Protect has the foll. code.

<?php
   $hostname = gethostbyaddr($_SERVER['REMOTE_ADDR']);

   $ip = GetHostByName($hostname);
     $t1 = date('Y-m-d H:i:s');
   $page = $_SERVER['PHP_SELF'];
   $url = $PHP_SELF."?".$_SERVER['QUERY_STRING'];


 ?>

 <input type="hidden" name="ip" value="<? echo $ip?>" >
 <input type="hidden" name="userid" value="<? echo $userid ?>" >
 <input type="hidden" name="t1" value="<? echo $t1 ?>" >
 <input type="hidden" name="page" value="<? echo $page ?>" >
 <input type="hidden" name="url" value="<? echo $url ?>" >




<?

 mysql_connect("localhost", $dbname, $dbpasswd )
 or die ("Unable to connect to server.");

 mysql_select_db($database)
 or die ("Unable to select database.");

$sqla = "INSERT INTO `Log` (uid, Date, ip, File) VALUES ('$userid', '$t1', '$ip', '$url')" ;

// echo $sqla;
// echo $page;


 $resulta = mysql_query($sqla)
 or die (mysql_error());
 $sqlb="select max(LID) from `Log`";

 $resultb = mysql_query($sqlb)
 or die (mysql_error());

 $myrowb = mysql_fetch_row($resultb);
 $lid = $myrowb[0];
?>

HTH,
Swati

maddaze

Swati,

Thanks for responding. I don't have a problem logging data when somebody lands on a page. As you point out, that's easy to do.

What I would like to do, and can't figure out how to do it, is to make a log entry when somebody LEAVES a page. I'd like to capture how long they were on a page and where they're going next: another page on my site or another site. How do I trigger a server-side event as someone is leaving a client-side page? Any ideas on how to do that.

Harvey

swatisonee

I assume when you log IN to a page, it means you have logged OUT of the previous page. So when you read the table with the data you'd know what time they wnet to page so you'd be able to subtract the time spent on the previous page...

unless you're asking something completely different and i have understood wrong...

swatisonee

This might help you.

http://www.phpfreaks.com/forums/index.php/topic,101955.0.html