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)) &#123;
$stats_referer = $r&#1111;'referer'];
$stats_id = $r&#1111;'id'];

if ($stats_referer == "") &#123;

&#125; else &#123;
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>";
&#125;
&#125;
?>
</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&#1111;'REMOTE_ADDR'];
$browser = $HTTP_USER_AGENT;
$whatpage = $_SERVER&#1111;'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)) &#123;
$stats_referer = $r&#1111;'referer'];
$stats_id = $r&#1111;'id'];

if ($stats_referer == "" || preg_match("/^http:\/\/www.d-frame.co.uk\//i",$stats_referer)) &#123;

&#125; else &#123;
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>";
&#125;
&#125;
?>
</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)) &#123;
$stats_referer = $r&#1111;'referer'];
$stats_id = $r&#1111;'id'];

if ($stats_referer == "" || preg_match("/^http:\/\/www.d-frame.co.uk\//i",$stats_referer)) &#123;

&#125; else &#123;
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>";
&#125;
&#125;
?>
</table>
That should work. :)
Yeah it worked :)

Thanks!!