Related Files
Referer.sql
referer.phps
viewreferer_.phps
What is a Referer?
A Referer is the URL, from which the User comes to your Site. Let's say at
http://www.server.de/links.html there is a Link called "Your Site". He clicks
on it, then he'll get to http://www.your-site.de (this is your URL). Then
http://www.server.de/links.html is the Referer. The following Example shows
you, how to track these URLs and get a little Overview of the Pages which have
a Link to your Site. |
|
$hostname = "localhost";
$username = "name";
$password = "passwort";
$userstable = "referer";
$dbName = "db-name";
$domain = "server.de";
|
|
|
Some Variables like the MySQL-Login and Password. $domain is your Domainname,
because we don't want it to show up in the Stats. If you can access
www.server.de as well as server.de, then only enter "server.de". This is
because everything containing $domain will be kicked out. |
|
|
|
|
Now we check the Referer, the Page from which the User came. |
|
$ref2 = strtolower($ref);
|
|
|
With strtolower we set the Refere lowercase. This is because someone could have
accessed www.server.de as well as www.Server.de or WWW.SERVER.DE. |
|
$check = strstr($ref2,"$domain");
|
|
|
In the lowercased Referer is $domain is searched. |
|
|
|
If $check, the Search for the Domainname, doesn't find anything, nothing will
be printed out |
|
elseif (empty($check)){
mysql_connect($hostname,$username, $password) or die(mysql_error());
mysql_select_db("$dbName") or die(mysql_error());
|
|
|
If a Referer from "outside", was found, a Connection to MySQL will be started. |
|
$query = "select * from $userstable where url = '$ref2'";
|
|
|
Then the Table will be searched for $ref2, the lowercased Referer. |
|
$result = mysql_query($query);
$rows = mysql_num_rows($result);
|
|
|
$rows counts all Entries found |
|
|
|
If there is no Entry for $rows, |
|
|
|
|
the Variable $hits will be set to1. |
|
$query1 = "insert into $userstable (url,hits) values('$ref','$hits')";
|
|
|
Then the URL and the Hits will be inserted into the Database. |
|
|
|
If an Entry was found (someone came from the Referer already), |
|
else {
$hitquery = "select hits from $userstable where url = '$ref'";
|
|
|
this Entry will be used. |
|
$result2 = mysql_query($hitquery);
$row = mysql_fetch_array($result2);
$hits = $row["hits"];
|
|
|
The hits-Field will be used in an Array. |
|
$query2 = "update $userstable set hits = hits+1 where url = '$ref'";
|
|
|
Hits will be inreased by "1". |
|
mysql_query($query2);
}
}
|
|
|
Now save this File as referer.php3 and call it like |
|
include("referrer.php3");
|
|
|
That's all. But as i wrote above, there are also grafical statistics
The graphical Stats
We start again with the Variables to connect to MySQL.
|
|
$hostname = "localhost";
$username = "name";
$password = "passwort";
$userstable = "referer";
$dbName = "db-name";
|
|
|
As this script works with tables and their backgroundcolors, you'll now have to
define the colors showed for the number of hits. |
|
$color10 = "#FFFF00";
$color20 = "#FF0000";
$color50 = "#008000"
$color1k = "#0000FF"
$color2k = "#0000A0"
$color5k = "#000040"
|
|
|
Then the connection to MySQL is done again. The results from the SQL-statement
are orderd descending by the number of hits. |
|
mysql_connect($hostname, $username,$password) or die(mysql_error());
mysql_select_db("$dbName") or die(mysql_error());
|
|
|
Now, all Data will be selected and sorted descending by the Number of Hits. |
|
$query = "select * from $userstable order by hits desc";
$result = mysql_query($query);
|
|
|
The Number of Results will be checked.. |
|
$number = mysql_num_rows($result) or die (mysql_error());
$i = 0;
|
|
|
If no Referers have been tracked yet, an Error Message will be displayed. |
|
if ($number == 0) {
print "<center><p><b>No Refererstrackedyet!</b></center>";
}
|
|
|
If Referers have been tracked: |
|
elseif ($number > = 1) {
while ($i < $number){
$row = mysql_fetch_array($result);
$hits = $row[hits];
$ref = $row[url];
|
|
|
It will be checked if $ref is the Result of the Field "hits".
Now, Hits will be counted and the Color will be chosen.
|
|
if ($hits <10){
$color = "$color10";
}
elseif (($hits >= 10 )
and ($hits < 20)){
$color = "$color20";
}
elseif (($hits > = 20 )
and ($hits < 50)){
$color = "$color50";
}
elseif (($hits > = 50 )
and ($hits < 100)){
$color = "$color1k";
}
elseif (($hits >= 100 )
and ($hits < 200)){
$color = "$color2k";
}
elseif ($hits >= 200){
$color = "$color5k";
}
|
|
|
The table is built with the results of the MySQL-query. In the first colomn,
the URL is printed, in the second the number of hits and the third has the
defined color as the backgroundcolor. |
|
print"<divalign=\"left\">";
print "<tablecols=3 border= \"0\"width=\"100%\"><tr><td
align=leftwith=\"400\"><b><ahref=\"$url\">$url</a></b></td>";
print"<tdalign=rightwidth=\"60\"><b>$hits</b></td>";
print"<td align= leftwidth=\"$hits\" bgcolor=\"$color\"></td></tr>";
print"</table>\n";
}
}
$i++;
print"</table>\n";
}
}
|
|
|
Save this File as viewreferer.php3 and wait some Days. Then you'll have a
graphical Statistic of most of the Pages that have a Link to yours.
|
|
|
