Jump to content

Tracking Record Access


swatisonee

Recommended Posts

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.


[code]<?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());[/code]



Thanks !
Link to comment
https://forums.phpfreaks.com/topic/3569-tracking-record-access/
Share on other sites

  • 2 weeks later...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.