Subversion-Projekte lars-tiefland.content-management

<?php
        if (isset($_POST['delete'])) {
                for ($i = 0; $i < sizeof($_POST['check']); $i++) {
                        $sql = "DELETE FROM woche WHERE id = '".$_POST['check'][$i]."'";
                        mysql_query($sql,$remoteServer_dbh) OR die(mysql_error()."<hr />".$sql);
                        $sql = "DELETE FROM mittagsgericht WHERE woche = '".$_POST['check']."'";
                        mysql_query($sql,$remoteServer_dbh) OR die(mysql_error()."<hr />".$sql);
                }
        }
?>

<form action="<?= $_SERVER['PHP_SELF']."?action=delete" ?>" method="post">
        <table width="100%" border="1" cellspacing="0" cellpadding="3">
                <tr>
                        <td bgcolor="#<? echo $webs[bgcolor_links] ?>"><font color="#<? echo $webs[font_color_links] ?>"><strong>Wochenkarte: L&ouml;schen</strong></font></td>
                </tr> 
<?php
                $sql = "SELECT id, gueltig_bis, gueltig_von FROM woche";
                $result =  mysql_query($sql,$remoteServer_dbh) OR die(mysql_error()."<hr />".$sql);
                while($row = mysql_fetch_assoc($result)) {
                        $wert[] = $row['id'];
                        $von[]  = date("d.m.Y", ($row['gueltig_von'])+(60*60*59));
                        $bis[]  = date("d.m.Y", $row['gueltig_bis']);
                }
                
                for($i = 0; $i < sizeof($wert); $i++) {
?>
                <tr>
                        <td>
                                <input type="checkbox" name="check[]" value="<?= $wert[$i] ?>"><?php echo "Woche: ".$von[$i]." bis ".$bis[$i] ?>
                        </td>
                </tr>
<?php
                }
?>
                <tr>
                        <td bgcolor="#<? echo $webs[bgcolor_links] ?>">
                                <input type="hidden" name="action" value='edit'><input type="submit" name="delete" value="Auswahl löschen" style="border: 1px solid gray; background-color: #dddddd;">
                        </td>
                </tr>
        </table>
</form>