<!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title></title> <style type="text/css"> table{ width:800px; height:1px solid red; border-collapse:collapse; } table tr th,table tr td{ border:1px solid red; size:12px; } </style> <script src="js/jq8.js"></script> <script> //jQ测试环境是在1.8.3，2.X版本出现了问题 jQuery.fn.extend({ qx:function(){ this.attr('checked',true); }, bx:function(){ this.attr('checked',false); }, fx:function(){ for(var i=0;i<this.length;i++){ if(this[i].checked == true){ this[i].checked = false; }else{ this[i].checked = true; } } } }); $(function(){ $('#btnqx').bind('click',function(){ $(':checkbox').qx(); }); $('#btnbx').bind('click',function(){ $(':checkbox').bx(); }); $('#btnfx').bind('click',function(){ $(':checkbox').fx(); }); }); </script> </head> <body> <form action="" method="POST"> <table> <tr> <th>编号</th> <th>帐号</th> <th>注册时间</th> <th>操作</th> </tr> <?php mysql_connect('localhost','root','') or die('数据库连接失败'); mysql_select_db('xsphp'); mysql_set_charset('utf8'); //组装sql语句 $sql = 'select * from admin limit 10'; $res = mysql_query($sql); while($row = mysql_fetch_assoc($res)){ ?> <tr> <td><?php echo $row['id']; ?></td> <td><?php echo $row['username']; ?></td> <td><?php echo date('Y-m-d h:i:s',$row['addtime']); ?></td> <td><input type="checkbox" name="id[]" value="<?php echo $row['id']; ?>" /></td> </tr> <?php } ?> <tr> <td align="right" colspan="4"> <input type="button" id="btnqx" value="全选"> <input type="button" id="btnbx" value="全不选"> <input type="button" id="btnfx" value="反选"> <input type="submit" name="sub" id="btnok" value="批量删除"> </td> </tr> </table> </form> </body> </html> <?php if($_POST['sub']){ $id = $_POST['id']; $ids = implode(',',$id); //批量删除 $sql = "delete from admin where id in($ids)"; echo $sql; } ?>