beginnersvraagje

<?php
include("header.html");
include("dbinlog.php");
$mysql_id=mysql_connect("$dbhost","$dbuser","$dbpass");

if(isset($_POST[invoeren])) {
$naam=$_POST[naam];
$naamklant=$_POST[naamklant];
$jaar=$_POST[jaar];
$maand=$_POST[maand];
$dag=$_POST[dag];
}
else {
}
$sql=" INSERT into structuur VALUES ( '','$naam','$naamklant','$jaar-$maand-$dag' ) ";
$res=mysql_db_query("$db","$sql",$mysql_id);

?>

<form action="<?php echo $_SERVER[PHP_SELF];?>" method="post">
<table>
</br><tr><td>Naam Van de kuisvrouw:</td><td><input type="text" name="naam"></td></tr>
</br><tr><td>Naam van de klant: </td><td><input type="text" name="naamklant"></td></tr>
<tr><td><input type="submit" name="invoeren" value="Gegevens invoeren"></td></tr>

<?php
echo 'Datum :<select name="dag">';
for($i_d=1;$i_d <= 31;$i_d++)
	{
	echo '<option value="'.$i_d.'">'.$i_d.'</option>';
	}
echo '</select>';

echo '<select name="maand">';
for($i_m=0;$i_m < 12;$i_m++)
	{
	$maanden = array('Januari','Februari','Maart','April','Mei','Juni','Juli','Augustus','September','Oktober','November','December');
	echo '<option value="'.($i_m+1).'">'.$maanden[$i_m].'</option>';
	}
echo '</select>';

echo '<select name="jaar">';
for($i_j=date('Y');$i_j >= 2007;$i_j--)
	{
	echo '<option value="'.$i_j.'">'.$i_j.'</option>';
	}
echo '</select>';
?>


</table>
</form>


<?php
include("footer.html");
?>