----------database.php----------
<?php
$hostname = "localhost"; 
$username = "usernaam"; 
$password = "pass"; 
$db = "database"; 

$fout = "Er kan geen database connectie gemaakt worden..<br>Probeer het na enkele minuten opnieuw. Wil het dan nog niet, neem dan contact met mij op."; 

mysql_connect($hostname,$username,$password); 

mysql_select_db($db) or die ($fout);

?>

----------fuiven.php----------
<? 
include_once "database.php";

if($_GET['mode'] == "toevoegen")
	{ 
	if($_POST['Invoegen'])
		{
		// Query opbouwen met variabelen 
		$query="INSERT INTO fuiven (Fuifnaam, Organisator, Plaats, ADK, VVK, Contact, Datum, Flyer, Commentaar, Gecontroleerd) ";
		$query .= "VALUES ('"; // let op positie van de enkele aanhalingstekens 
		$query .= $_POST["Fuifnaam"] ."', '" ;
		$query .= $_POST["Organisator"] ."', '" ;
		$query .= $_POST["Plaats"] ."', '" ;
		$query .= $_POST["ADK"] ."', '" ;
		$query .= $_POST["VVK"] ."', '" ;
		$query .= $_POST["Contact"] ."', '" ;
		$query .= $_POST["Datum"] ."', '" ;
		$query .= $_POST["Flyer"] ."', '" ;
		$query .= $_POST["Commentaar"] ."', '" ;
		$query .= $_POST["Gecontroleerd"] ."');" ;
		$result = mysql_query($query) or die ("FOUT: " . mysql_error());
		echo "Je fuif is toegevoegd. ";
		}	
	else 
		{
		echo "<br><table><form method='post' target='_self' action='fuiven.php?mode=toevoegen'>
		<td>Fuifnaam: <TD><input type='Text' name='Fuifnaam' size='30'><tr>
		<td>Commentaar:  <TD><textarea name='Commentaar' rows='5' cols='30'></textarea><tr>
		<td>Organisator: <TD><input type='Text' name='Organisator' size='30'><tr>
		<td>Plaats:  <TD><input type='Text' name='Plaats' size='30'><tr>
		<td>ADK:  <TD><input type='Text' name='ADK' size='5'><tr>
		<td>VVK: <TD><input type='Text' name='VVK' size='5'><tr>
		<td>Contact:  <TD><input type='Text' name='Contact' size='30'><tr>
		<td>Datum: (vb: YYYY-MM-DD 21:00:00) <TD><input type='Text' name='Datum' size='30'><tr>
		<td>Flyer:  <TD><input type='Text' name='Flyer' size='30'><tr>
		<td><input type='hidden' name='Gecontroleerd' value='Nee'><tr>								
		<td><input type='submit' name='Invoegen' value='Invoegen'><tr>
		</form>
		</table>";
		}					
	}
else
	{ 
	echo "Hieronder staat de fuivenkalender. Jullie fuif hierbij? Klik <a href='fuiven.php?mode=toevoegen' target='_self'>HIER</a>.<br>";
	// maak lijst van komende fuiven aan		
	echo "<br>::&nbsp;<b><u>Komende fuiven.</u></b><br><br>";  
	
	$query = mysql_query("SELECT * FROM fuiven WHERE Datum >= NOW() ORDER BY Datum ASC");   
	while ($list = mysql_fetch_object($query))  
		{  
		if ($list->Gecontroleerd == "Ja") 
			{
			$unixtime = strtotime($list->Datum);
					
			echo "&nbsp;&nbsp;::&nbsp;<a href=fuiven.php?id=$list->id target='_self'>";  
			$fuif = "&nbsp;/&nbsp;$list->Fuifnaam";  
			echo "".date("d-m-Y H:i:s",$unixtime)."$fuif<BR>";
			}
		echo "</a>";  
		
		// als er op komende fuiven is geklikt  
		
		if($_GET['id'] == "$list->id") 
			{  
			$query1 = mysql_query("SELECT * FROM fuiven WHERE id='".$_GET['id']."' ");  
			while ($list1 = mysql_fetch_object($query1))  
				{
				$unixtime = strtotime($list1->Datum);
				 
				echo "<table align='center'> 
				<tr><TD><b>Fuifnaam:</td><TD>$list1->Fuifnaam</td></TR>  
				<tr><TD><b>Commentaar:</td><TD>$list1->Commentaar</td></TR> 
				<tr><TD><b>Organisator:</td><TD>$list1->Organisator</td></TR> 
				<tr><TD><b>Plaats:</td><TD>$list1->Plaats</td></TR> 
				<tr><TD><b>ADK:</td><TD>$list1->ADK</td></TR> 
				<tr><TD><b>VVK:</td><TD>$list1->VVK</td></TR>  
				<tr><TD><b>Contact:</td><TD><a href=mailto:$list1->Contact>$list1->Contact</a></td></TR> 
				<tr><TD><b>Datum:</td><TD>".date("d-m-Y H:i:s",$unixtime)."</td></TR> 
				<tr><TD><b>Flyer:</td><TD><a href=$list1->Flyer>$list1->Flyer</a></td></TR>  
				</table>";  
				}	  
			} 
		}   
	// maak lijst van gepasseerde fuiven aan      
	echo "<br>::&nbsp;<b><u>Fuiven die al gepasseerd zijn.</u></b><br><br>";

	$query2 = mysql_query("SELECT * FROM fuiven WHERE Datum < NOW() ORDER BY Datum ASC"); 
	while ($list2 = mysql_fetch_object($query2))  
		{  
		if ($list2->Gecontroleerd == "Ja") 
			{
			$unixtime = strtotime($list2->Datum);
					
			echo "&nbsp;&nbsp;::&nbsp;<a href=fuiven.php?id=$list2->id target='_self'>";  
			$fuif = " &nbsp;/&nbsp;$list2->Fuifnaam";  
			echo "".date("d-m-Y H:i:s",$unixtime)."$fuif<BR>";  
			}
		echo "</a>";  
							
		// als er op fuiven die gepasseerd zijn is geklikt  
		
		if($_GET['id'] == "$list2->id") 
			{  
			$query3 = mysql_query("SELECT * FROM fuiven WHERE id='".$_GET['id']."' ");  
			while ($list3 = mysql_fetch_object($query3))  
				{ 
				$unixtime = strtotime($list3->Datum);
				echo "<table align='center'> 
				<tr><TD><b>Fuifnaam:</td><TD>$list3->Fuifnaam</td></TR>  
				<tr><TD><b>Commentaar:</td><TD>$list3->Commentaar</td></TR> 
				<tr><TD><b>Organisator:</td><TD>$list3->Organisator</td></TR> 
				<tr><TD><b>Plaats:</td><TD>$list3->Plaats</td></TR> 
				<tr><TD><b>ADK:</td><TD>$list3->ADK</td></TR> 
				<tr><TD><b>VVK:</td><TD>$list3->VVK</td></TR>  
				<tr><TD><b>Contact:</td><TD><a href=mailto:$list3->Contact>$list3->Contact</a></td></TR> 
				<tr><TD><b>Datum:</td><TD>".date("d-m-Y H:i:s",$unixtime)."</td></TR> 
				<tr><TD><b>Flyer:</td><TD><a href=$list3->Flyer>$list3->Flyer</a></td></TR>  
				</table>";  
				}	  
			} 
		}   
	}

?>


----------admin.php----------
<?php

include_once "database.php";

	echo "::&nbsp;Fuiven<br>
	&nbsp;&nbsp;::&nbsp;<a href=admin.php?actie=fuiven target='_self'>Controleer fuiven die tusen de fuivenkalender willen staan.</a><br><br>";


if($_GET['actie'] == "fuiven")
	{ 
	echo "<br><table width=100%><TD width=20%><b>Fuifnaam<TD width=20%><b>Datum<TD width=20%><b>Organisator<TD width=20%><b>Contact<TD width=20%><b>Toestaan<TR>"; 
	$select = "SELECT * FROM fuiven WHERE Gecontroleerd!='Ja' ORDER by Datum DESC"; 
	$query = mysql_query($select); 
	while ($list = mysql_fetch_object($query)) 
		{ 
		echo "<td>"; 
		$fuif = "<font color=red><b>$list->Fuifnaam</b></font>"; 
		
		echo "$fuif<TD>"; 
		
		echo "$list->Datum<TD>$list->Organisator<TD>$list->Contact<TD><a href=admin.php?ja=".$list->id." target='_self'>Ja</a>&nbsp;&nbsp;<a href=admin.php?nee=".$list->id." target='_self'>Nee</a><TR>"; 
		}
	echo "</table>"; 
	}
//////////////////////////////////////////////////////////////////////	
elseif($_GET['nee'])
	{ 
	mysql_query("DELETE FROM fuiven WHERE id='".$_GET['nee']."'"); 
	echo "<META HTTP-EQUIV='refresh' CONTENT='0; URL=admin.php?actie=fuiven' target='_self'>"; 
	}
//////////////////////////////////////////////////////////////////////
elseif($_GET['ja'])
	{ 
	mysql_query(" UPDATE fuiven SET Gecontroleerd='Ja' WHERE id='".$_GET['ja']."'"); 
	echo "<META HTTP-EQUIV='refresh' CONTENT='0; URL=admin.php?actie=fuiven' target='_self'>"; 
	}

?>