Delete med checkbox
HejJeg har lavet en side hvor brugeren kan slette noget fra databasen. Jeg har valgt at bruge checkboxes fordi brugeren så kan slette flere. Desværer fungere koden ikke når brugeren har valgt at slette flere data ad gangen.
<?php
$connect = mysql_connect("XXX","XXX");
mysql_select_db("database") or die ("select_db error");
if (isset($mnd_id))
{
//echo'<br>inde i isset($mnd_id))';
mysql_db_query("delete from survey where date_format(dato,'%Y%m')='$mnd_id';")) or die(mysql_error());
}
}
else{
$result = mysql_query("select date_format(dato,'%Y%m') as mnd, count(surveynr) as nvotes from tabel group by mnd;")or die (mysql_error());
if(mysql_fetch_array($result)>0){
?>
<TABLE border="0" cellpadding="0" cellspacing="0" width="90%">
<TR>
<TD width="100%"><form method="POST" action="<?php echo$PHP_SELF; ?>">
<CENTER>
<TABLE border="1" cellpadding="0" cellspacing="0" width="82%">
<TR><TD width="27%" align="center"><font face="Arial">Vælg for at slette</font></TD>
<TD width="38%" align="center"><font face="Arial">Dato</font></TD>
<TD width="44%" align="center"><font face="Arial">Antal stemmer</font></TD></TR>
<?php
while ($row = mysql_fetch_array($result))
{
?>
<TD width="22%" align="center"><font face="Arial">
<INPUT type="checkbox" name='mnd_id' value="<?php echo$row["mnd"]; ?>">
</font></TD>
<TD width="34%"><a href=view_data.php?mnd=<?php echo$row["mnd"] ;?> target="msmain">
<font face="Arial"><?php echo $row["mnd"] ; ?></font></a></TD>
<TD width="44%" align="center"><font face="Arial"> <?php echo $row["nvotes"]; ?>
</font></TD></TR>
<?php
} // While ends
?>
</TABLE>
<p>
<input type="reset" value=" RESET" >
<input type="submit" value="SUBMIT">
</p>
</CENTER>
</FORM>
</TD>
</TR>
</TABLE>
</BODY>
<?php
} //end of else
?>
