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>
 
<?
}
?>

INSERT INTO `lijst` VALUES (1, '', '50a5f719608b34cfb4e9ad4105b9694e', 'hiernaamdeelnemer1');