php-homepage.de - Die deutschsprachige Ressource für PHP und MySQL- Scripts

Druckansicht von http://www.php-homepage.de/scripts/source_23.html

[ Main Menue ]

Homepage
Downloads
Artikel
Scripts
Forum
PHP-Manual
Links
News
Freelancer
Bücher
RuDolF
Suche
Misc
Über diese Seite
Kontakt
Wunschzettel
MyGuestbook

[ Suche ]

[ Partner ]

[ Partner Sites ]

Dynamic-Webpages
PHP-Center
PHP-Welt
phpUG.de
Random Link

[ Autoren gesucht! ]

PHP-Homepage.de sucht laufend Autoren für News und Artikel
Interesse?

[Start] [Code eintragen] [Suche] [Neue Einträge] [Registrierung]

Referer

<?php
//////////////////////////////////////////////////
// MyReferer Version 1.0
// Refererauswertung
// http://www.php-homepage.de
// referer.php3
// Autor: Mark Kronsbein
// Lizenz: GPL
// Diesen Credit bitte NICHT löschen!
// Sollten Sie dieses Script benutzen schicken Sie bitte
// eine Mail an php-homepage.de ! Danke
//
// Installation:
// include("referrer.php3");
//////////////////////////////////////////////////

$hostname = "localhost";
$username = "name";
$password = "passwort";
$userstable = "referer";
$dbName = "db-name";
$domain = "server.de";

$ref = "$HTTP_REFERER";
if (!empty ($ref)){
$ref2= strtolower($ref);
$check=strstr($ref2,"$domain");
}

if(!empty($check)){
}

elseif (empty($check)){
mysql_connect($hostname, $username, $password) or die(mysql_error());
mysql_select_db("$dbName") or die(mysql_error());
$query = "select * from $userstable where url = '$ref'";
$result = mysql_query($query);
$rows = mysql_num_rows($result);

if (mysql_num_rows($result) == 0){
$hits = "1";
$query1 = "insert into $userstable (url,hits) values('$ref','$hits')";
mysql_query($query1);
}

else {
$hitquery = "select hits from $userstable where url = '$ref'";
$result2 = mysql_query($hitquery);
$row = mysql_fetch_array($result2);

$hits =$row["hits"];
$query2 = "update $userstable set hits = hits+1 where url = '$ref'";
mysql_query($query2);
}
}
?>

<?php
//////////////////////////////////////////////////
// MyReferer Version 1.0
// Refererauswertung
// http://www.php-homepage.de
// viewreferer.php3
// Autor: Mark Kronsbein
// Lizenz: GPL
// Diesen Credit bitte NICHT löschen!
// Sollten Sie dieses Script benutzen schicken Sie bitte
// eine Mail an mk@php-homepage.de
// Danke!
//////////////////////////////////////////////////

$hostname = "localhost";
$username = "name";
$password = "passwort";
$userstable = "referer";
$dbName = "db-name";

$color10 = "#FFFF00";
$color20 = "#FF0000";
$color50 = "#008000";
$color1k = "#0000FF";
$color2k = "#0000A0";
$color5k = "#000040";

mysql_connect($hostname, $username, $password) or die(mysql_error());
mysql_select_db( "$dbName") or die(mysql_error());

$query = "select * from $userstable order by hits desc";
$result = mysql_query($query);
$number = mysql_num_rows($result);

$i = 0;

if ($number == 0) {

print "<center><p><b>Keine Datensätze gefunden!</b></center>";
}

elseif ($number > 1) {

while ($i < $number){
$row = mysql_fetch_array($result);
$hits = $row[hits];
$ref = $row[url];

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";
}
print "<div align=\"left\">";
print "<table cols=3 border=\"0\" width=\"100%\"><tr><td align=left with=\"400\"><b><a href=\"$ref\">$ref</a></b></td>";
print "<td align=right width=\"60\"><b>$hits</b></td>";
print "<td align=left width=\"$hits\" bgcolor=\"$color\"> </td></tr>";

$i++;
print "</table>\n";
}
}
?>

#
# Referer.sql
#

CREATE TABLE referer (
url varchar(100) NOT NULL,
hits int(10) DEFAULT '0' NOT NULL,
PRIMARY KEY (url)
);