<form action="<?php print $_SERVER['PHP_SELF'] ?>" method="post" >
	<br><table width="90%" border="0" cellspacing="0" cellpadding="3" align="center">
					<tr>
						<td>
						<strong>Geschreven door <input value="Typ hier uw naam" type="text" name="door"></strong>
						 | <?php echo date("d-m-Y H:i:s", time()); ?>
						</td>
					</tr>
					<tr>
						<td>
						<textarea name="bericht" rows="8" cols="50">Typ hier uw bericht!</textarea><br>
						<input type="submit" value="Bericht plaatsen!">
						</td>
					</tr>
				</table>
<?php 
mysql_connect("localhost",USER,WACHTWOORD);     // zelf in te vullen
mysql_select_db(DATABASE);     // zelf in te vullen 

if(isset($_POST['door']) and isset($_POST['bericht']) and $_POST['door']!='Typ hier uw naam' and $_POST['bericht']!='Typ hier uw bericht!' ) {
	$bericht = $_POST['bericht'];
	$door = $_POST['door'];
	$datum =  date("d-m-Y H:i:s", time());
	
	$bericht = str_replace("\n", "<br>", $bericht);
	
	$query = "INSERT INTO gastenboek(bericht, door , datum) VALUES ('".$bericht."', '".$door."', '".$datum."')"; 
  	$sql=mysql_query($query) or die (mysql_error());
}

$query = "SELECT * FROM gastenboek ORDER BY id DESC"; 
$sql=mysql_query($query) or die (mysql_error());
 
while ($obj=mysql_fetch_object($sql)) { 
	$door = $obj->door;
	$datum = $obj->datum;
	$bericht = $obj->bericht;
	?>
	
	<br><table width="90%" border="0" cellspacing="0" cellpadding="3" align="center">
					<tr>
						<td >
						<strong>Geschreven door <?php echo $door; ?></strong>
						 | <?php echo $datum ?>
						</td>
					</tr>
					<tr>
						<td >
						<?php echo $bericht; ?>
						</td>
					</tr>
				</table>
				
<?php }
?>
