Jump to content

Not logging myself INTO MSQL, by IP address or Hostname


sonny

Recommended Posts

I have a php page that inserts data into a MSQL DB on page load

 

Is there a way to exclude myself by either IP address or hostname

"partial string maybe" from being logged?

 


//Start
if (isset($_SERVER['HTTP_REFERER'])) {
    $refer = $_SERVER['HTTP_REFERER']; 
} else {
   $refer = "Referer NA</b>";
}

if (isset($_SERVER['REMOTE_HOST'])) {
    $host = $_SERVER['REMOTE_HOST']; 
} else {
   $host = "Host</b>";
}
//end

$ua=$_SERVER['HTTP_USER_AGENT'];
//$page=substr($_SERVER['PHP_SELF'],1);
$now=time();

$queryup="UPDATE visits SET vcode='0' WHERE ip='$ip' && page='$page'";
$resultup=mysql_query($queryup) or die(mysql_error());

$query="INSERT INTO visits VALUES('NULL', '$ip', '$host', '$refer', '$ua', '$page', '$flag', '$country', '$region', '$city', '$now', '1')";
$result=mysql_query($query) or die(mysql_error());

 

Thanks

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.