Double Hits

14zero

I have a script on pages throughout my site to keep track of users activity. The probelm I am having is that when a user accesses a sub page of my site the home page seems to get hit as well? I am unsure why the homepage would be getting hit.

I removed the script from the homepage and I get one hit on the subpage. But when I include it again the sub page records a hit and so does the homepage?

On each page I have this PHP recording information

$ip = getIP();
$date = date("y-m-d");
$time = time();
$browser = addslashes($SERVER["HTTP_USER_AGENT"]);
$self = $SERVER["REQUEST_URI"];

if (isset($SERVER["HTTP_REFERER"])){
$referer = addslashes($SERVER["HTTP_REFERER"]);
}else{
$referer = "NO REFERER";
}

I made all the variables = "test" and it still hit the homepage so I gather it is none of these doing it. The rest of the script is just DB entry code.

Can any one shed any light on what would be hitting the root page of my site when a sub page is accessed?

Thanks

drawmack

just a guess, does your main page contain a redirection script so that all of the links on your site pipe through the main page and then load the sub-page with either header redirectes or through include statements?

14zero

I wish, I am still struggling to understand how the default page for the site gets executed without being called, or at least I can't see anywhere it is getting called from.

It returns / as the URI so it is calling the domain I think and executing the Default Script, but like I said I am not calling it anywhere?

drawmack

well that's my best guess without more information or a link so I can see what's happening from the user's standpoint at least.

14zero

This code below is all the code that makes this page

http://www.citrusmedia.biz/report_stats.php

<?

function getcountry($ip) {

$host = gethostbyaddr($ip);
$hostdot = ".";
$result = strrchr($host, $hostdot);
return $result;
}

$link = mysql_connect("localhost", "", "") or die("Unable to connect to Database!");
mysql_select_db("***") or die("Unable to select base");

$sql = "SELECT * FROM stats Order By Date DESC";
$query = mysql_query($sql) or die ("Error in query");

while ($row=mysql_fetch_array($query)) {

$sql2 = "SELECT Time FROM stats_details Where StatID = '$row[Id]'";
$query2 = mysql_query($sql2) or die ("Error in query");
$totalhits = mysql_num_rows($query2);

echo "<a href='report_stats_details.php?stat=".$row['Id']."'>".date("l dS of F Y h:i:s A",$row['Date'])."</a> - Total Hits ".$totalhits." - IP ".$row['IP']." - ".@gethostbyaddr($row['IP'])." - Referer ".$row['Referer']."<br>";

}
?>
[/COLOR]

As you can see there is no DB insert code. But sometimes I can see my hit count going up be refreshing this page ( and others), it is somehow executing the index page of the site and thus inserting records into the database

Very Weird I can' figure it out

drawmack

On the real site is this code wrappered with a common header and footer that are also used on the main page?

14zero

The code in my post above is the only code on the page, no header and footer.

I have actually gone a little loopy trying to get to the bottom of it and spent most of yesterday trying to figure out why this would be happening and can come to no logical conclusion.

I just logged on and refreshed the page above and sure enough there was a hit displayed. So whatever is calling the root page to be processed has got me stumped