| 4. kerstlijst.php---------------
 <?php
 $con= mysql_connect(localhost,gebruikersnaam,gebruikerspass) or die ("fout"); $db = mysql_select_db(tribuun_agbook1,$con) or die ("fout");
 $time=time();   $invoer = array($_POST['een'],$_POST['twee'],$_POST['drie'],$_POST['vier'],$_POST['vijf']);if ($_COOKIE['pass'])
 {
 if (!$_POST[een])
 {$lijst = false;}
 else
 {
 for($x=0; $x<5; $x++){
 if ($invoer[$x])
 {
 $sql = "INSERT INTO lijst (naam, voorstel) VALUES ('$_COOKIE[user]', '$invoer[$x]')";
 mysql_query($sql) or die(mysql_error());
 }
 }
 ?>
 <div align="center">
 <table width="80%" cellspacing="9" cellpadding="0" bordercolor="#A6A393" bordercolorlight="#A6A393" bordercolordark="#A6A393">
 <tr>
 <td style="border-left-style:none; border-left-width:medium; border-right-style:none; border-right-width:medium; border-top-style:none; border-top-width:medium; border-bottom-style:solid; border-bottom-width:1px" colspan="5">
 <p align="left"> </td>
 <td style="border-style:none; border-width:medium; "> </td>
 <td style="border-style:none; border-width:medium; " width="76" valign="top">
 </td>
 </tr>
 <tr>
 <td width="69%" height="10" align="right" valign="top" colspan="4">
 <dl>
 <div align="right">
 <dt><b>
 <font size="4" face="Arial" color="#828268">
 Vrolijk     </font></b></dt>
 </div>
 <div align="right">
 <dt><b>
 <font size="4" face="Arial" color="#828268">
 Kerstfeest
 </font></b></dt>
 </div>
 </dl>
 </td>
 <td style="border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; " colspan="2" height="20" valign="bottom" width="15%" rowspan="2">
 <p align="right"><b>
 <font face="Arial" size="2" color="#000080">TRIBUUN</font><font face="Arial" size="2" color="#993300">
 </font></b></td>
 <td style="border-right-style:none; border-right-width:medium; border-top-style:none; border-top-width:medium; " height="20" width="76" align="center" rowspan="2">
 <a style="color: black; font-family: verdana; font-size: 8pt; text-decoration: none">
 <img height="75" alt="Kerstmiswensen" src="css/wishes.gif" width="110" border="2"></a></td>
 </tr>
 <tr>
 <td width="73%" height="10" align="left" valign="top" colspan="4">
 <address align="left">
 <font face="Arial" size="2">
 <?echo $_COOKIE['user'] ?> het volgende werd aan je lijst toegevoegd :<br>
 <hr size="1">
 <?
 for($x=0; $x<5; $x++)
 {
 if ($invoer[$x])
 {echo $invoer[$x]."<br>";}
 }
 ?>
 </font></address>
 </td>
 </tr>
 <tr>
 <td style="border-style:none; border-width:medium; " width="10%" align="left">
 </td>
 <td width="25%">
 </td>
 <td style="border-style:none; border-width:medium; " width="17%">
 <p align="center">
 </td>
 <td style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: solid; border-bottom-width: 1px" width="21%">
 <div align="right">
 <a href="login.php"><font face="Arial" size="2">Nieuw Toevoegen</font>
 </a>
 </div>
 </td>
 <td style="border-left-style:none; border-left-width:medium; border-right-style:solid; border-right-width:1px; border-top-style:solid; border-top-width:1px; border-bottom-style:solid; border-bottom-width:1px" width="6%" bgcolor="#F7F7F5"> </td>
 <td style="border-style: solid; border-width: 1px; " bgcolor="#F7F7F5" width="3%"> </td>
 <td style="border-left-style:solid; border-left-width:1px; border-right-style:none; border-right-width:medium; border-top-style:solid; border-top-width:1px; border-bottom-style:solid; border-bottom-width:1px" bgcolor="#F7F7F5" width="75"> </td>
 </tr>
 <tr>
 <td style="border-style:none; border-width:medium; " width="10%" height="21"> </td>
 <td style="border-style:none; border-width:medium; " width="25%" height="21">
 <font size="2" face="Arial"> </font></td>
 <td style="border-style:none; border-width:medium; " width="17%" height="21"> </td>
 <td style="border-left: medium none #89868A; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px" width="20%" bgcolor="#F7F7F5" height="21">
 <p align="right">
 <font face="Arial" size="2"><a href="kerstlijst.php">Lijst inkijken</a> </font>
 </td>
 <td style="border-style:solid; border-width:1px; " width="6%" valign="bottom" bgcolor="#F7F7F5" height="21">
 <font face="Arial" size="2"> </font></td>
 <td style="border-style:solid; border-width:1px; " bgcolor="#F7F7F5" width="3%" height="21"> </td>
 <td style="border-left-style: solid; border-left-width: 1px; border-top-style: solid; border-top-width: 1px" bgcolor="#F7F7F5" width="75" height="21"> </td>
 </tr>
 <tr>
 <td style="border-style:none; border-width:medium; " colspan="7">
 <p align="right">
 <font face="Arial Narrow" size="1" color="#993300">
 <a href="#Websiteinformatie" style="text-decoration: none">Websiteinfo</a>
 Webzuilpublicatie : pw-electropost</font></td>
 </tr>
 </table>
 </div>
 
 
 <?
 $lijst = true;
 }
 }
 else
 {
 $login_error= true;
 }
 //}
 
 if ($login_error == true)
 {
 ?> <div align="center">
 <table width="80%" cellspacing="9" cellpadding="0" bordercolor="#A6A393" bordercolorlight="#A6A393" bordercolordark="#A6A393">
 <tr>
 <td style="border-left-style:none; border-left-width:medium; border-right-style:none; border-right-width:medium; border-top-style:none; border-top-width:medium; border-bottom-style:solid; border-bottom-width:1px" colspan="5">
 <p align="left"> </td>
 <td style="border-style:none; border-width:medium; "> </td>
 <td style="border-style:none; border-width:medium; " width="76" valign="top">
 </td>
 </tr>
 <tr>
 <td width="69%" height="10" align="right" valign="top" colspan="4">
 <dl>
 <div align="right">
 <dt><b>
 <font size="4" face="Arial" color="#828268">
 Vrolijk     </font></b></dt>
 </div>
 <div align="right">
 <dt><b>
 <font size="4" face="Arial" color="#828268">
 Kerstfeest
 </font></b></dt>
 </div>
 </dl>
 </td>
 <td style="border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; " colspan="2" height="20" valign="bottom" width="15%" rowspan="2">
 <p align="right"><b>
 <font face="Arial" size="2" color="#000080">TRIBUUN</font><font face="Arial" size="2" color="#993300">
 </font></b></td>
 <td style="border-right-style:none; border-right-width:medium; border-top-style:none; border-top-width:medium; " height="20" width="76" align="center" rowspan="2">
 <a style="color: black; font-family: verdana; font-size: 8pt; text-decoration: none">
 <img height="75" alt="Kerstmiswensen" src="css/wishes.gif" width="110" border="2"></a></td>
 </tr>
 <tr>
 <td width="73%" height="10" align="left" valign="top" colspan="4">
 <address align="left"><font size="2" face="Arial">De gebruikersnaam met dit wachtwoord is
 niet geregistreerd.</font></address>
 <address align="left"><font face="Arial" size="2">De inlogprocedure
 wordt hier afgesloten.</font></address>
 </td>
 </tr>
 <tr>
 <td style="border-style:none; border-width:medium; " width="10%" align="left">
 </td>
 <td width="25%">
 </td>
 <td style="border-style:none; border-width:medium; " width="17%">
 <p align="center">
 </td>
 <td style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: solid; border-bottom-width: 1px" width="21%">
 <div align="right">
 <font face="Arial" size="2"><a href="index.php">Inloggen</a></font>
 </div>
 </td>
 <td style="border-left-style:none; border-left-width:medium; border-right-style:solid; border-right-width:1px; border-top-style:solid; border-top-width:1px; border-bottom-style:solid; border-bottom-width:1px" width="6%" bgcolor="#F7F7F5"> </td>
 <td style="border-style: solid; border-width: 1px; " bgcolor="#F7F7F5" width="3%"> </td>
 <td style="border-left-style:solid; border-left-width:1px; border-right-style:none; border-right-width:medium; border-top-style:solid; border-top-width:1px; border-bottom-style:solid; border-bottom-width:1px" bgcolor="#F7F7F5" width="75"> </td>
 </tr>
 <tr>
 <td style="border-style:none; border-width:medium; " width="10%" height="21"> </td>
 <td style="border-style:none; border-width:medium; " width="25%" height="21">
 <font size="2" face="Arial"> </font></td>
 <td style="border-style:none; border-width:medium; " width="17%" height="21"> </td>
 <td style="border-left: medium none #89868A; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px" width="20%" bgcolor="#F7F7F5" height="21">
 <p align="right">
 <font face="Arial" size="2"><a href="kerstlijst.php">Lijst inkijken</a> </font>
 </td>
 <td style="border-style:solid; border-width:1px; " width="6%" valign="bottom" bgcolor="#F7F7F5" height="21">
 <font face="Arial" size="2"> </font></td>
 <td style="border-style:solid; border-width:1px; " bgcolor="#F7F7F5" width="3%" height="21"> </td>
 <td style="border-left-style: solid; border-left-width: 1px; border-top-style: solid; border-top-width: 1px" bgcolor="#F7F7F5" width="75" height="21"> </td>
 </tr>
 <tr>
 <td style="border-style:none; border-width:medium; " colspan="7">
 <p align="right">
 <font face="Arial Narrow" size="1" color="#993300">
 <a href="#Websiteinformatie" style="text-decoration: none">Websiteinfo</a>
 Webzuilpublicatie : pw-electropost</font></td>
 </tr>
 </table>
 </div>
 <?
 }
 else if ($lijst == true)
 {echo "maaklijst";}
 else {
 ?>
 
 <form action="kerstform.php" method="post">
 <div align="center">
 <table width="80%" cellspacing="9" cellpadding="0" bordercolor="#A6A393" bordercolorlight="#A6A393" bordercolordark="#A6A393" style="border-right-width: 0px; border-top-width: 0px">
 <tr>
 <td style="border-left-style:none; border-left-width:medium; border-right-style:none; border-right-width:medium; border-top-style:none; border-top-width:medium; border-bottom-style:solid; border-bottom-width:1px" colspan="5">
 <p align="right"><font color="#FF0000" face="Arial" size="1">
 Minimum : 1 voorstel voor een geldige registratie [bovenste invoervak ]</font></td>
 <td style="border-style:none; border-width:medium; "> </td>
 <td style="border-style:none; border-width:medium; " width="76" valign="top">
 </td>
 </tr>
 <tr>
 <td width="69%" height="10" align="right" valign="top" colspan="4">
 <dl>
 <div align="right">
 <dt><b><font face="Arial" size="4" color="#828268">Geschenkenlijst
 </font></b></dt>
 </div>
 <div align="right">
 <dt><b><font face="Arial" size="4" color="#828268">Aanvullen -
 Inkijken
 </font></b></dt>
 </div>
 </dl>
 </td>
 <td style="border-left-style: none; border-left-width: medium; border-right-style: solid; border-right-width: 1px; border-top-style: none; border-top-width: medium; " colspan="2" valign="bottom" width="15%" rowspan="6">
 <p align="right"><b>
 <font face="Arial" size="2" color="#000080">TRIBUUN</font><font face="Arial" size="2" color="#993300">
 </font></b></td>
 <td style="border-right-style:none; border-right-width:medium; border-top-style:none; border-top-width:medium; border-bottom-style:none; border-bottom-width:medium" width="76" align="center" rowspan="6" valign="bottom">
 <font color="#000000">
 <a style="font-size: 8pt; color: black; font-family: verdana; text-decoration: none">
 <img height="75" alt="Kerstmiswensen" src="css/carol.gif" width="112" border="3"></a></font></td>
 </tr>
 <tr>
 <td style="border:1px solid #808080; " width="10%" height="10" align="left" valign="top" bgcolor="#F7F7F5">
 <font face="Arial" size="2">Naam</font></td>
 <td width="27%" height="10" align="right" valign="top">
 <p align="left">
 <? echo $GLOBALS['kerstkonijn'] ?></td>
 <td style="border-right-style:none; border-right-width:medium; border-bottom-style:none; border-bottom-width:medium" width="11%" height="10" align="right" valign="top">
 </td>
 <td style="border-style:none; border-width:medium; " width="21%" height="10" align="right" valign="top">
 </td>
 </tr>
 <tr>
 <td style="border-style:none; border-width:medium; " width="10%" align="left">
 <font face="Arial" size="2">Voorstel</font></td>
 <td width="27%">
 <input type=text name="een" value="" size="26" style="border: 1px solid #C0C0C0"></td>
 <td style="border-style:none; border-width:medium; " width="11%">
 </td>
 <td style="border-style:none; border-width:medium; " width="21%">
 </td>
 </tr>
 <tr>
 <td style="border-style:none; border-width:medium; " width="10%" align="left">
 <font face="Arial" size="2">Voorstel</font></td>
 <td width="27%">
 <input type=text name="twee"  size="26" style="border: 1px solid #C0C0C0"></td>
 <td style="border-style:none; border-width:medium; " width="11%">
 </td>
 <td style="border-style:none; border-width:medium; " width="21%">
 </td>
 </tr>
 <tr>
 <td style="border-style:none; border-width:medium; " width="10%" align="left">
 <font face="Arial" size="2">Voorstel</font></td>
 <td width="27%">
 <input type=text name=drie  size="26" style="border: 1px solid #C0C0C0"></td>
 <td style="border-style:none; border-width:medium; " width="11%">
 </td>
 <td style="border-style:none; border-width:medium; " width="21%">
 </td>
 </tr>
 <tr>
 <td style="border-style:none; border-width:medium; " width="10%" align="left">
 <font face="Arial" size="2">Voorstel</font></td>
 <td width="27%">
 <input type=text name=vier  size="26" style="border: 1px solid #C0C0C0"></td>
 <td style="border-style:none; border-width:medium; " width="11%">
 </td>
 <td style="border-style:none; border-width:medium; " width="21%">
 </td>
 </tr>
 <tr>
 <td style="border-style:none; border-width:medium; " width="10%" align="left">
 <font face="Arial" size="2">Voorstel</font></td>
 <td width="27%">
 <input type=text name=vijf  size="26" style="border: 1px solid #C0C0C0"></td>
 <td style="border-style:none; border-width:medium; " width="11%">
 <p align="center">
 <input type="submit" value="Toevoegen" name="voorstellen" style="background-color:#F7F7F5 ; width: 80; height: 21; float: left; border: 1px solid #858A91">
 </td>
 <td style="border-left-style: none; border-left-width: medium; border-right-style: none; border-right-width: medium; border-top-style: none; border-top-width: medium; border-bottom-style: solid; border-bottom-width: 1px" width="21%">
 <p align="left"><font face="Arial" size="2"> </font><div align="right">
 <font face="Arial" size="2"><a href="index.php">Inloggen</a></font>
 </div>
 </td>
 <td style="border-left-style:none; border-left-width:medium; border-right-style:solid; border-right-width:1px; border-top-style:solid; border-top-width:1px; border-bottom-style:solid; border-bottom-width:1px" width="6%" bgcolor="#F7F7F5"> </td>
 <td style="border-style: solid; border-width: 1px; " bgcolor="#F7F7F5" width="3%"> </td>
 <td style="border-left-style:solid; border-left-width:1px; border-right-style:none; border-right-width:medium; border-top-style:solid; border-top-width:1px; border-bottom-style:solid; border-bottom-width:1px" bgcolor="#F7F7F5" width="75"> </td>
 </tr>
 <tr>
 <td style="border-style:none; border-width:medium; " width="10%" height="21"> </td>
 <td style="border-style:none; border-width:medium; " width="27%" height="21">
 <font size="2" face="Arial"> </font></td>
 <td style="border-style:none; border-width:medium; " width="11%" height="21">
 <input type="reset" value="Herstel" name="B2" style="background-color:#F7F7F5 ; width: 80; height: 21; float: left; border: 1px solid #858A91"></td>
 <td style="border-left: medium none #89868A; border-right-style: solid; border-right-width: 1px; border-top-style: solid; border-top-width: 1px; border-bottom-style: solid; border-bottom-width: 1px" width="20%" bgcolor="#F7F7F5" height="21">
 <p align="right">
 <font face="Arial" size="2"><a href="kerstlijst.php">Lijst inkijken</a> </font>
 </td>
 <td style="border-style:solid; border-width:1px; " width="6%" valign="bottom" bgcolor="#F7F7F5" height="21">
 <font face="Arial" size="2"> </font></td>
 <td style="border-style:solid; border-width:1px; " bgcolor="#F7F7F5" width="3%" height="21"> </td>
 <td style="border-left-style: solid; border-left-width: 1px; border-top-style: solid; border-top-width: 1px" bgcolor="#F7F7F5" width="75" height="21"> </td>
 </tr>
 <tr>
 <td style="border-style:none; border-width:medium; " colspan="7">
 <p align="right">
 <font face="Arial Narrow" size="1" color="#993300">
 <a href="#Websiteinformatie" style="text-decoration: none">Websiteinfo</a>
 Webzuilpublicatie : pw-electropost</font></td>
 </tr>
 </table>
 </div>
 </form>
 
 <?
 }
 ?>
 SQL voor de aanmaak van de database:
 --------------------------------------
 -- phpMyAdmin SQL Dump-- version 2.6.1-pl3
 -- http://www.phpmyadmin.net
 --
 -- Host: localhost
 -- Generatie Tijd: 25 Nov 2005 om 01:37
 -- Server versie: 4.1.10
 -- PHP Versie: 5.0.3
 --
 -- Database: `tribuun_agbook1`
 --
 -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `lijst`
 --
 CREATE TABLE `lijst` (`id` int(11) NOT NULL auto_increment,
 `voorstel` tinytext NOT NULL,
 `mode` varchar(50) NOT NULL default '',
 `naam` varchar(50) NOT NULL default '',
 PRIMARY KEY  (`id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;
 -- -- Gegevens worden uitgevoerd voor tabel `lijst`
 --
 INSERT INTO `lijst` VALUES (1, '', '50a5f719608b34cfb4e9ad4105b9694e', 'hiernaamdeelnemer1');
  25-11-2005 om 02:00 geschreven door de makers
 |