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
|