Scripts
BannerSysteem
Dit BannerSysteem is een make over van een staand BannerSysteem wat destijds is gemaakt door Bas Kreleger. Oke om dit werkend te krijgen MOET je de volgende stappen volgen! Lees dit en het werkt 100%!!! 1. Toevoegen van banners Om de banner zo snel mogelijk te laden raad ik je aan om de banners op je eigen server te zetten. Ga naar de tabel 'php_banners' en voeg hier alle banners toe. url = url naar pagina na klik op banner pic = url van de banner (liefst op server van eigen site) alt = tekst die verschijnt als je op banner wijst met muis bid = nog niks bij invullen!! Oke, nu komt de kolom bid, hier moet je cijfers invullen. Dit MOET 1 t/m zijn. Dus als je vier banners hebt toegevoegd, krijg je 4 cijfers, 1, 2, 3 en 4. Dit moet omdat dit gelinkt staat met de tabel php_banner_rotation. Dit komt straks. 2. Aanmaken login gegevens banner eigenaar(es) Ga naar de tabel php_banner_login. Voer hier ook alle velden in: loginnaam = de login naam van de banner eigenaar(es) wachtwoord = wachtwoord van de banner eigenaar(es) url = !EXACT! hetzelfde url adres als bij url vorige tabel!! 3. php_banner_rotation Zet hier gewoon het getal 1 in. Verder hoef je geen rekening te houden met het id wat dit veld krijgt. Je moet wel zorgen dat in deze tabel slechts 1 rij staat, met de waarde 1!!! Deze telt op t/m en daarna gaatie weer naar 1. Dus als je bijvoorbeeld 4 banners hebt telt deze waarde als volgt: 1,2,3,4 -> 1,2,3,4 enz. Dit getal vergelijkt zich dus met de kolom van het eerste tabel 'bid'. 4. php_banner_out Hier hoef je niets in te zetten. Deze vult zich automatisch met de statistieken :) Zet alle scripts dus in een apparte map, bijvoorbeeld: www.domein.nl/bannerstats/ Zet het scriptje banners.php op je webserver en zet dit dan op elke pagina: Zo hoef je niet overal het script neer te zetten maar kun je het gewoon op elke pagina requiren :o) Succes ermee, het werkt 100%!!!!
bannersysteem
MySQL tabellen: (copy/paste dit in je SQL execute veld in bijv. phpMyAdmin)
CREATE TABLE php_banner_login (
id int(11) NOT NULL auto_increment,
loginnaam varchar(10) NOT NULL default '',
wachtwoord varchar(10) NOT NULL default '',
url varchar(200) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;
CREATE TABLE php_banner_out (
id int(11) NOT NULL auto_increment,
url varchar(200) NOT NULL default '',
out int(15) NOT NULL default '0',
views int(11) NOT NULL default '0',
datum varchar(20) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;
CREATE TABLE php_banner_rotation (
id int(11) NOT NULL auto_increment,
bid int(2) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;
CREATE TABLE php_banners (
id int(11) NOT NULL auto_increment,
url varchar(200) NOT NULL default '',
pic varchar(200) NOT NULL default '',
alt varchar(50) NOT NULL default '',
bid int(2) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;
Code:
//-/****************************************/-//
ZET DE VOLGENDE SCRIPTS IN EEN APPARTE
MAP, BIJVOORBEELD: WWW.DOMEIN.NL/BANNERSTATS/
//-/****************************************/-//
*********************databaseconnect.php**************************
<?
session_start();
$host = "localhost";
$user = "database user";
$pass = "database paswoord";
$dbdb = "database naam";
if (!@mysql_select_db($dbdb, @mysql_connect($host, $user, $pass)))
{
echo "<font face=\"Verdana, Arial, Helvetica\" size=\"2\">Sorry, er kon geen connectie worden gemaakt met de database.<p>";
echo "Probeer het a.u.b opnieuw. Blijft dit probleem zich voordoen, neemt u dan contact op met de webmaster.</font>";
exit();
}
$host = "";
$user = "";
$pass = "";
$dbdb = "";
?>
********************bannerinstellingen.php*******************
<?php
session_start();
// inlog check!! staat letterlijk, als er NIET een session bestaat met ** loginnaam,
// dus niet goed bent ingelogd, ga terug naar index.php!!
if (!$_SESSION['banid'])
{ header("location: index.php"); }
require("databaseconnect.php");
require("navigatie.php");
if ($_POST['submit'] && $_POST['alt'] && $_POST['url'])
{
if (!$_POST['confirm'])
{
echo "<b>Weet u zeker dat u de volgende wijzigingen wilt aanbrengen?</b><p>";
if (substr($url, 0, 7) != "http://")
$url = "http://" . $_POST['url'];
else
$url = $_POST['url'];
echo "<b>Url:</b>". $_POST['url']."<br>";
echo "<b>Alt:</b>". $_POST['alt']."<br>";
echo "<form method=\"post\" action=\"" . $_SERVER['PHP_SELF'] . "\">";
echo "<input type=\"hidden\" name=\"confirm\" value=\"1\">";
echo "<input type=\"hidden\" name=\"url\" value=\"$url\">";
echo "<input type=\"hidden\" name=\"alt\" value=\"$_POST[alt]\">";
echo "<input type=\"submit\" name=\"submit\" value=\"wijzigingen aanbrengen\"> | <a href=\"" . $_SERVER['PHP_SELF'] . "\">annuleren</a>";
echo "</form>";
}
elseif ($_POST['confirm'])
{
$sql = "UPDATE php_banners SET url = '" . $_POST['url']. "', alt = '" . $_POST['alt'] ."' WHERE url = '". $_POST['banurl'] ."' ";
$res = mysql_query($sql) or die(mysql_error());
$sql = "UPDATE php_banner_login SET url = '" . $_POST['url'] ."' WHERE id = '" . $_POST['banid'] ."' ";
$res = mysql_query($sql) or die(mysql_error());
$sql = "UPDATE php_banner_out SET url = '" .$_POST['url'] ."' WHERE url = '" . $_POST['banurl'] ."' ";
$res = mysql_query($sql) or die(mysql_error());
$sql = "SELECT url FROM php_banners WHERE url = '" . $_POST['url']."' ";
$res = mysql_query($sql) or die(mysql_error());
$banurl = mysql_result($res, 0);
session_unregister(banurl);
session_register(banurl);
echo "<script language=\"javascript\" type=\"text/javascript\">window.location='" . $_SERVER['PHP_SELF'] . "?edit=1'</script>";
}
}
else
{
if ($_POST['submit'])
echo "<span class=\"error\">U bent enkele velden vergeten in te vullen.</span><p>";
elseif ($edit)
echo "<span class=\"error\">Uw wijzigingen zijn aangebracht.</span><p>";
echo "De huidige gegevens zijn de standaard waardes in de invoer velden. Na op de 'wijzigen' knop ";
echo "te hebben geklikt zult u de nieuwe gegevens moeten bevestigen. Dit ter beveiliging.<p>";
$sql = "SELECT url,alt,pic FROM php_banners WHERE url = '" .$_SESSION['banurl'] ."' ";
$res = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($res);
if (substr($row['url'], 0, 7) != "http://")
$furl = "http://" . $row['url'];
else
$furl = $row['url'];
if (substr($row['pic'], 0, 7) != "http://")
$purl = "http://" . $row['pic'];
else
$purl = $row['pic'];
echo "<form method=\"post\" action=\"" . $_SERVER['PHP_SELF'] . "\">";
echo "<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" bordercolor=\"#000000\" bgcolor=\"#BBD4F1\"><tr><td>";
echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"5\">";
echo "<tr><td width=\"100\">Uw URL adres:</td><td><input type=\"text\" name=\"url\" value=\"$furl\" size=\"60\" maxlength=\"200\"></td></tr>";
echo "<tr><td width=\"100\">Uw alt tekst:</td><td><input type=\"text\" name=\"alt\" value=\"$row[alt]\" size=\"50\" maxlength=\"50\"></td></tr>";
echo "<tr><td> </td><td><input type=\"submit\" name=\"submit\" value=\"wijzigen\"></td></tr>";
echo "</table>";
echo "</td></tr></table>";
echo "</form><p>";
echo "<center><span class=\"small\">banner weergave</span><br>";
echo "<img src=\"$purl\" alt=\"$row[alt]\" border=\"1\" style=\"border-color: #000000\">";
echo "</center>";
}
?>
************************banners.php****************************
<?php
session_start();
// inlog check!! staat letterlijk, als er NIET een session bestaat met ** loginnaam,
// dus niet goed bent ingelogd, ga terug naar index.php!!
if (!$_SESSION['banid'])
{ header("location: index.php"); }
// maak db connectie (hoeft dus niet als je al 1 hebt)
$host = "";
$user = "";
$pass = "";
$dbdb = "";
if (!@mysql_select_db($dbdb, @mysql_connect($host, $user, $pass)))
{
echo "<font face=\"Verdana, Arial, Helvetica\" size=\"2\">Sorry, er kon geen connectie worden gemaakt met de database.<p>";
echo "Probeer het a.u.b opnieuw. Blijft dit probleem zich voordoen, neemt u dan contact op met de webmaster.</font>";
exit();
}
$host = "localhost";
$user = "";
$pass = "";
$dbdb = "";
$btable = "php_banners";
$btable2 = "php_banner_rotation";
$rsql = "SELECT bid FROM $btable2 WHERE id = 1";
$rres = mysql_query($rsql);
$row = mysql_fetch_array($rres);
if (mysql_num_rows($rres) >= 1)
$bid = $row[bid];
else
$bid = 1;
$sql = "SELECT id,url,pic,alt FROM $btable WHERE bid = '$bid' ";
$res = mysql_query($sql) or die(mysql_error());
if (mysql_num_rows($res) >= 1)
{
$total = mysql_num_rows($res);
$row = mysql_fetch_array($res);
if (substr($row['url'], 0, 7) != "http://")
$row['url'] = "http://" . $row['url'];
if (substr($row['pic'], 0, 7) != "http://")
$row['pic'] = "http://" . $row['pic'];
echo "<center><a href='http://www.lissydesign.info/bannerstats/out.php?url=".$row['url']."' target='_blank'><img src='".$row['pic']."' alt='".$row['alt']."' border=\"1\" style=\"border-color: #000000\"></a></center>";
$url = $row['url'];
}
$datum = date("d.m.Y");
$sql = "SELECT id FROM php_banner_out WHERE datum = '$datum' AND url = '$url'";
$res = mysql_query($sql) or die(mysql_error());
if (mysql_num_rows($res) >= 1)
$sql = "UPDATE php_banner_out SET views = views+1 WHERE datum = '$datum' AND url = '$url'";
else
$sql = "INSERT INTO php_banner_out (id, url, views, datum) VALUES ('', '$url', '1', '$datum')";
@mysql_query($sql);
$sql = "SELECT id FROM $btable";
$res = mysql_query($sql) or die(mysql_error());
$count = mysql_num_rows($res);
if ($bid == $count)
$bid = "0";
$sql = "UPDATE $btable2 SET bid = $bid+1";
@mysql_query($sql);
unset($sql);
unset($count);
unset($res);
unset($row);
unset($rres);
unset($rsql);
?>
**************************dagmaandoverzicht.php******************
<?php
session_start();
// inlog check!! staat letterlijk, als er NIET een session bestaat met ** id,
// dus niet goed bent ingelogd, ga terug naar index.php!!
if (!$_SESSION['banid'])
{ header("location: index.php"); }
require("databaseconnect.php");
require("navigatie.php");
function GetMonth($month)
{
if ($month == "01")
$month = "Januari";
elseif ($month == "02")
$month = "Februari";
elseif ($month == "03")
$month = "Maart";
elseif ($month == "04")
$month = "April";
elseif ($month == "05")
$month = "Mei";
elseif ($month == "06")
$month = "Juni";
elseif ($month == "07")
$month = "Juli";
elseif ($month == "08")
$month = "Augustus";
elseif ($month == "09")
$month = "September";
elseif ($month == "10")
$month = "Oktober";
elseif ($month == "11")
$month = "November";
elseif ($month == "12")
$month = "December";
return $month;
}
if ($_POST['submit'])
{
$seldd = $_POST['dd'];
$selmm = $_POST['mm'];
$selyy = $_POST['yy'];
}
else
{
$seldd = date("d");
$selmm = date("m");
$selyy = date("Y");
}
echo "<form method=\"post\" action=\"" . $_SERVER['PHP_SELF'] . "\">";
echo "<select name=\"dd\">";
for ($i = 1; $i <= 31; $i++)
{
if ($i < 10)
$dd = "0" . $i;
else
$dd = $i;
if ($seldd == $i)
echo "<option value=\"$dd\" selected>$dd</option>";
else
echo "<option value=\"$dd\">$dd</option>";
}
echo "</select> ";
echo "<select name=\"mm\">";
if ($selmm == "01")
echo "<option value=\"01\" selected>Jan</option>";
else
echo "<option value=\"01\">Jan</option>";
if ($selmm == "02")
echo "<option value=\"02\" selected>Feb</option>";
else
echo "<option value=\"02\">Feb</option>";
if ($selmm == "03")
echo "<option value=\"03\" selected>Mar</option>";
else
echo "<option value=\"03\">Mar</option>";
if ($selmm == "04")
echo "<option value=\"04\" selected>Apr</option>";
else
echo "<option value=\"04\">Apr</option>";
if ($selmm == "05")
echo "<option value=\"05\" selected>Mei</option>";
else
echo "<option value=\"05\">Mei</option>";
if ($selmm == "06")
echo "<option value=\"06\" selected>Jun</option>";
else
echo "<option value=\"06\">Jun</option>";
if ($selmm == "07")
echo "<option value=\"07\" selected>Jul</option>";
else
echo "<option value=\"07\">Jul</option>";
if ($selmm == "08")
echo "<option value=\"08\" selected>Aug</option>";
else
echo "<option value=\"08\">Aug</option>";
if ($selmm == "09")
echo "<option value=\"09\" selected>Sep</option>";
else
echo "<option value=\"09\">Sep</option>";
if ($selmm == "10")
echo "<option value=\"10\" selected>Okt</option>";
else
echo "<option value=\"10\">Okt</option>";
if ($selmm == "11")
echo "<option value=\"11\" selected>Nov</option>";
else
echo "<option value=\"11\">Nov</option>";
if ($selmm == "12")
echo "<option value=\"12\" selected>Dec</option>";
else
echo "<option value=\"12\">Dec</option>";
echo "</select> ";
$cyear = date("Y");
$firstyear = $cyear - 2;
echo "<select name=\"yy\">";
for ($i = $firstyear; $i <= $cyear; $i++)
{
if ($selyy == $i)
echo "<option value=\"$i\" selected>$i</option>";
else
echo "<option value=\"$i\">$i</option>";
}
echo "</select> ";
echo "<input type=\"submit\" name=\"submit\" value=\"toon datum\">";
echo "</form><P>";
if ($_POST["submit"])
{
$sqldd = $_POST['dd'];
$sqlmm = $_POST['mm'];
$sqlyy = $_POST['yy'];
$total = $sqldd . "." . $sqlmm . "." . $sqlyy;
}
else
$total = date("d.m.Y");
$sql = "SELECT out,views FROM php_banner_out WHERE url = '" . $_SESSION['banurl'] . "' AND datum = '" .$total . "' ";
$res = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($res);
$out = $row['out'];
$views = $row['views'];
if ($views == "")
{
$imgwidth = "1";
$views = "0";
}
else
{
$imgwidth = $views;
}
if ($imgwidth > 550)
$imgwidth = 550;
if ($out == "")
{
$imgwidth2 = "1";
$out = "0";
}
else
{
$imgwidth2 = $out;
}
if ($imgwidth2 > 550)
$imgwidth2 = 550;
echo "<b>Views</b> <span class=\"small\">$total</span><P>";
echo "<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" bordercolor=\"#000000\" width=\"100%\" bgcolor=\"#BBD4F1\"><tr><td>";
echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"5\">";
echo "<tr>";
echo "<td valign=\"top\"><p>Beneden ziet u de <i>views</i> van uw banner. Dit is dus hoe vaak uw banner bekeken is op <i>$total</i>.</p>";
echo "<span class=\"small\">totaal: $views <img src=\"imgs/stats.gif\" width=\"$imgwidth\" height=\"10\"></td>";
echo "</tr>";
echo "</table>";
echo "</td></tr></table><p>";
echo "<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" bordercolor=\"#000000\" width=\"100%\" bgcolor=\"#BBD4F1\"><tr><td>";
echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"5\">";
echo "<tr>";
echo "<td valign=\"top\"><p>Beneden ziet u de <i>kliks</i> van uw banner. Dit is dus hoe vaak er op uw banner geklikt is op <i>$total</i>.</p>";
echo "<span class=\"small\">totaal: $out <img src=\"imgs/stats.gif\" width=\"$imgwidth2\" height=\"10\"></td>";
echo "</tr>";
echo "</table>";
echo "</td></tr></table><p>";
if ($_POST['submit'])
{
$sqlmm = $_POST['mm'];
$sqlyy = $_POST['yy'];
$total = $sqlmm . "." . $sqlyy;
}
else
$total = date("m.Y");
$sql = "SELECT out,views FROM php_banner_out WHERE url = '" . $_SESSION['banurl'] . "' AND SUBSTRING(datum, 4, 9) = '" .$total . "' ";
//$sql = "SELECT out,views FROM php_banner_out WHERE url = '$_SESSION['banurl']' AND SUBSTRING(datum, 4, 9) = '$total'";
$res = mysql_query($sql) or die(mysql_error());
unset($out);
unset($views);
while ($row = mysql_fetch_array($res))
{
if (!$row['out'])
$row['out'] = "0";
if (!$row['views'])
$row['views'] = "0";
if (!$out)
$out = $row['out'];
else
$out = $out+$row['out'];
if (!$views)
$views = $row['views'];
else
$views = $views+$row['views'];
}
if ($views == "")
{
$imgwidth = "1";
$views = "0";
}
else
{
$imgwidth = $views;
}
if ($imgwidth > 550)
$imgwidth = 550;
if ($out == "")
{
$imgwidth2 = "1";
$out = "0";
}
else
{
$imgwidth2 = $out;
}
if ($imgwidth2 > 550)
$imgwidth2 = 550;
$total = substr($total, 0, 2);
$total = GetMonth($total);
echo "<b>Clicks</b> <span class=\"small\">$total</span><p>";
echo "<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" bordercolor=\"#000000\" width=\"100%\" bgcolor=\"#BBD4F1\"><tr><td>";
echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"5\">";
echo "<tr>";
echo "<td valign=\"top\"><p>Beneden ziet u de <i>views</i> van uw banner. Dit is dus hoe vaak uw banner is bekeken in de maand $total.</p>";
echo "<span class=\"small\">totaal: $views <img src=\"imgs/stats.gif\" width=\"$imgwidth\" height=\"10\"></td>";
echo "</tr>";
echo "</table>";
echo "</td></tr></table><p>";
echo "<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" bordercolor=\"#000000\" width=\"100%\" bgcolor=\"#BBD4F1\"><tr><td>";
echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"5\">";
echo "<tr>";
echo "<td valign=\"top\"><p>Beneden ziet u de <i>kliks</i> van uw banner. Dit is dus hoe vaak er op uw banner is geklikt in de maand $total.</p>";
echo "<span class=\"small\">totaal: $out <img src=\"imgs/stats.gif\" width=\"$imgwidth2\" height=\"10\"></td>";
echo "</tr>";
echo "</table>";
echo "</td></tr></table>";
?>
****************************maandoverzicht.php********************
<?php
session_start();
// inlog check!! staat letterlijk, als er NIET een session bestaat met ** id,
// dus niet goed bent ingelogd, ga terug naar index.php!!
if (!$_SESSION['banid'])
{ header("location: index.php"); }
require("databaseconnect.php");
require("navigatie.php");
if ($_POST['submit'])
{
$selmm = $_POST['mm'];
$selyy = $_POST['yy'];
}
else
{
$selmm = date("m");
$selyy = date("Y");
}
echo "<form method=\"post\" action=\"" . $_SERVER['PHP_SELF'] . "\">";
echo "<select name=\"mm\">";
if ($selmm == "01")
echo "<option value=\"01\" selected>Jan</option>";
else
echo "<option value=\"01\">Jan</option>";
if ($selmm == "02")
echo "<option value=\"02\" selected>Feb</option>";
else
echo "<option value=\"02\">Feb</option>";
if ($selmm == "03")
echo "<option value=\"03\" selected>Mar</option>";
else
echo "<option value=\"03\">Mar</option>";
if ($selmm == "04")
echo "<option value=\"04\" selected>Apr</option>";
else
echo "<option value=\"04\">Apr</option>";
if ($selmm == "05")
echo "<option value=\"05\" selected>Mei</option>";
else
echo "<option value=\"05\">Mei</option>";
if ($selmm == "06")
echo "<option value=\"06\" selected>Jun</option>";
else
echo "<option value=\"06\">Jun</option>";
if ($selmm == "07")
echo "<option value=\"07\" selected>Jul</option>";
else
echo "<option value=\"07\">Jul</option>";
if ($selmm == "08")
echo "<option value=\"08\" selected>Aug</option>";
else
echo "<option value=\"08\">Aug</option>";
if ($selmm == "09")
echo "<option value=\"09\" selected>Sep</option>";
else
echo "<option value=\"09\">Sep</option>";
if ($selmm == "10")
echo "<option value=\"10\" selected>Okt</option>";
else
echo "<option value=\"10\">Okt</option>";
if ($selmm == "11")
echo "<option value=\"11\" selected>Nov</option>";
else
echo "<option value=\"11\">Nov</option>";
if ($selmm == "12")
echo "<option value=\"12\" selected>Dec</option>";
else
echo "<option value=\"12\">Dec</option>";
echo "</select> ";
$cyear = date("Y");
$firstyear = $cyear - 2;
echo "<select name=\"yy\">";
for ($i = $firstyear; $i <= $cyear; $i++)
{
if ($selyy == $i)
echo "<option value=\"$i\" selected>$i</option>";
else
echo "<option value=\"$i\">$i</option>";
}
echo "</select> ";
echo "<input type=\"submit\" name=\"submit\" value=\"toon datum\">";
echo "</form><P>";
if ($_POST['submit'])
{
$sqlmm = $_POST['mm'];
$sqlyy = $_POST['yy'];
$total = $sqlmm . "." . $sqlyy;
}
else
$total = date("m.Y");
$sql = "SELECT out,views FROM php_banner_out WHERE url = '" . $_SESSION['banurl'] . "' AND SUBSTRING(datum, 4, 9) = '" .$total . "' ";
//$sql = "SELECT out,views FROM php_banner_out WHERE url = '$_SESSION['banurl']' AND SUBSTRING(datum, 4, 9) = '$total'";
$res = mysql_query($sql) or die(mysql_error());
unset($out);
unset($views);
while ($row = mysql_fetch_array($res))
{
if (!$row[out])
$row[out] = "0";
if (!$row[views])
$row[views] = "0";
if (!$out)
$out = $row[out];
else
$out = $out+$row[out];
if (!$views)
$views = $row[views];
else
$views = $views+$row[views];
}
if ($views == "")
{
$imgwidth = "1";
$views = "0";
}
else
{
$imgwidth = $views;
}
if ($imgwidth > 550)
$imgwidth = 550;
if ($out == "")
{
$imgwidth2 = "1";
$out = "0";
}
else
{
$imgwidth2 = $out;
}
if ($imgwidth2 > 550)
$imgwidth2 = 550;
echo "<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" bordercolor=\"#000000\" width=\"100%\" bgcolor=\"#BBD4F1\"><tr><td>";
echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"5\">";
echo "<tr>";
echo "<td valign=\"top\"><p>Beneden ziet u de <i>views</i> van uw banner. Dit is dus hoe vaak uw banner is bekeken in deze maand.</p>";
echo "<span class=\"small\">totaal: $views <img src=\"imgs/stats.gif\" width=\"$imgwidth\" height=\"10\"></td>";
echo "</tr>";
echo "</table>";
echo "</td></tr></table><p>";
echo "<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" bordercolor=\"#000000\" width=\"100%\" bgcolor=\"#BBD4F1\"><tr><td>";
echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"5\">";
echo "<tr>";
echo "<td valign=\"top\"><p>Beneden ziet u de <i>kliks</i> van uw banner. Dit is dus hoe vaak er op uw banner is geklikt in deze maand.</p>";
echo "<span class=\"small\">totaal: $out <img src=\"imgs/stats.gif\" width=\"$imgwidth2\" height=\"10\"></td>";
echo "</tr>";
echo "</table>";
echo "</td></tr></table>";
?>
****************************dagoverzicht.php***********************
<?php
session_start();
// inlog check!! staat letterlijk, als er NIET een session bestaat met ** id,
// dus niet goed bent ingelogd, ga terug naar index.php!!
if (!$_SESSION['banid'])
{ header("location: index.php"); }
require("databaseconnect.php");
require("navigatie.php");
if ($_POST['submit'])
{
$seldd = $_POST['dd'];
$selmm = $_POST['mm'];
$selyy = $_POST['yy'];
}
else
{
$seldd = date("d");
$selmm = date("m");
$selyy = date("Y");
}
echo "<form method=\"post\" action=\"" . $_SERVER['PHP_SELF'] . "\">";
echo "<select name=\"dd\">";
for ($i = 1; $i <= 31; $i++)
{
if ($i < 10)
$dd = "0" . $i;
else
$dd = $i;
if ($seldd == $i)
echo "<option value=\"$dd\" selected>$dd</option>";
else
echo "<option value=\"$dd\">$dd</option>";
}
echo "</select> ";
echo "<select name=\"mm\">";
if ($selmm == "01")
echo "<option value=\"01\" selected>Jan</option>";
else
echo "<option value=\"01\">Jan</option>";
if ($selmm == "02")
echo "<option value=\"02\" selected>Feb</option>";
else
echo "<option value=\"02\">Feb</option>";
if ($selmm == "03")
echo "<option value=\"03\" selected>Mar</option>";
else
echo "<option value=\"03\">Mar</option>";
if ($selmm == "04")
echo "<option value=\"04\" selected>Apr</option>";
else
echo "<option value=\"04\">Apr</option>";
if ($selmm == "05")
echo "<option value=\"05\" selected>Mei</option>";
else
echo "<option value=\"05\">Mei</option>";
if ($selmm == "06")
echo "<option value=\"06\" selected>Jun</option>";
else
echo "<option value=\"06\">Jun</option>";
if ($selmm == "07")
echo "<option value=\"07\" selected>Jul</option>";
else
echo "<option value=\"07\">Jul</option>";
if ($selmm == "08")
echo "<option value=\"08\" selected>Aug</option>";
else
echo "<option value=\"08\">Aug</option>";
if ($selmm == "09")
echo "<option value=\"09\" selected>Sep</option>";
else
echo "<option value=\"09\">Sep</option>";
if ($selmm == "10")
echo "<option value=\"10\" selected>Okt</option>";
else
echo "<option value=\"10\">Okt</option>";
if ($selmm == "11")
echo "<option value=\"11\" selected>Nov</option>";
else
echo "<option value=\"11\">Nov</option>";
if ($selmm == "12")
echo "<option value=\"12\" selected>Dec</option>";
else
echo "<option value=\"12\">Dec</option>";
echo "</select> ";
$cyear = date("Y");
$firstyear = $cyear - 2;
echo "<select name=\"yy\">";
for ($i = $firstyear; $i <= $cyear; $i++)
{
if ($selyy == $i)
echo "<option value=\"$i\" selected>$i</option>";
else
echo "<option value=\"$i\">$i</option>";
}
echo "</select> ";
echo "<input type=\"submit\" name=\"submit\" value=\"toon datum\">";
echo "</form><P>";
if ($_POST['submit'])
{
$sqldd = $_POST['dd'];
$sqlmm = $_POST['mm'];
$sqlyy = $_POST['yy'];
$total = $sqldd . "." . $sqlmm . "." . $sqlyy;
}
else
$total = date("d.m.Y");
$sql = "SELECT out,views FROM php_banner_out WHERE url = '" . $_SESSION['banurl'] . "' AND datum = '" .$total . "' ";
//$sql = "SELECT out,views FROM php_banner_out WHERE url = '$_SESSION['banurl']' AND datum = '$total' ";
$res = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($res);
$out = $row['out'];
$views = $row['views'];
if ($views == "")
{
$imgwidth = "1";
$views = "0";
}
else
{
$imgwidth = $views;
}
if ($imgwidth > 550)
$imgwidth = 550;
if ($out == "")
{
$imgwidth2 = "1";
$out = "0";
}
else
{
$imgwidth2 = $out;
}
if ($imgwidth2 > 550)
$imgwidth2 = 550;
echo "<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" bordercolor=\"#000000\" width=\"100%\" bgcolor=\"#BBD4F1\"><tr><td>";
echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"5\">";
echo "<tr>";
echo "<td valign=\"top\"><p>Beneden ziet u de <i>views</i> van uw banner. Dit is dus hoe vaak uw banner is bekeken.</p>";
echo "<span class=\"small\">totaal: $views <img src=\"imgs/stats.gif\" width=\"$imgwidth\" height=\"10\"></td>";
echo "</tr>";
echo "</table>";
echo "</td></tr></table><p>";
echo "<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" bordercolor=\"#000000\" width=\"100%\" bgcolor=\"#BBD4F1\"><tr><td>";
echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"5\">";
echo "<tr>";
echo "<td valign=\"top\"><p>Beneden ziet u de <i>kliks</i> van uw banner. Dit is dus hoe vaak er op uw banner is geklikt.</p>";
echo "<span class=\"small\">totaal: $out <img src=\"imgs/stats.gif\" width=\"$imgwidth2\" height=\"10\"></td>";
echo "</tr>";
echo "</table>";
echo "</td></tr></table>";
?>
****************************index.php**************************
[code]
<?php
session_start();
// maak db connectie (hoeft dus niet als je al 1 hebt)
$host = "";
$user = "";
$pass = "";
$dbdb = "";
if (!@mysql_select_db($dbdb, @mysql_connect($host, $user, $pass)))
{
echo "<font face=\"Verdana, Arial, Helvetica\" size=\"2\">Sorry, er kon geen connectie worden gemaakt met de database.<p>";
echo "Probeer het a.u.b opnieuw. Blijft dit probleem zich voordoen, neemt u dan contact op met de webmaster.</font>";
exit();
}
if ($_POST['loginnaam'] && $_POST['wachtwoord'])
{
$sql = "SELECT id,url FROM php_banner_login WHERE loginnaam = '".$_POST['loginnaam']."' AND wachtwoord = '".$_POST['wachtwoord']."'";
$res = mysql_query($sql) or die(mysql_error());
if (mysql_num_rows($res) >= 1)
{
$row = mysql_fetch_array($res);
$_SESSION['banid'] = $row['id'];
$_SESSION['banurl'] = $row['url'];
echo "<script language=\"javascript\" type=\"text/javascript\">window.location='" . $_SERVER['PHP_SELF'] . "'</script>";
}
else
{
echo "<script language=\"javascript\" type=\"text/javascript\">window.location='" . $_SERVER['PHP_SELF'] . "?err=1'</script>";
}
}
elseif ($_SESSION['banid'])
{
require("navigatie.php");
echo "U bent reeds ingelogd.<p>";
echo "De navigatie kunt u aan de bovenkant van de pagina vinden.";
}
else
{
if($_GET['err'])
echo "<p class=\"error\">U heeft een ongeldige login naam of wachtwoord ingevoerd. Probeer het opnieuw.</p>";
?>
<p>Welkom bij de banner statistieken. Hier kunt u uw
banner statistieken tot op de dag volgen.</p>
<p>Om in te loggen moet u uw login naam en wachtwoord die u van ons
heeft gekregen, in onderstaande velden invullen. Mocht u nog vragen
hebben of bent u uw login gegevens kwijt, neem dan contact met ons
op. Voor een snel antwoord kunt u mailen naar <a href="mailto:[email protected]">[email protected]</a>.</p>
<form name="form1" method="post" action="">
<table width="243" border="0" cellspacing="0" cellpadding="0">
<tr valign="top" align="left">
<td width="93">login naam</td>
<td width="166">
<input type="text" name="loginnaam" size="10" maxlength="10">
</td>
</tr>
<tr valign="top" align="left">
<td width="93">wachtwoord</td>
<td width="166">
<input type="password" name="wachtwoord" size="10" maxlength="10">
</td>
</tr>
<tr valign="top" align="left">
<td width="93"> </td>
<td width="166">
<input type="submit" name="submit" value="inloggen">
</td>
</tr>
</table>
</form>
<p> </p>
<?php
}
?>
[/code]
***************************navigatie.php************************
<?php
echo "<a href=\"dagoverzicht.php\" target=\"_top\">dag overzicht</a>";
echo " | ";
echo "<a href=\"maandoverzicht.php\" target=\"_top\">maand overzicht</a>";
echo " | ";
echo "<a href=\"dagmaandoverzicht.php\" target=\"_top\">dag/maand overzicht</a>";
echo " | ";
echo "<a href=\"bannerinstellingen.php\" target=\"_top\">banner instellingen</a>";
echo " | ";
echo "<a href=\"uitloggen.php\" target=\"_top\">uitloggen</a>";
?>
***************************out.php******************************
<?php
if ($_GET['url'])
{
// maak db connectie (hoeft dus niet als je al 1 hebt)
$host = "";
$user = "";
$pass = "";
$dbdb = "";
if (!@mysql_select_db($dbdb, @mysql_connect($host, $user, $pass)))
{
echo "<font face=\"Verdana, Arial, Helvetica\" size=\"2\">Sorry, er kon geen connectie worden gemaakt met de database.<p>";
echo "Probeer het a.u.b opnieuw. Blijft dit probleem zich voordoen, neemt u dan contact op met de webmaster.</font>";
exit();
}
$host = "";
$user = "";
$pass = "";
$dbdb = "";
$sql = "UPDATE php_banner_out SET out=out+1 WHERE url = '" . $_GET['url'] . "' ";
mysql_query($sql) or die(mysql_error());
//header("Location: $url");
header("Location: ". $_GET['url']);
}
?>
*****************************uitloggen.php************************
<?php
session_start();
session_destroy();
echo "u bent uitgelogd, klik <a href=\"http://www.lissydesign.info/\">hier</a> om verder te gaan.";
?>
Reacties
0