| 1 |
lars |
1 |
<?php
|
|
|
2 |
if (isset($_POST['delete'])) {
|
|
|
3 |
for ($i = 0; $i < sizeof($_POST['check']); $i++) {
|
|
|
4 |
$sql = "DELETE FROM woche WHERE id = '".$_POST['check'][$i]."'";
|
|
|
5 |
mysql_query($sql,$remoteServer_dbh) OR die(mysql_error()."<hr />".$sql);
|
|
|
6 |
$sql = "DELETE FROM mittagsgericht WHERE woche = '".$_POST['check']."'";
|
|
|
7 |
mysql_query($sql,$remoteServer_dbh) OR die(mysql_error()."<hr />".$sql);
|
|
|
8 |
}
|
|
|
9 |
}
|
|
|
10 |
?>
|
|
|
11 |
|
|
|
12 |
<form action="<?= $_SERVER['PHP_SELF']."?action=delete" ?>" method="post">
|
|
|
13 |
<table width="100%" border="1" cellspacing="0" cellpadding="3">
|
|
|
14 |
<tr>
|
|
|
15 |
<td bgcolor="#<? echo $webs[bgcolor_links] ?>"><font color="#<? echo $webs[font_color_links] ?>"><strong>Wochenkarte: Löschen</strong></font></td>
|
|
|
16 |
</tr>
|
|
|
17 |
<?php
|
|
|
18 |
$sql = "SELECT id, gueltig_bis, gueltig_von FROM woche";
|
|
|
19 |
$result = mysql_query($sql,$remoteServer_dbh) OR die(mysql_error()."<hr />".$sql);
|
|
|
20 |
while($row = mysql_fetch_assoc($result)) {
|
|
|
21 |
$wert[] = $row['id'];
|
|
|
22 |
$von[] = date("d.m.Y", ($row['gueltig_von'])+(60*60*59));
|
|
|
23 |
$bis[] = date("d.m.Y", $row['gueltig_bis']);
|
|
|
24 |
}
|
|
|
25 |
|
|
|
26 |
for($i = 0; $i < sizeof($wert); $i++) {
|
|
|
27 |
?>
|
|
|
28 |
<tr>
|
|
|
29 |
<td>
|
|
|
30 |
<input type="checkbox" name="check[]" value="<?= $wert[$i] ?>"><?php echo "Woche: ".$von[$i]." bis ".$bis[$i] ?>
|
|
|
31 |
</td>
|
|
|
32 |
</tr>
|
|
|
33 |
<?php
|
|
|
34 |
}
|
|
|
35 |
?>
|
|
|
36 |
<tr>
|
|
|
37 |
<td bgcolor="#<? echo $webs[bgcolor_links] ?>">
|
|
|
38 |
<input type="hidden" name="action" value='edit'><input type="submit" name="delete" value="Auswahl löschen" style="border: 1px solid gray; background-color: #dddddd;">
|
|
|
39 |
</td>
|
|
|
40 |
</tr>
|
|
|
41 |
</table>
|
|
|
42 |
</form>
|