Page 1 of 1
[SOLVED] Logger... Hide My Site
Posted: Wed Feb 02, 2005 4:16 am
by Dale
Code: Select all
<table border="0">
<?php
$conn = mysql_connect ("localhost", "***", "***");
mysql_select_db ("***",$conn);
$sql = "SELECT * FROM sitestats ORDER BY id DESC";
$result = mysql_query($sql,$conn) or die(mysql_error());
while ($r = mysql_fetch_array($result)) {
$stats_referer = $rї'referer'];
$stats_id = $rї'id'];
if ($stats_referer == "") {
} else {
echo "<tr valign="top"><td><font face="verdana" size="1">$stats_id<br></font></td>
<td><font face="verdana" size="1"><a href="$stats_referer" target="_blank">$stats_referer</a><br></font></td></tr>";
}
}
?>
</table>
Thats what im currently using to view where my visitors are coming from. And this is how I log them:
Code: Select all
<?php
$conn = mysql_connect ("localhost", "***", "***");
mysql_select_db ("***",$conn);
$refferer = $HTTP_REFERER;
$thetime = date("l dS F Y h:i:s A");
$ip = $_SERVERї'REMOTE_ADDR'];
$browser = $HTTP_USER_AGENT;
$whatpage = $_SERVERї'REQUEST_URI'];
$sql1 = "INSERT INTO sitestats VALUES ('', '$refferer', '$thetime', '$ip', '$browser', '$whatpage')";
$result = mysql_query($sql1,$conn) or die(mysql_error());
$sql = "UPDATE counter SET counth = counth + 1 WHERE section = 'forum'";
$result = mysql_query($sql,$conn) or die(mysql_error());
?>
However when i view my stats (using top code) I want all entries that start with
http://www.d-frame.co.uk to be hidden. How would I do this? (But I still want them logged in the database fully).
Posted: Wed Feb 02, 2005 5:38 am
by jlawrence
Code: Select all
<table border="0">
<?php
$conn = mysql_connect ("localhost", "***", "***");
mysql_select_db ("***",$conn);
$sql = "SELECT * FROM sitestats ORDER BY id DESC";
$result = mysql_query($sql,$conn) or die(mysql_error());
while ($r = mysql_fetch_array($result)) {
$stats_referer = $rї'referer'];
$stats_id = $rї'id'];
if ($stats_referer == "" || preg_match("/^http:\/\/www.d-frame.co.uk\//i",$stats_referer)) {
} else {
echo "<tr valign="top"><td><font face="verdana" size="1">$stats_id<br></font></td>
<td><font face="verdana" size="1"><a href="$stats_referer" target="_blank">$stats_referer</a><br></font></td></tr>";
}
}
?>
</table>
That should work.

Posted: Wed Feb 02, 2005 5:47 am
by Dale
jlawrence wrote:Code: Select all
<table border="0">
<?php
$conn = mysql_connect ("localhost", "***", "***");
mysql_select_db ("***",$conn);
$sql = "SELECT * FROM sitestats ORDER BY id DESC";
$result = mysql_query($sql,$conn) or die(mysql_error());
while ($r = mysql_fetch_array($result)) {
$stats_referer = $rї'referer'];
$stats_id = $rї'id'];
if ($stats_referer == "" || preg_match("/^http:\/\/www.d-frame.co.uk\//i",$stats_referer)) {
} else {
echo "<tr valign="top"><td><font face="verdana" size="1">$stats_id<br></font></td>
<td><font face="verdana" size="1"><a href="$stats_referer" target="_blank">$stats_referer</a><br></font></td></tr>";
}
}
?>
</table>
That should work.

Yeah it worked
Thanks!!