swatisonee Posted February 24, 2006 Share Posted February 24, 2006 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'];?><?phpmysql_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 ! Quote Link to comment Share on other sites More sharing options...
swatisonee Posted March 5, 2006 Author Share Posted March 5, 2006 In case anyones interested : this bit of code gave me what i needed: [code]$url = $PHP_SELF."?".$_SERVER['QUERY_STRING'];[/code] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.