php-code Kerstlijst
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');







