Scripts
Banner systeem
MySQL tabellen: (copy/paste dit in je SQL execute veld) 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; 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 (MET http://) 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%!!!! Gebruik het zelf ook voor PHPhulp.nl..
banner-systeem
//-/****************************************/-//
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 = "";
?>
-------- sessiecheck.php --------
<?
if (!$HTTP_SESSION_VARS["banid"])
{
echo "U heeft niet de juiste rechten om deze pagina te bekijken.<p>";
echo "Om uw banner statistieken te bekijken moet u <a href=\"index.php\">inloggen</a>.";
exit();
}
?>
------- navigatie.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>";
?>
----- dagmaandoverzicht.php ----------
<?
session_start();
require("databaseconnect.php");
require("sessioncheck.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 ($HTTP_POST_VARS["submit"])
{
$seldd = $HTTP_POST_VARS[dd];
$selmm = $HTTP_POST_VARS[mm];
$selyy = $HTTP_POST_VARS[yy];
}
else
{
$seldd = date("d");
$selmm = date("m");
$selyy = date("Y");
}
echo "<form method=\"post\" action=\"$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 ($HTTP_POST_VARS["submit"])
{
$sqldd = $HTTP_POST_VARS[dd];
$sqlmm = $HTTP_POST_VARS[mm];
$sqlyy = $HTTP_POST_VARS[yy];
$total = $sqldd . "." . $sqlmm . "." . $sqlyy;
}
else
$total = date("d.m.Y");
$sql = "SELECT out,views FROM php_banner_out WHERE url = '$HTTP_SESSION_VARS[banurl]' AND datum = '$total'";
$res = mysql_query($sql);
$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 ($HTTP_POST_VARS["submit"])
{
$sqlmm = $HTTP_POST_VARS[mm];
$sqlyy = $HTTP_POST_VARS[yy];
$total = $sqlmm . "." . $sqlyy;
}
else
$total = date("m.Y");
$sql = "SELECT out,views FROM php_banner_out WHERE url = '$HTTP_SESSION_VARS[banurl]' AND SUBSTRING(datum, 4, 9) = '$total'";
$res = mysql_query($sql);
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>";
?>
-------- dagoverzicht.php -------
<?
session_start();
require("databaseconnect.php");
require("sessioncheck.php");
require("navigatie.php");
if ($HTTP_POST_VARS["submit"])
{
$seldd = $HTTP_POST_VARS[dd];
$selmm = $HTTP_POST_VARS[mm];
$selyy = $HTTP_POST_VARS[yy];
}
else
{
$seldd = date("d");
$selmm = date("m");
$selyy = date("Y");
}
echo "<form method=\"post\" action=\"$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 ($HTTP_POST_VARS["submit"])
{
$sqldd = $HTTP_POST_VARS[dd];
$sqlmm = $HTTP_POST_VARS[mm];
$sqlyy = $HTTP_POST_VARS[yy];
$total = $sqldd . "." . $sqlmm . "." . $sqlyy;
}
else
$total = date("d.m.Y");
$sql = "SELECT out,views FROM php_banner_out WHERE url = '$HTTP_SESSION_VARS[banurl]' AND datum = '$total'";
$res = mysql_query($sql);
$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>";
?>
------ maandoverzicht.php --------
<?
session_start();
require("databaseconnect.php");
require("sessioncheck.php");
require("navigatie.php");
if ($HTTP_POST_VARS["submit"])
{
$selmm = $HTTP_POST_VARS[mm];
$selyy = $HTTP_POST_VARS[yy];
}
else
{
$selmm = date("m");
$selyy = date("Y");
}
echo "<form method=\"post\" action=\"$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 ($HTTP_POST_VARS["submit"])
{
$sqlmm = $HTTP_POST_VARS[mm];
$sqlyy = $HTTP_POST_VARS[yy];
$total = $sqlmm . "." . $sqlyy;
}
else
$total = date("m.Y");
$sql = "SELECT out,views FROM php_banner_out WHERE url = '$HTTP_SESSION_VARS[banurl]' AND SUBSTRING(datum, 4, 9) = '$total'";
$res = mysql_query($sql);
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>";
?>
------ bannerinstellingen.php ---------
<?
session_start();
require("databaseconnect.php");
require("sessioncheck.php");
require("navigatie.php");
if ($HTTP_POST_VARS["submit"] && $HTTP_POST_VARS["alt"] && $HTTP_POST_VARS["url"])
{
if (!$HTTP_POST_VARS["confirm"])
{
echo "<b>Weet u zeker dat u de volgende wijzigingen wilt aanbrengen?</b><p>";
if (substr($url, 0, 7) != "http://")
$url = "http://" . "$HTTP_POST_VARS[url]";
else
$url = "$HTTP_POST_VARS[url]";
echo "<b>Url:</b> $HTTP_POST_VARS[url]<br>";
echo "<b>Alt:</b> $HTTP_POST_VARS[alt]<br>";
echo "<form method=\"post\" action=\"$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=\"$HTTP_POST_VARS[alt]\">";
echo "<input type=\"submit\" name=\"submit\" value=\"wijzigingen aanbrengen\"> | <a href=\"$PHP_SELF\">annuleren</a>";
echo "</form>";
}
elseif ($HTTP_POST_VARS["confirm"])
{
$sql = "UPDATE php_banners SET url = '$HTTP_POST_VARS[url]', alt = '$HTTP_POST_VARS[alt]' WHERE url = '$HTTP_SESSION_VARS[banurl]'";
$res = mysql_query($sql);
$sql = "UPDATE php_banner_login SET url = '$HTTP_POST_VARS[url]' WHERE id = '$HTTP_SESSION_VARS[banid]'";
$res = mysql_query($sql);
$sql = "UPDATE php_banner_out SET url = '$HTTP_POST_VARS[url]' WHERE url = '$HTTP_SESSION_VARS[banurl]'";
$res = mysql_query($sql);
$sql = "SELECT url FROM php_banners WHERE url = '$HTTP_POST_VARS[url]'";
$res = mysql_query($sql);
$banurl = mysql_result($res, 0);
session_unregister("banurl");
session_register(banurl);
echo "<script language=\"javascript\" type=\"text/javascript\">window.location='$PHP_SELF?edit=1'</script>";
}
}
else
{
if ($HTTP_POST_VARS["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>";
//echo "<span class=\"error\">Onthoud!</span> Als u uw url adres wijzigt vervallen de statistieken en zullen er nieuwe statistieken worden aangemaakt. Als u uw 'oude' url adres vervolgens weer terug zet heeft u uw oude statistieken weer.<p>";
$sql = "SELECT url,alt,pic FROM php_banners WHERE url = '$HTTP_SESSION_VARS[banurl]'";
$res = mysql_query($sql);
$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=\"$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>";
}
?>
----------- index.php -------------
<?
session_start();
if ($HTTP_POST_VARS["loginnaam"] && $HTTP_POST_VARS["wachtwoord"])
{
$sql = "SELECT id,url FROM php_banner_login WHERE loginnaam = '$HTTP_POST_VARS[loginnaam]' AND wachtwoord = '$HTTP_POST_VARS[wachtwoord]'";
$res = mysql_query($sql);
if (mysql_num_rows($res) >= 1)
{
$row = mysql_fetch_array($res);
$banid = $row[id];
$banurl = $row[url];
session_register(banid);
session_register(banurl);
echo "<script language=\"javascript\" type=\"text/javascript\">window.location='$PHP_SELF'</script>";
}
else
{
echo "<script language=\"javascript\" type=\"text/javascript\">window.location='$PHP_SELF?err=1'</script>";
}
}
elseif ($HTTP_SESSION_VARS["banid"])
{
require("navigatie.php");
echo "U bent reeds ingelogd.<p>";
echo "De navigatie kunt u aan de bovenkant van de pagina vinden.";
}
else
{
if ($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>
<?
}
?>
//-/****************************************/-//
GEBRUIKT DIT VOOR OP JE PAGINA
//-/****************************************/-//
-------- banners.php ---------
<?
// maak db connectie (hoeft dus niet als je al 1 hebt)
$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 = "";
$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);
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 "<a href=\"http://www.phphulp.nl/out.php?url=$row[url]\" target=\"_blank\"><img src=\"$row[pic]\" alt=\"$row[alt]\" border=\"1\" style=\"border-color: #000000\"></a><p>";
$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);
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);
$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);
?>
-------- out.php -----------
<?
if ($HTTP_GET_VARS["url"])
{
// maak db connectie (hoeft dus niet als je al 1 hebt)
$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 = "";
$sql = "UPDATE php_banner_out SET out=out+1 WHERE url = '$HTTP_GET_VARS[url]'";
mysql_query($sql);
header("Location: $url");
}
?>
Reacties
0