[RESOLVED] Tracking specific record access

swatisonee

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 .

<FORM action="travel_expenses.php?advanceid=<? echo $advanceid ?>&enquiryid=<? echo $enquiryid ?>&visitid=<? echo $visitid ?>&userid=<? echo $userid ?>&id=<? echo $id ?>" method="post">

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 !

gardnc

for each querystring add

variable = $_GET['variable'];

to pull each querystring variable from your URL and put them into the appropriate variables.

i.e. $userid = $_GET['userid']

Frederick

OR use "hidden tags" to hold the values of all the following:

advanceid=<? echo $advanceid ?>&enquiryid=<? echo $enquiryid ?>&visitid=<? echo $visitid ?>&userid=<? echo $userid ?>&id=<? echo $id ?>

swatisonee

Thanks but how do I put it all in a single field ie of page ?

Example : The value that should get saved in the page field should be

\travel_expenses.php?advanceid=12&enquiryid=236&visitid=&userid=cad80134&id=b34

When i passed it as a "hidden" , i could see all the data but its not getting inserted as $page = $_SERVER['PHP_SELF'];

Await your guidance.
Thanks .

swatisonee

This solved the issue..in case anyones interested.

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