jquery 全选，反选，单删，批删

来源：互联网发布：黑马程序员贴吧编辑：程序博客网时间：2024/05/23 23:12
<?phpheader("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;}
0 0