全选，反选，搜索，分页，批量删除，删除

<?php
//连接数据库
@mysql_connect('127.0.0.1','root','root');
//选择数据库
mysql_select_db('ajax');
//设置字符集
mysql_query('set names utf8');
//拼写sql语句
$sql="select count(id) as count from lianxi";
$str=mysql_query($sql);
$results=mysql_fetch_assoc($str);
$count=$results['count'];
//设置每页数据条数
$number=3;
//总页数
$page_count=ceil($count/$number);
//默认页数
$page=isset($_GET['page'])?$_GET['page']:1;
//判断页数合法性
if($page<=0){
    $page=1;
}
if($page>$page_count){
    $page=$page_count;
}
//从0开始
$state=($page-1)*$number;
//查询数据
$sqll="select * from lianxi limit $state,$number";
//取结果
$result=mysql_query($sqll);
?>
<meta charset="utf-8"/>
<input type="text" id="sousuo"><input type="button" value="搜索" οnclick="check_ss();">
<div id="u_sousuo">
<div id="fenye">
<table border="1">
    <th>序号</th>
    <th>名称</th>
    <th>状态</th>
    <th>操作</th>
    <?php
     while(@$arr=mysql_fetch_assoc($result)){
    ?>
         <tr>
             <td><input type="checkbox" name="checkbox" id="<?php echo $arr['id']?>"><?php echo $arr['id']?></td>
             <td><?php echo $arr['name']?></td>
             <td><a href="javascript:void(0);" οnclick="check_sd(this,<?php echo $arr['id']?>);"><?php echo $arr['state']?"锁定":"未锁定";?></a></td>
             <td><a href="javascript:void(0);" οnclick="check_sc(this,<?php echo $arr['id']?>);">删除</a> </td>
         </tr>
    <?php
     }
    ?>
    <tr>
        <td colspan="7" align="center">
            <input type="checkbox" id="quan" οnclick="check_quan();">全选/全不选
            <input type="button" id="fan" οnclick="check_fan();" value="反选">
            <input type="button" id="pl" οnclick="check_pl();" value="批量删除">
            <a href="javascript:void(0);" οnclick="check_fenye(1);">首页</a>
            <a href="javascript:void(0);" οnclick="check_fenye(<?php echo $page+1?>);">下一页</a>
            <a href="javascript:void(0);" οnclick="check_fenye(<?php echo $page-1?>);">上一页</a>
            <a href="javascript:void(0);" οnclick="check_fenye(<?php echo $page=$page_count?>);">尾页</a>
        </td>
    </tr>
</table>
    </div>
</div>
<style>
    ul li{
        list-style: none;
        float: left;
        width: 150px;
    }
</style>
<div style="width:600px;float:left;">
        <ul>
            <li><img src="upload/14697554706662.jpg" width="145" height="100" alt=""/></li>
            <li><img src="upload/14697554706662.jpg" width="145" height="100" alt=""/></li>
            <li><img src="upload/14697554706662.jpg" width="145" height="100" alt=""/></li>
            <li><input type='checkbox'></li>
            <li><input type='checkbox'></li>
            <li><input type='checkbox'></li>
        </ul>
</div>
<script>
    //锁定
    function check_sd(obj,id){
        var ajax=new XMLHttpRequest();
        ajax.onreadystatechange=function(){
            if(ajax.readyState==4 && ajax.status==200){
               if(ajax.responseText==1){
                   if(obj.innerHTML=="锁定"){
                       obj.innerHTML="未锁定";
                   }else if(obj.innerHTML=="未锁定"){
                       obj.innerHTML="锁定";
                   }
               }
            }
        }
        ajax.open('get','exam_sd.php?id='+id,false);
        ajax.send(null);
    }
    //全选
    function check_quan(){
        var num=document.getElementsByName('checkbox');
        var quan=document.getElementById('quan');
        if(quan.checked){
            for(var i=0;i<num.length;i++){
                num[i].checked=true;
            }
        }else{
            for(var i=0;i<num.length;i++){
                num[i].checked=false;
            }
        }
    }
    //反选
    function check_fan(){
        var num=document.getElementsByName('checkbox');
        for(var i=0;i<num.length;i++){
            if(num[i].checked){
                num[i].checked=false;
            }else{
                num[i].checked=true;
            }
        }
    }
    //批量删除
    function check_pl(){
        var num=document.getElementsByName('checkbox');
        var str='';
        for(var i=0;i<num.length;i++){
            if(num[i].checked){
                str=str+num[i].id+',';
            }
        }
        var id=str.substr(0,str.length-1);
        var ajax=new XMLHttpRequest();
        ajax.onreadystatechange=function(){
            if(ajax.readyState==4 && ajax.status==200){
                //alert(ajax.responseText);return false;
                if(ajax.responseText!=0){
                    for(var i= num.length-1;i>=0;i--){
                        if(num[i].checked){
                            num[i].parentNode.parentNode.parentNode.removeChild(num[i].parentNode.parentNode);
                        }
                    }
                }else{
                    alert('删除失败');
                }
            }
        }
        ajax.open('post','exam_pl.php',true);
        ajax.setRequestHeader('Content-Type','application/x-www-form-urlencoded');
        ajax.send('id='+id);
    }
    //删除
    function check_sc(obj,id){
        var ajax=new XMLHttpRequest();
        ajax.onreadystatechange=function(){
            if(ajax.readyState==4 && ajax.status==200){
                //alert(ajax.responseText);return false;
                if(ajax.responseText!=0){
                    obj.parentNode.parentNode.parentNode.removeChild(obj.parentNode.parentNode);
                }
            }
        }
        ajax.open('get','exam_sc.php?id='+id,false);
        ajax.send(null);
    }
    //分页
    function check_fenye(page){
        var ajax=new XMLHttpRequest();
        ajax.onreadystatechange=function(){
            if(ajax.readyState==4 && ajax.status==200){
                document.getElementById('fenye').innerHTML=ajax.responseText;
            }
        }
        ajax.open('get','exam_fenye.php?page='+page,true);
        ajax.send(null);
    }
    //搜索后分页
    function check_ssfy(page){
        //alert(page);return false;
        var sousuo=document.getElementById('sousuo').value;
        //alert(sousuo);return false;
        var ajax=new XMLHttpRequest();
        ajax.onreadystatechange=function(){
            if(ajax.readyState==4 && ajax.status==200){
                //alert(ajax.responseText);return false;
                document.getElementById('u_sousuo').innerHTML=ajax.responseText;
            }
        }
        ajax.open('get','exam_ss.php?page='+page+'&sousuo='+sousuo,true);
        ajax.send(null);
    }
    //搜索
    function check_ss(){
        var sousuo=document.getElementById('sousuo').value;
        if(sousuo==""){
            alert('搜索不能为空');return false;
        }else{
            var ajax=new XMLHttpRequest();
            ajax.onreadystatechange=function(){
                if(ajax.readyState==4 && ajax.status==200){
                    //alert(ajax.responseText);return false;
                    document.getElementById('u_sousuo').innerHTML=ajax.responseText;
                }
            }
            ajax.open('get','exam_ss.php?sousuo='+sousuo,false);
            ajax.send(null);
        }
    }
</script>