<?php header("content-type:text/html;charset=utf-8"); //用PDO连接数据库 $pdo = new PDO('mysql:host=localhost;dbname=lisi','root','root'); //设置字符集 $pdo->query('set names utf8'); $sql = "select * from `user`"; $res= $pdo->query($sql)->fetchAll(); //print_r($res); ?> <div class="div"> <table border="1"> <tr> <td> <a href="javascript:void(0)" class="checkall">全选</a> <a href="javascript:void(0)" class="recheck">反选</a> </td> <td>用户名</td> <td>年龄</td> <td>操作</td> </tr> <?php foreach($res as $k=>$v){?> <tr id="tr_<?php echo $v['id']?>"> <td> <input type="checkbox" class="checkper" value="<?php echo $v['id']?>"> </td> <td><?php echo $v['username'] ?></td> <td><?php echo $v['userage']?></td> <td> <a href="javascript:void(0)" value=<?php echo $v['id']?> class="del">删除</a> </td> </tr> <?php }?> <tr colspan="4"> <td> <a href="javascript:void(0)" class="delall">批量删除</a> </td> </tr> </table> </div> <script src="../../jquery.1.12.js"></script> <script> $(function(){ //单删 $(".del").click(function(){ var id = $(this).attr("value"); //alert(id) $.ajax({ type: "get", url: "pishan_pro.php", data: "id="+id, success: function(msg){ if(msg==1){ $('#tr_'+id).remove() }else{ } } }); }) //全选 $(".checkall").click(function(){ for(var i=0;i<$(".checkper").length;i++){ $('.checkper')[i].checked = 'checked' } }) //反选 $(".recheck").click(function(){ for(var i=0;i<$(".checkper").length;i++){ $(".checkper")[i].checked =!$(".checkper")[i].checked } }) //批量删除 $(".delall").click(function(){ var ids = ""; //拼接id for(var i=0;i<$(".checkper").length;i++){ if($(".checkper")[i].checked){ ids +=$(".checkper").eq(i).attr("value")+',' } } //alert(ids) ids = ids.substr(0,ids.lastIndexOf(',')) $.ajax({ type: "get", url: "pishan_pro.php", data: "ids="+ids, success: function(msg){ if(msg==1){ } } }); }) }) </script> 另一个处理页面<?php //单删 //连接数据库 $pdo = new PDO('mysql:host=localhost;dbname=lisi','root','root'); //单删 $id = $_GET['id']; $sql = "delete from `user` WHERE id='$id'"; $res = $pdo->exec($sql); if($res){ echo 1; }else{ echo 0; } //批删 $ids = $_GET['ids']; $sql = "delete from `user` where id in ($ids)"; $res = $pdo->exec($sql); if($res){ echo 1; }
jquery 全选,反选,单删,批删
最新推荐文章于 2022-08-30 08:53:24 发布