PHP全选择删除功能

JS 部分放HEAD

<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" onsubmit="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" onmouseover="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; ?>" onclick="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>";
}
}
?>


posted @ 2013-01-04 08:04  网络剑客  阅读(221)  评论(0)    收藏  举报