wat zie ik over het hooft.
<?php
$select_users = mysql_query ("SELECT * FROM tbl_users");
$select_users2 = mysql_query("SELECT * FROM werknemers");
?>
<form action="" method="POST" >
Door wie: <select id="wie" name="door">
<?php
while ($select_persoon = mysql_fetch_assoc($select_users)){
echo '<option value="'.$select_persoon['id'].'">'.$select_persoon['name'].'</option>';
}
?>
</select>
<select name='met'>
<?php
while ($row2 = mysql_fetch_array($select_users2)) {
echo '<option value="'.$row2['ID'].'">'.$row2['Naam'].'</option>';
}
?>
</select>
<div id="Datum">Datum: <input name="datum" type="date" /></div>
<div id="tijd">Tijd: <input name="tijd" type="time" /></div>
<div id="Afspraak">Afspraak: <input name="afspraak" type="text" /></div>
<input type="submit" value="Maak afspraak" name="nieuwe_afspraak">
</form>
<?php
if (isset($_POST['nieuwe_afspraak'])){
echo "De SUBMIT werkt niet, hoe kan dat?";
$sql_insert_user = "INSERT INTO archief2 (id, wie, naam, datum, tijd, afspraak) VALUES (
'',
'".mysql_real_escape_string($_POST['door'])."',
'".mysql_real_escape_string($_POST['met'])."',
'".mysql_real_escape_string($_POST['datum'])."',
'".mysql_real_escape_string($_POST['tijd'])."',
'".mysql_real_escape_string($_POST['afspraak'])."'
)
";
echo "Query uitgevoerd";
echo "<script>window.location = 'afspraak.php';</script>";
$result = mysql_query("SELECT * FROM WIE");
$result = mysql_query("SELECT * FROM ASPRAKEN ORDER BY WIE");
ob_start();
echo "<table border='1'>";
echo "<th>wie</th>";
echo "<th>Naam</th>";
echo "<th>Datum</th>";
echo "<th>tijd</th>";
echo "<th>Afspraak</th>";
while ($row = mysql_fetch_array($result)) {
echo "<tr><td>".$row['wie']."</td>";
echo "<td>".$row['Naam']."</td>";
echo "<td>".$row['Datum']."</td>";
echo "<td>".$row['tijd']."</td>";
echo "<td>".$row['Afspraak']."</td>";
$headers = "MIME-Version: 1.0\r\n";
$headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";
}
echo "</table>";
$bericht = ob_get_contents();
ob_end_clean();
mail('[email protected],[email protected],[email protected]', 'Combigoods - Afspraken', $bericht, $headers);
$result = mysql_query("SELECT * FROM aspraken");
while ($row = mysql_fetch_array($result)) {
mysql_query("INSERT IGNORE INTO archief2 SELECT * FROM aspraken");
mysql_query("DELETE FROM ASPRAKEN");
}
}
?>