<?php // update tabel sluitingstijden
if(isset($_POST['Opslaan'])) {
mysql_connect("$host","$user","$pwd");
$_POST['tijd'] = strtotime($_POST['tijd'],'%H:%M');
foreach ($_POST['sl_ID'] as $value) {
@mysql_query("$db","UPDATE sluitingstijden
SET
sl_ID = '".addslashes($_POST['sl_ID'])."'
dag = '".addslashes($_POST['dag'])."'
tijd = '".addslashes($_POST['tijd'])."'
WHERE sl_ID = '$value'");
}
}
?>
<?php // Laat form zien: sl_ID - dag - tijd
$vk = mysql_connect($host, $user, $pwd) or die ("Unable to connect!");
$query =mysql ("$db","SELECT * FROM sluitingstijden");
echo '<form action="'.$_SERVER['PHP_SELF'].'" method="post">';
while ($data = mysql_fetch_assoc($query)) {
$data['tijd'] = strftime("%H:%M",$data['tijd']);
echo '<input type="hidden" name="dag[]"
value="'.stripslashes($data['dag']).'">'.stripslashes($data['dag']).'
<input type="hidden" name="sl_ID[]"
value="'.stripslashes($data['sl_ID']).'">
<input type="text" name="tijd[]"
value="'.stripslashes($data['tijd']).'">';
}
echo '<input type="submit" name="Opslaan" value="Opslaan"></form>';
?>

Likes:

Quote