Regarding deleting of multiple checkbox
Posted: Thu Sep 11, 2008 6:31 am
Below is the code.But my messages are not being deleted.kindly help me and tell me what is wrong
---messages.php-----
<?
session_start();
$connection = mysql_connect("localhost","root","");
mysql_select_db("mailer",$connection);
if(isset($_SESSION['userid']))
{
$msg_to = trim($_SESSION['userid']);
}
$userid=$_SESSION['userid'];
$sql="SELECT * FROM msg WHERE msg_to='".$_SESSION['userid']."' ORDER BY date DESC" ;
$ex=mysql_query($sql);
//$fetch=mysql_fetch_assoc($ex);
include('header1.php');
?>
<script language="javascript">
document.title="Inbox";
</script>
<script language="javascript">
function subform(checkval)
{
var dele="";
var frm=document.frmmsg;
for (var i = 0; i < frm.elements.length; i++)
{
if (frm.elements.type == "checkbox")
{
if(frm.elements.checked && frm.elements.value!="checkbox")
{
if(dele!="")
{
dele=dele+","+frm.elements.value;
}
else
{
dele=frm.elements.value;
}
}
}
}
if(checkval=="del" && dele=="")
{
alert("Please check the messages to be deleted");
frm.checkbox4.focus();
return false;
}
else if(checkval=="del" && dele!="")
{
frm.action="delete.php";
frm.delkey.value = "delete";
frm.submit();
return true;
}
}
/*function removeAll()
{
totElements=document.forms.myForm.selection.length;
countRemovedElements = 0;
for (i=0; i< totElements;i++)
{
thisElement=document.forms.myForm.selection;
if (thisElement.checked == true)
{
countRemovedElements++;
document.getElementById('del'+i).style.display='none';
}
}
document.getElementById('msg').innerHTML = '<strong>' +countRemovedElements+' </strong> elements removed.';
}*/
function checkAll(ref)
{
var chkAll = document.getElementById('checkall');
var checks = document.getElementsByName('sender[]');
var removeButton = document.getElementById('removeChecked');
var boxLength = checks.length;
var allChecked = false;
var totalChecked = 0;
if ( ref == 1 )
{
if (chkAll.checked)
{
for ( i=0; i < boxLength; i++ )
{
checks.checked = true;
}
}
else
{
for ( i=0; i < boxLength; i++ )
{
checks.checked = false;
}
}
}
else
{
for ( i=0; i < boxLength; i++ )
{
if ( checks.checked == true )
{
allChecked = true;
continue;
}
else
{
allChecked = false;
break;
}
}
if ( allChecked == true )
{
chkAll.checked = true;
}
else
{
chkAll.checked = false;
}
}
/* for ( j=0; j < boxLength; j++ )
{
if ( checks[j].checked == true )
{
totalChecked++;
}
}
removeButton.value = "Remove ["+totalChecked+"] Selected";*/
}
</script>
<html>
<body leftmargin="0" topmargin="0">
<table width="1003" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="100" height="12" align="left" valign="top"> <? include('leftmenu.php'); ?> </td>
<td width="573" align="center" valign="top" style="padding:5px; padding-top:0px;">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="21" style="padding:0px;">
<table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="67" align="center" valign="middle"><a href="sent.php"><strong>Sent</strong></a></td>
<td width="67" align="center" valign="middle"><a href="trash.php"><strong>Trash</strong></a></td>
<td width="75" align="center" valign="middle"><a href="compose.php"><strong>Compose</strong></a></td>
<td width="75" align="center" valign="middle"><a href="call.php"><strong>Calendar</strong></a></td>
</tr>
</table>
</td>
</tr>
<tr>
<td><blockquote> </blockquote>
<table cellpadding="0" cellspacing="0" width="100%" align="center">
<tr>
<td height="5px;" align="left" valign="top" ></td>
</tr>
<form name="frmmsg" method="post" action="delete.php">
<tr>
<td align="left" valign="top" style="padding:0px;">
<table width="98%" border="0" cellspacing="0" cellpadding="0" align="center" >
<tr>
<td width="5%" align="left" valign="middle"><a href="#" >
<input type="checkbox" name="checkbox4[]" id="checkbox4" value="<? echo $fetch['msgid']; ?>" onClick="removeAll();"/>
</a></td>
<td width="95%" colspan="5" align="left" bgcolor="#FFFFFF"><input name="delete" type="submit" id="del" value="delete"></td>
</tr>
</table> </td>
</tr>
<tr>
<td height="5px;" align="left" valign="top" ></td>
</tr>
<tr>
<td height="21" style="padding:0px;">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="6%" height="19" align="center" valign="middle" bgcolor="#99CCFF"><input type="checkbox" name="checkall" id="checkall" value="1" onClick="checkAll(1)"/></td>
<td bgcolor="#99CCFF" width="21%" align="left" valign="middle"><font color="#0000FF">Sender</font></td>
<td bgcolor="#99CCFF" width="43%" align="left" valign="middle"><font color="#0000FF">Message</font></td>
<td bgcolor="#99CCFF" width="30%" align="center" valign="middle"><font color="#0000FF">Date</font></td>
</tr>
</table> </td>
</tr>
<?
while($fetch=mysql_fetch_assoc($ex))
{
//var_dump($fetch);
$sql3="SELECT * FROM mail WHERE userid=".$fetch['msg_from']."";
$details=mysql_query($sql3);
$fetch1=mysql_fetch_assoc($details);
$status=$fetch['status'];
?>
<tr>
<td height="21" style="padding:0px;">
<table width="98%" border="0" align="center" cellpadding="5" cellspacing="0">
<tr>
<td width="5%" align="left" valign="middle"><input type="checkbox" name="sender[]" id="sender" value="<?=$fetch['msgid'];?>"/></td>
<td width="21%" align="left" valign="middle"><a href="profile1.php?userid=<? echo $fetch['msg_from']; ?>"><? echo $fetch1['email']; ?> </a></td>
<td width="44%" align="left" valign="middle">
<a href="readmessage.php?msgid=<?=$fetch['msgid']; ?>">
<?
if($status==0)
{
echo "<font size='4'>".$fetch['sub']."</font>";
}
else
{
echo $fetch['sub'];
}
?>
</a></td>
<td width="30%" align="center" valign="middle"><? echo $fetch['date']; ?></td>
<!--<td width="5%" align="left" valign="middle"><a href="delete.php?userid=<?= $fetch['msgid']?>">Delete</a> </td>
<td width="5%" align="left" valign="middle"><input type="checkbox" name="del[]" value="<?=$fetch['msgid'];?>" onClick="javascript: subform('del');"/></td>--> </tr>
</table> </td>
</tr>
<?
}
?>
</form>
</table> </td>
</tr>
</table></td>
</tr>
</table><!--</td>
</tr>-->
<?
include('footer.php');
?>
<!--</table>
--></body>
</html>
------delete.php ------------
<?php
session_start();
$connection = mysql_connect("localhost","root","");
mysql_select_db("mailer",$connection);
include('header1.php');
if(isset($_REQUEST['userid']))
{
$msgid = $_REQUEST['userid'];
// echo $sql="DELETE * FROM msg where msgid='".$_REQUEST['msgid']."' LIMIT 1";
$sql="DELETE msg FROM msg where msgid=$msgid";
$result=mysql_query( $sql);
}
?>
<script language="javascript">
document.title="Delete message";
alert('Do you want to delete this message?');
</script>
<table width="1003" align="center" border="1" cellpadding="0" cellspacing="0">
<tr>
<td align="center">Your message has been deleted successfully.
<input name="Back" type="submit" id="Back" value="Back" onclick="javascript:window.location='messages.php';">
</td> </tr>
<?
include('footer.php');
?>
</table>
---messages.php-----
<?
session_start();
$connection = mysql_connect("localhost","root","");
mysql_select_db("mailer",$connection);
if(isset($_SESSION['userid']))
{
$msg_to = trim($_SESSION['userid']);
}
$userid=$_SESSION['userid'];
$sql="SELECT * FROM msg WHERE msg_to='".$_SESSION['userid']."' ORDER BY date DESC" ;
$ex=mysql_query($sql);
//$fetch=mysql_fetch_assoc($ex);
include('header1.php');
?>
<script language="javascript">
document.title="Inbox";
</script>
<script language="javascript">
function subform(checkval)
{
var dele="";
var frm=document.frmmsg;
for (var i = 0; i < frm.elements.length; i++)
{
if (frm.elements.type == "checkbox")
{
if(frm.elements.checked && frm.elements.value!="checkbox")
{
if(dele!="")
{
dele=dele+","+frm.elements.value;
}
else
{
dele=frm.elements.value;
}
}
}
}
if(checkval=="del" && dele=="")
{
alert("Please check the messages to be deleted");
frm.checkbox4.focus();
return false;
}
else if(checkval=="del" && dele!="")
{
frm.action="delete.php";
frm.delkey.value = "delete";
frm.submit();
return true;
}
}
/*function removeAll()
{
totElements=document.forms.myForm.selection.length;
countRemovedElements = 0;
for (i=0; i< totElements;i++)
{
thisElement=document.forms.myForm.selection;
if (thisElement.checked == true)
{
countRemovedElements++;
document.getElementById('del'+i).style.display='none';
}
}
document.getElementById('msg').innerHTML = '<strong>' +countRemovedElements+' </strong> elements removed.';
}*/
function checkAll(ref)
{
var chkAll = document.getElementById('checkall');
var checks = document.getElementsByName('sender[]');
var removeButton = document.getElementById('removeChecked');
var boxLength = checks.length;
var allChecked = false;
var totalChecked = 0;
if ( ref == 1 )
{
if (chkAll.checked)
{
for ( i=0; i < boxLength; i++ )
{
checks.checked = true;
}
}
else
{
for ( i=0; i < boxLength; i++ )
{
checks.checked = false;
}
}
}
else
{
for ( i=0; i < boxLength; i++ )
{
if ( checks.checked == true )
{
allChecked = true;
continue;
}
else
{
allChecked = false;
break;
}
}
if ( allChecked == true )
{
chkAll.checked = true;
}
else
{
chkAll.checked = false;
}
}
/* for ( j=0; j < boxLength; j++ )
{
if ( checks[j].checked == true )
{
totalChecked++;
}
}
removeButton.value = "Remove ["+totalChecked+"] Selected";*/
}
</script>
<html>
<body leftmargin="0" topmargin="0">
<table width="1003" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="100" height="12" align="left" valign="top"> <? include('leftmenu.php'); ?> </td>
<td width="573" align="center" valign="top" style="padding:5px; padding-top:0px;">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="21" style="padding:0px;">
<table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="67" align="center" valign="middle"><a href="sent.php"><strong>Sent</strong></a></td>
<td width="67" align="center" valign="middle"><a href="trash.php"><strong>Trash</strong></a></td>
<td width="75" align="center" valign="middle"><a href="compose.php"><strong>Compose</strong></a></td>
<td width="75" align="center" valign="middle"><a href="call.php"><strong>Calendar</strong></a></td>
</tr>
</table>
</td>
</tr>
<tr>
<td><blockquote> </blockquote>
<table cellpadding="0" cellspacing="0" width="100%" align="center">
<tr>
<td height="5px;" align="left" valign="top" ></td>
</tr>
<form name="frmmsg" method="post" action="delete.php">
<tr>
<td align="left" valign="top" style="padding:0px;">
<table width="98%" border="0" cellspacing="0" cellpadding="0" align="center" >
<tr>
<td width="5%" align="left" valign="middle"><a href="#" >
<input type="checkbox" name="checkbox4[]" id="checkbox4" value="<? echo $fetch['msgid']; ?>" onClick="removeAll();"/>
</a></td>
<td width="95%" colspan="5" align="left" bgcolor="#FFFFFF"><input name="delete" type="submit" id="del" value="delete"></td>
</tr>
</table> </td>
</tr>
<tr>
<td height="5px;" align="left" valign="top" ></td>
</tr>
<tr>
<td height="21" style="padding:0px;">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="6%" height="19" align="center" valign="middle" bgcolor="#99CCFF"><input type="checkbox" name="checkall" id="checkall" value="1" onClick="checkAll(1)"/></td>
<td bgcolor="#99CCFF" width="21%" align="left" valign="middle"><font color="#0000FF">Sender</font></td>
<td bgcolor="#99CCFF" width="43%" align="left" valign="middle"><font color="#0000FF">Message</font></td>
<td bgcolor="#99CCFF" width="30%" align="center" valign="middle"><font color="#0000FF">Date</font></td>
</tr>
</table> </td>
</tr>
<?
while($fetch=mysql_fetch_assoc($ex))
{
//var_dump($fetch);
$sql3="SELECT * FROM mail WHERE userid=".$fetch['msg_from']."";
$details=mysql_query($sql3);
$fetch1=mysql_fetch_assoc($details);
$status=$fetch['status'];
?>
<tr>
<td height="21" style="padding:0px;">
<table width="98%" border="0" align="center" cellpadding="5" cellspacing="0">
<tr>
<td width="5%" align="left" valign="middle"><input type="checkbox" name="sender[]" id="sender" value="<?=$fetch['msgid'];?>"/></td>
<td width="21%" align="left" valign="middle"><a href="profile1.php?userid=<? echo $fetch['msg_from']; ?>"><? echo $fetch1['email']; ?> </a></td>
<td width="44%" align="left" valign="middle">
<a href="readmessage.php?msgid=<?=$fetch['msgid']; ?>">
<?
if($status==0)
{
echo "<font size='4'>".$fetch['sub']."</font>";
}
else
{
echo $fetch['sub'];
}
?>
</a></td>
<td width="30%" align="center" valign="middle"><? echo $fetch['date']; ?></td>
<!--<td width="5%" align="left" valign="middle"><a href="delete.php?userid=<?= $fetch['msgid']?>">Delete</a> </td>
<td width="5%" align="left" valign="middle"><input type="checkbox" name="del[]" value="<?=$fetch['msgid'];?>" onClick="javascript: subform('del');"/></td>--> </tr>
</table> </td>
</tr>
<?
}
?>
</form>
</table> </td>
</tr>
</table></td>
</tr>
</table><!--</td>
</tr>-->
<?
include('footer.php');
?>
<!--</table>
--></body>
</html>
------delete.php ------------
<?php
session_start();
$connection = mysql_connect("localhost","root","");
mysql_select_db("mailer",$connection);
include('header1.php');
if(isset($_REQUEST['userid']))
{
$msgid = $_REQUEST['userid'];
// echo $sql="DELETE * FROM msg where msgid='".$_REQUEST['msgid']."' LIMIT 1";
$sql="DELETE msg FROM msg where msgid=$msgid";
$result=mysql_query( $sql);
}
?>
<script language="javascript">
document.title="Delete message";
alert('Do you want to delete this message?');
</script>
<table width="1003" align="center" border="1" cellpadding="0" cellspacing="0">
<tr>
<td align="center">Your message has been deleted successfully.
<input name="Back" type="submit" id="Back" value="Back" onclick="javascript:window.location='messages.php';">
</td> </tr>
<?
include('footer.php');
?>
</table>