Jump to content


Photo

Tracking Record Access


  • Please log in to reply
1 reply to this topic

#1 swatisonee

swatisonee
  • Members
  • PipPipPip
  • Advanced Member
  • 253 posts

Posted 24 February 2006 - 11:14 AM

Hi,

I have this code to track my page access . How do I refine it to track record access please ?

Most of my forms have the foll. info. in form action so I would like $page below to also indicate the record accessed .


[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]<FORM action="travel_expenses.php?advanceid=<? echo $advanceid ?>&enquiryid=<? echo $enquiryid ?>&visitid=<? echo $visitid ?>&userid=<? echo $userid ?>&id=<? echo $id ?>" method="post">[/quote]

Currently,

$page only indicates \travel_expenses.php and not the rest of the data which is really what i am interested in tracking.


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

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


<?php


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` (userid, date, ip, page) VALUES ('$userid', '$t1', '$message', '$page')";

//echo $sqla;

$resulta = mysql_query($sqla)
or die (mysql_error());



Thanks !
Shishya

#2 swatisonee

swatisonee
  • Members
  • PipPipPip
  • Advanced Member
  • 253 posts

Posted 05 March 2006 - 01:21 PM

In case anyones interested : this bit of code gave me what i needed:

$url = $PHP_SELF."?".$_SERVER['QUERY_STRING'];

Shishya




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users