1.571 views
hoi ik had een vraagje ik heb een forum en wil meerdere berichten tegelijk kunnen verwijderen dit lukt mij niet echt kan iemand me helpen?
<form name="form2" method="post" action="delreactie.php">
<INPUT type=hidden value=<?php echo $nick ?> name=nick>
<INPUT type=hidden value=<?php echo $forumid ?> name=forumid>
<INPUT type=hidden value=<?php echo $topicid ?> name=topicid>
<TABLE cellSpacing=0 cellPadding=0 width=548 border=0>
<TBODY>
<tr>
<TD align=right
background="images/mftop.gif" class="style4"><FONT size=1><u><b><?php echo $topic ?></b></u> </FONT>
</tr>
<tr>
<TD>
<TABLE cellSpacing=0 cellPadding=1 width="100%"
bgColor=black border=0>
<TBODY>
<TR>
<TD height="22">
<TABLE cellSpacing=0 cellPadding=1 width="546"
bgColor=white border=0>
<TBODY>
<?php
$sql = "SELECT * FROM toto_reactie WHERE topicid = '$topicid' ORDER BY id ASC";
$res = mysql_query($sql);
if (mysql_num_rows($res) >= 1)
{
while ($row = mysql_fetch_array($res))
{
$row[nick] = htmlentities($row[nick]);
$row[nick] = nl2br($row[nick]);
?>
<TR bgcolor="#CCCCCC">
<TD colspan="2"><?php if ($staff == '1') {
?><input name="dell" type="checkbox" id="dell" value="<?php echo $row[ID] ?>">
<?php
}
?><?php if ($staff == '2') {
?><input name="dell" type="checkbox" id="dell" value="<?php echo $row[ID] ?>">
<?php
}
?><?php if ($staff == '3') {
?><input name="dell" type="checkbox" id="dell" value="<?php echo $row[ID] ?>">
<?php
}
?><?php if ($staff == '0') {
if ($nick == $moderator) {
?><input name="dell" type="checkbox" id="dell" value="<?php echo $row[ID] ?>">
<?php
}
}
?><a href="profiel.php?login=<?php echo $row[nick] ?>"><b><?php echo $row[nick] ?></b></a></TD>
<TD width="300" colspan="2"><div align="right"><?php echo $row[tijd] ?></div></TD>
</TR>
<?php
$profiel = "SELECT * FROM toto_leden WHERE login = '$row[nick]'";
$prof = mysql_query($profiel);
$logo1 = mysql_result($prof, 0, logo);
$staff1 = mysql_result($prof, 0, staff);
$post1 = mysql_result($prof, 0, posts);
$punt1 = mysql_result($prof, 0, punten);
?>
<TR>
<TD width="86" bgcolor="#FFFFFF"><a href="profiel.php?login=<?php echo $row[nick] ?>"><img src="<?php echo $logo1 ?>"></a><br>
<?php
if ($staff1 == 1) { ?>
<span class="style11"><b><font size="2" color="#FF0000">ToTo Staff</font></b></span>
<?php } if ($staff1 == 3) { ?>
<span class="style11"><b><font size="2" color="#FF0000">ToTo Staff</font></b></span>
<?php } ?> <br>
<b><font size="1">Posts:</b><?php echo $post1 ?> </font>
<br>
<b><font size="1">Punten:</b><?php echo $punt1 ?> </font>
</TD>
<TD colspan="3"><?php echo $row[bericht] ?></TD>
</TR>
<?php
}
}
?>
</TBODY></TABLE></TD></TR></TBODY></TABLE></TD>
</tr>
<tr>
<TD
background="images/mfbottom.gif"> </TD>
</tr><TR height=17>
<TD align=right><tr>
<TD align=right></tr>
</TBODY></TABLE>
<div align="left">
<input type="submit" name="Submit" value="verwijder">
</div>
</form> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>
<body>
<?php
$nick = strip_tags($_POST["nick"]);
$dell = strip_tags($_POST["dell"]);
$topicid = strip_tags($_POST["topicid"]);
$forumid = strip_tags($_POST["forumid"]);
$host = "****";
$user = "****";
$pass = "****";
$db = "****";
mysql_connect($host,$user,$pass) or die(mysql_error());
mysql_select_db($db);
$dapp_nieuws_SQL_insert = "DELETE FROM `toto_reactie` WHERE `ID` = '$dell'";
mysql_query($dapp_nieuws_SQL_insert);
?> <?php include('forums.php'); ?>
</body>
</html>