PHP全选择删除功能

最新推荐文章于 2021-04-15 11:16:27 发布

霸气工作室

最新推荐文章于 2021-04-15 11:16:27 发布

阅读量920

点赞数

分类专栏： 2017年之前

本文链接：https://blog.csdn.net/QIU1988YANG/article/details/54692195

版权

2017年之前专栏收录该内容

87 篇文章 0 订阅

订阅专栏

<script type="text/javascript" language="javascript">  
  function selectBox(selectType){  
  var checkboxis = document.getElementsByName("id[]");  
  if(selectType == "reverse"){  
  for (var i=0; i<checkboxis.length; i++){  
      //alert(checkboxis[i].checked);  
      checkboxis[i].checked = !checkboxis[i].checked;  
  }  
  }  
  else if(selectType == "all")  
  {  
  for (var i=0; i<checkboxis.length; i++){  
      //alert(checkboxis[i].checked);  
      checkboxis[i].checked = true;  
  }  
  }  
  }  
</script>

表单部分

<form id="form2" name="form2" method="post" action="del_product.php" οnsubmit="return checkF(this)">  
                <table width="100%" border="0" cellspacing="0" cellpadding="0">  
                    <tr>  
                        <td width="6%" height="30" 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" οnmοuseοver="this.style.background='#EEFAFF'; " onmouseout ="this.style.background='#ffffff'; this.style.bordercolor=''">  
                            <td height="30" 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; ?>" οnclick="return confirm('确定删除?')">删除</a></td>  
                        </tr>  
                        <?php  
                    }  
                    ?>  
                    <tr bgcolor="#EEFAFF">  
                          <td height="50" colspan="3" 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" οnsubmit="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=0; i<checkboxis.length; i++){  
                //alert(checkboxis[i].checked);  
                checkboxis[i].checked = !checkboxis[i].checked;  
            }  
        }  
        else if(selectType == "all")  
        {  
            for (var i=0; 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="65001"%>
<!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") = 0 Then
        Call infoback("请选择要执行的操作！")
    ElseIf reqf("r_method") = 1 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=0;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="40">选</th>
                            <th width="160">应聘日期</th>
                            <th>应聘职位</th>
                            <th width="120">应聘人</th>
                            <th width="120">电话</th>
                            <th width="40">详情</th>
                        </tr>
                        <!--循环开始-->
                        <%
sql = "select * from cms_resume order by r_date desc"
page_size = 50
pager = pageturner_handle(sql, "id", page_size)
Set rs = pager(0)
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" οnclick="check_all(this,'ID')" />
                            </td>
                            <td colspan="5" align="left">
                                <select class="form_select" name="r_method">
                                    <option value="0">选择操作</option>
                                    <option value="1">删除应聘</option>
                                </select>
                                <input type="submit" name="submit" value="执行操作" />
                            </td>
                        </tr>
                    </form>
                </table>
                <%=pageturner_show(pager(1),pager(2),pager(3),page_size,5)%> </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>

霸气工作室

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
PHP全选择删除功能

"text/javascript" language="javascript"> function selectBox(selectType){ var checkboxis = document.getElementsByName("id[]"); if(selectType == "reverse"){ for (var i=0; i){
复制链接

扫一扫