Menu
Community /Pin to ProfileBookmark
@NogDogMar 25.2006 — #Create a comma-separated string of member_id's:
Then your delete query would be something like:
how we can delte mutiple records with checkboxes
Hi,
Plz,tell me how i can delete multiple rows or single row by php.plz, help me i am in deep trouble.i shaal be very thankful to you.
my page code is as follows:-
<?
include(“header.php”);
include(“label.php”);
include(“connection.php”);
?>
<HTML>
<HEAD>
<TITLE> Member’s Area </TITLE>
</HEAD>
<BODY bgcolor=”#F8E1D0″ topmargin=”0″ leftmargin=”0″ leftbottom=”0″ width=”100%”>
<form method=”post” action=”delete.php”>
<A HREF=”adminmember.php”>Add<IMG SRC=”Images/Add.jpg” Title=”Add” BORDER=”1″></A>
<INPUT TYPE=”submit” name =”delete” value=”Delete”>
</form>
<TABLE border=0 width=”100%”>
<TR BGCOLOR=”#FF9966″>
<td width=25 BGCOLOR=”#F8E1D0″> </td>
<TD><b>MemberId</TD>
<TD><b>Full Name </TD>
<TD><b>E-mail </TD>
<TD><b>Address </TD>
<TD><b>Contact Number</TD>
</TR>
<?
$query=”SELECT * FROM members”;
$result=mysql_query($query);
$numrows=mysql_num_rows($result);
$i=0;
while($i<$numrows)
{
$memberid=mysql_result($result,$i,”login_memberid”);
$password=mysql_result($result,$i,”login_password”);
$member_fname=mysql_result($result,$i,”member_fname”);
$member_lname=mysql_result($result,$i,”member_lname”);
$member_email=mysql_result($result,$i,”member_email”);
$member_address=mysql_result($result,$i,”member_address”);
$member_phone=mysql_result($result,$i,”member_phone”);
$member_id=mysql_result($result,$i,”member_id”);
print”
<TR>
<TD><INPUT TYPE=’checkbox’ NAME=’ch1[]’ value=”.$member_id.”></TD>
<TD><A HREF=’edit.php?id=$member_id’>$memberid</A></TD>
<TD>$member_fname $member_lname</TD>
<TD>$member_email</TD>
<TD>$member_address</TD>
<TD>$member_phone</TD>
</TR>
“;
$i++;
}
?>
</TABLE>
</SCRIPT>–>
</HTML>
<?
print ” <BR> <BR> <BR> <BR> <BR> <BR> <BR> <BR> <BR> <BR> <BR> <BR> <BR> <BR> “;
include(“footer.php”);
?>
Thanks & Regards
Parveen arora
Sign in
to post a comment2 Comments(s) ↴
0
@NogDogMar 25.2006 — #Create a comma-separated string of member_id's:[code=php]
// if member_id is a number:
$list = implode(",", $_POST['ch1']);
// if member_id is a string:
$list = "'".implode("','", $_POST['ch1'])."'";
[/code]Then your delete query would be something like:
[code=php]
$query = "DELETE FROM members WHERE member_id IN ($list)";
[/code]