Mailbox: Getting messages to delete

[kendallkamikaze]

I have my mailbox set up with Javascript so when you click the checkbox it will highlight them all or you can go through and select the ones you want to delete. You'll have to forgive me. I'm very new to php and I dont understand fully how to connect how to make it so that if the box is checked it needs to be deleted when you click the button below. When you click it, it says it deletes the messages but nothing happens:

<form name='frm' method='post' action='messages2.php?action=delete'>
<input type='submit' name='massdelete' value='Delete Selection'></form>

<?php 
if($_GET[action] == "delete"){print "<BR><BR><B>The selected messages were deleted.</B><br><a href=messages2.php>Go Back.</a>";}
?>

 

Old Code where if you clicked the link, it would delete all messages:

<?php

if($_GET[action] == "deleteallmsgs"){
mysql_query("delete from messages where Recipient='$id' and new='no'")or die(mysql_query());
print "<center>All of Your Messages were Deleted.<br><a href=messages.php>Go Back.</a>";include "footer.php";exit;}
?>

 

 

The JavaScript code that I used is:

<script type="text/javascript"><!--
function checkAll (obj) {
   var arrInput = document.getElementsByTagName("input");
   for (i=0; i<arrInput.length; i++) {
     if (arrInput[i].type == 'checkbox') {
       arrInput[i].checked = obj.checked;

     }
   }
}
--></script>

 

If you need anything else for this to make more sense, let me know.

 

[Potatis]

I can't see anywhere in your code where you might be calling the javascript checkAll () function. If you don't then your javascript code will be ignored and it won't work.

[kendallkamikaze]

the JS works fine, its when they are selected that it doesnt delete

[kendallkamikaze]

this is the entire code for it:

 

<?php

include 'header.php';
if($_GET[action] == "deleteallmsgs"){
mysql_query("delete from messages where Recipient='$id' and new='no'")or die(mysql_query());
print "<center>All of Your Messages were Deleted.<br><a href=messages.php>Go Back.</a>";include "footer.php";exit;}
?>
<br><br>
<center> <a href="message_compose.php"> Compose a Message </a> | <a href="messages.php?action=deleteallmsgs"> Delete All Messages </a> 

<script type="text/javascript"><!--
function checkAll (obj) {
   var arrInput = document.getElementsByTagName("input");
   for (i=0; i<arrInput.length; i++) {
     if (arrInput[i].type == 'checkbox') {
       arrInput[i].checked = obj.checked;

     }
   }
}
--></script>


<style>
.maintable{
font-size:10px;
font-family:verdana;
color:#000000;
background:url(http://i41.tinypic.com/2yw60r6.jpg);
}
.msg{
font-size:8px;
font-family:verdana;
color:#000000;
background:url(http://i42.tinypic.com/25a5kpw.jpg);
}
.highlight{
font-size:8px;
font-family:verdana;
color:#000000;
background:url(http://i43.tinypic.com/6huwk6.jpg);
}
</style>


<div id="tableContainer" class="tableContainer">
<table width=630 border="0" cellpadding="0" cellspacing="0">
<tr><td>

<table border="0" cellpadding="0" cellspacing="0" >
<tr height=19px>
<td class='maintable'  height=19px style='background-image: url(http://i43.tinypic.com/2eundbq.jpg);background-repeat: no-repeat; background-position: center center;'><img src='http://i43.tinypic.com/2eundbq.jpg'></td>
<td class='maintable' height=19px width=32>

<input type="checkbox" name="chk_all" id="chk_all" value="" onchange="checkAll(this);" />

</td>
<td class='maintable' height=19px width=50 style='background-image: url(http://i41.tinypic.com/2yw60r6.jpg);'>
From</td>
<td class='maintable'  width=235 style='background-image: url(http://i41.tinypic.com/2yw60r6.jpg);'>
|Subject</td>
<td class='maintable'  width=235 style='background-image: url(http://i41.tinypic.com/2yw60r6.jpg);'>
|Date</td>
<td class='maintable'  height=19px style='background-image: url(http://i41.tinypic.com/2yw60r6.jpg);'>
|Status</td>
<td class='maintable'  height=19px style='background-image: url(http://i41.tinypic.com/2yw60r6.jpg);'>
</td>
<td class='maintable'  height=19px style='background-image: url(http://i43.tinypic.com/2eundbq.jpg);background-repeat: no-repeat; background-position: center center;'><img src='http://i43.tinypic.com/2eundbq.jpg'></td>
</tr> </table>

</td></tr>
<tr><td>


<table width=635 border="0" cellpadding="0" cellspacing="0" >
<tbody class="scrollContent">

<?php

$sql="SELECT * FROM messages WHERE Recipient='$id' order by id desc ";
$result=mysql_query($sql);
$msgs=mysql_num_rows($result);

$checkbox = $_POST['checkbox']; 

if(!empty($checkbox)){
$massdelete = $_GET['massdelete'];

if($massdelete){
for($i=0;$i<$msgs;$i++){
$deleteid = $checkbox[$i];

mysql_query("delete from messages where id='$deleteid'");
//echo ("$checkbox<br>");  //display all msg ids deleted
}


}}

//and new='yes'
if($msgs == "0"){

print "<tr><td colspan=5><center>No Messages.</td></tr>";

}
for($i=0;$i<$msgs;$i++)
{	
$r=mysql_fetch_array($result);
$mid=$r["id"];
$Sender=$r["Sender"];
$Subject=$r["Subject"];
$Message=$r["Message"];
$Date=$r["date"];
$New=$r["new"];

if($New == "no"){$rou="Read";}
if($New == "yes"){$rou="Unread";}
if(empty($Subject)){$Subject="No Subject";}

//Sunday 6/18/2008 2:38pm
//$Date=str_replace(D n/j/y g:ia,$Date);

  echo "

<tr class='msg' class='scrollContent' onMouseOver=this.className='highlight' onMouseOut=this.className='msg'>

<td width=29><input type='checkbox' name='chk_1' id='chk_1' value='' /></td> 
<td width=57><b><a href=player_individual.php?id=$Sender>#$Sender</a></b></td>
<td width=235><b><a href='message_viewindividual.php?id=$mid'>$Subject</a></b></td>
<td width=230><i>$Date</i></td>
<td><center><b>$rou</b></center></td>
</tr>
  ";
}
?>


</table>

</td></tr>
</tbody>
</table></div>

</form>
<BR>

<form name='frm' method='post' action='messages2.php?action=delete'>
<input type='submit' name='massdelete' value='Delete Selection'></form>

<?php 
if($_GET[action] == "delete"){print "<BR><BR><B>The selected messages were deleted.</B><br><a href=messages2.php>Go Back.</a>";}
?>



<BR><BR>

<?php

include "footer.php";

?>

[darkfreaks]

<?php
if($_GET[action] == "deleteallmsgs"){
mysql_query("DELETE FROM messages WHERE Recipient='$id' and new='no'")or die(mysql_error());
print "<center>All of Your Messages were Deleted.<br><a href=messages.php>Go Back.</a>";include "footer.php";exit;}
else{ echo "could not delete messages";}
?>

[kendallkamikaze]

<?php
if($_GET[action] == "deleteallmsgs"){
mysql_query("DELETE FROM messages WHERE Recipient='$id' and new='no'")or die(mysql_error());
print "<center>All of Your Messages were Deleted.<br><a href=messages.php>Go Back.</a>";include "footer.php";exit;}
else{ echo "could not delete messages";}
?>

 

but this wouldnt delete just the selected ones correct? I'm just worried that it would just delete all of them and not just the single selected ones if not all are selected?

[darkfreaks]

http://www.dustindiaz.com/check-one-check-all-javascript/