PHP全选择删除功能

时间:2023-03-08 16:46:06
<script type="text/javascript" language="javascript">
function selectBox(selectType){
var checkboxis = document.getElementsByName("id[]");
if(selectType == "reverse"){
for (var i=; i<checkboxis.length; i++){
//alert(checkboxis[i].checked);
checkboxis[i].checked = !checkboxis[i].checked;
}
}
else if(selectType == "all")
{
for (var i=; i<checkboxis.length; i++){
//alert(checkboxis[i].checked);
checkboxis[i].checked = true;
}
}
}
</script>

表单部分

<form id="form2" name="form2" method="post" action="del_product.php" onsubmit="return checkF(this)">
<table width="100%" border="" cellspacing="" cellpadding="">
<tr>
<td width="6%" height="" align="center" style="border-bottom:1px #D7EBFF dotted;">ID</td>
<td width="85%" align="center" style="border-bottom:1px #D7EBFF dotted;">标题</td>
<td width="9%" align="center" style="border-bottom:1px #D7EBFF dotted;">操作</td>
</tr>
<tr bgcolor="#ffffff" onmouseover="this.style.background='#EEFAFF'; " onmouseout ="this.style.background='#ffffff'; this.style.bordercolor=''">
<td height="" align="center" style="border-bottom:1px #D7EBFF solid;">
<label>
<input type="checkbox" name="id[]" value="<?php echo $rs['id'];?>" style="background:none; border:none;" /><?php echo $rs['id'];?>
</label>
</td>
<td align="left" style="border-bottom:1px #D7EBFF solid;"><?php echo $rs['title']; ?></td>
<td align="center" style="border-bottom:1px #D7EBFF solid;"><a href="quality_edit.php?id=<?php echo $rs['id']; ?>&pg=<?php echo $PB_page; ?>">编辑</a> | <a href="?action=del&id=<?php echo $rs['id'];?>&pg=<?php echo $PB_page; ?>" onclick="return confirm('确定删除?')">删除</a></td>
</tr>
<?php
}
?>
<tr bgcolor="#EEFAFF">
<td height="" colspan="" align="left" style="border-bottom:1px #D7EBFF solid;">
<div style="padding-left:20px;"><input type="button" value="全选" style="background:url(images/cheall.jpg) no-repeat; width:60px; height:23px; border:none;" onClick="selectBox('all')"/>
<input type="button" value="反选" style="background:url(images/cheall.jpg) no-repeat; width:60px; height:23px; border:none;" onClick="selectBox('reverse')"/>
<input type="submit" name="btnSave" style="background:url(images/cheall.jpg) no-repeat; width:60px; height:23px; border:none;" value="删除"/> </div>
</td>
</tr> </table>
</form>

del_product.php  处理文件

<?php
include('checkadmin.php');
header('Content-Type: text/html; charset=utf-8');
if($_POST['btnSave']){ if(empty($_POST['id'])){
echo"<script>alert('必须选择一个产品,才可以删除!');history.back(-1);</script>";
exit;
}else{
/*如果要获取全部数值则使用下面代码*/ $id= implode(",",$_POST['id']);
$str="DELETE FROM `product` where id in ($id)";
mysql_query($str);
echo "<script>alert('删除成功!');window.location.href='product_list.php';</script>";
}
}
?>

简单批量删除

<form id="form2" name="form2" method="post" action="del_product.php" onsubmit="return checkF(this)">
<label>
<input type="checkbox" name="id[]" value="<?php echo $rs['id'];?>" style="background:none; border:none;" />
</label>
<div style="padding-left:20px;"><input type="button" value="全选" style="background:url(images/cheall.jpg) no-repeat; width:60px; height:23px; border:none;" onClick="selectBox('all')"/>
<input type="button" value="反选" style="background:url(images/cheall.jpg) no-repeat; width:60px; height:23px; border:none;" onClick="selectBox('reverse')"/>
<input type="submit" name="btnSave" style="background:url(images/cheall.jpg) no-repeat; width:60px; height:23px; border:none;" value="删除"/> </div> </form> JS
[javascript] view plaincopy
<script type="text/javascript" language="javascript">
function selectBox(selectType){
var checkboxis = document.getElementsByName("id[]");
if(selectType == "reverse"){
for (var i=; i<checkboxis.length; i++){
//alert(checkboxis[i].checked);
checkboxis[i].checked = !checkboxis[i].checked;
}
}
else if(selectType == "all")
{
for (var i=; i<checkboxis.length; i++){
//alert(checkboxis[i].checked);
checkboxis[i].checked = true;
}
}
}
</script> del_product.php
[php] view plaincopy
<?php
include('checkadmin.php');
header('Content-Type: text/html; charset=utf-8');
if($_POST['btnSave']){ if(empty($_POST['id'])){
echo"<script>alert('必须选择一个产品,才可以删除!');history.back(-1);</script>";
exit;
}else{
/*如果要获取全部数值则使用下面代码*/ $id= implode(",",$_POST['id']);
$str="DELETE FROM `product` where id in ($id)";
mysql_query($str);
echo "<script>alert('删除成功!');window.location.href='product_list.php';</script>";
}
}
?>

asp批量删除

<%@LANGUAGE="VBSCRIPT" CODEPAGE=""%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<!--#include file="inc_global.asp"-->
<%
current_nav = "b_6"
If reqf("submit") = "执行操作" Then
Call nullback(reqf("id"), "请至少选中一项!")
If reqf("r_method") = Then
Call infoback("请选择要执行的操作!")
ElseIf reqf("r_method") = Then
sql = "delete from cms_resume where id in ("&reqf("id")&")"
End If
conn.Execute(sql)
Call infohref ("执行成功!", "cms_resume.asp")
End If
%>
<title>管理后台-管理应聘</title>
<link href="style.css" rel="stylesheet" type="text/css" />
<script type="text/javascript">
function check_all(obj,cName)
{
var checkboxs = document.getElementsByName(cName);
for(var i=;i<checkboxs.length;i++){checkboxs[i].checked = obj.checked;}
}
</script>
</head>
<body>
<!--#include file="inc_top.asp"-->
<div id="content_main">
<div id="content_title"> </div>
<div id="content_body">
<!--#include file="inc_left.asp"-->
<div id="right">
<div class="right_title">
<h2>管理应聘</h2>
</div>
<div class="right_body">
<table class="common_table">
<form method="post">
<tr>
<th width="">选</th>
<th width="">应聘日期</th>
<th>应聘职位</th>
<th width="">应聘人</th>
<th width="">电话</th>
<th width="">详情</th>
</tr>
<!--循环开始-->
<%
sql = "select * from cms_resume order by r_date desc"
page_size =
pager = pageturner_handle(sql, "id", page_size)
Set rs = pager()
If rs.EOF Then
echo "暂无订单信息!"
End If
Do While Not rs.EOF %> <!--循环结束-->
<tr align="center">
<td>
<input name="ID" type="checkbox" id="ID" value="<%=rs("id")%>" />
</td>
<td><%=rs("r_date")%></td>
<td><%=rs("r_name")%></td>
<td><%=rs("r_username")%></td>
<td><%=rs("r_tel")%></td>
<td><a href="cms_resume_detail.asp?id=<%=rs("id")%>">详情</a></td>
</tr>
<%
rs.movenext
Loop
rs.Close
Set rs = Nothing
%>
<tr align="center">
<td>
<input name="ID" type="checkbox" onclick="check_all(this,'ID')" />
</td>
<td colspan="" align="left">
<select class="form_select" name="r_method">
<option value="">选择操作</option>
<option value="">删除应聘</option>
</select>
<input type="submit" name="submit" value="执行操作" />
</td>
</tr>
</form>
</table>
<%=pageturner_show(pager(),pager(),pager(),page_size,)%> </div>
<div class="right_bottom"></div>
</div>
<div class="clear"></div>
</div>
<div id="content_bottom"></div>
</div>
<!--#include file="inc_bottom.asp"-->
</body>
</html>