原声搜索分页删除

<?php
header("content-type:text/html;charset=utf-8");
mysql_connect("127.0.0.1","root","root");
mysql_select_db("js");
mysql_query("set names utf8");
$uname=isset($_GET['uname'])?$_GET['uname']:'';
$sql="select * from fenye";
$res=mysql_query($sql);
//总记录数
$total=mysql_num_rows($res);
//设置每页显示的条数
$pagenum=5;
//计算共多少页
$pagetotal=ceil($total/$pagenum);
//设置当前页
$page=isset($_GET['page'])?$_GET['page']:1;
//上一页
$up=$page-1<1?1:$page-1;
//下一页
$down=$page+1>$pagetotal?$pagetotal:$page+1;
//偏移量
$limit=($page-1)*$pagenum;
$sql="select * from fenye limit $limit,$pagenum";
$res=mysql_query($sql);
?>
<center>
<img src="111.jpg" alt="" style="width:500px;height: 200px;"/>
<div id="box">
    <!--搜索框-->
    <tr>
        <td><input type="text" id="uname" value="<?php echo $uname; ?>"/></td>
        <td><input type="button" value="查询" onclick="checkcha()"/></td>
    </tr>
<table border="1" width="500px">

    <tr>
        <td><a href="#" onclick="checkall()">全选</a></td>
        <td>编号</td>
        <td>用户名</td>
        <td>操作</td>
    </tr>
    <?php
    while($row=mysql_fetch_assoc($res)){
        ?>
        <tr>
            <td><input type="checkbox" name="checkpre" value="<?php echo $row['id']; ?>"/></td>
            <td><?php echo $row['id']; ?></td>
            <td><?php echo $row['uname']; ?></td>
            <td><a href="#" onclick="del(<?php echo $row['id'];?>,<?php echo $page; ?>)">删除</a></td>
        </tr>
    <?php
    }
    ?>
    <tr>
        <td colspan="2"><a href="#"onclick="revcheck()">反选</a></td>
        <td colspan="2"><a href="#"onclick="delall(<?php echo $page; ?>)">批量删除</a></td>

    </tr>
</table>
<a href="#" onclick="page(1)">首页</a>
<a href="#" onclick="page(<?php echo $up;?>)">上一页</a>
<a href="#" onclick="page(<?php echo $down;?>)">下一页</a>
<a href="#" onclick="page(<?php echo $pagetotal;?>)">尾页</a>
第<?php echo $page; ?>页
共<?php echo $pagetotal; ?>页
<input type="text" id='page' size="1">
<input type="button" value="GO!" onclick="show(<?php echo $pagetotal; ?>)">
</div>
<img src="222.jpg" alt="" style="width: 500px;height: 200px;"/>

</center>
<script>
 //ajax模糊查询
    function checkcha(){
        var uname=document.getElementById('uname').value;
        var  ajax=new XMLHttpRequest();
        ajax.open('get','do_ajax.php?uname='+uname,true);
        ajax.onreadystatechange= function () {
            if(ajax.readyState==4&&ajax.status==200){
                document.getElementById('box').innerHTML=ajax.responseText;
            }
        }
        ajax.send();
    }
    //反选
    function revcheck(){
        var checkpre=document.getElementsByName('checkpre');
        for(var i=0;i<checkpre.length;i++){
            checkpre[i].checked=!checkpre[i].checked;
        }
    }
    //全选
    function checkall(){
        var checkpre=document.getElementsByName('checkpre');
        for(var i=0;i<checkpre.length;i++){
            checkpre[i].checked='checked';
        }
    }


    //删除
    function del(id,page){
        var uname=document.getElementById('uname').value;
        var ajax=new XMLHttpRequest();
        ajax.open('get','do_ajax.php?page='+page+'&id='+id+'&uname='+uname,true);
        ajax.onreadystatechange=function(){
            if(ajax.readyState==4&&ajax.status==200){
                document.getElementById('box').innerHTML=ajax.responseText;
            }
        }
        ajax.send();
    }
    //批量删除
    function delall(page){
        var uname=document.getElementById('uname').value;
        var checkpre=document.getElementsByName('checkpre');
        var ids='';
        for(var i=0;i<checkpre.length;i++){
            if(checkpre[i].checked){
                ids+=checkpre[i].value+',';
            }
        }
        //干掉逗号
        ids=ids.substr(0,ids.lastIndexOf(','));

        var ajax=new XMLHttpRequest();
        ajax.open('get','do_ajax.php?ids='+ids+'&page='+page+'&uname='+uname,true);
        ajax.onreadystatechange=function(){
            if(ajax.readyState==4&&ajax.status==200){
                document.getElementById('box').innerHTML=ajax.responseText;
            }
        }
        ajax.send();
    }

    function show(pagetotal){
        var page=document.getElementById('page').value;
        if(page>pagetotal){
            page=pagetotal;
        }
        location.href='ajax.fenye.php?page='+page;
    }
    function page(page){
        var uname=document.getElementById('uname').value;
        //1.实例化ajax对象
        var ajax=new XMLHttpRequest();
        //2.open方法准备发请求
        ajax.open('get','do_ajax.php?page='+page+'&uname='+uname,true);
        ajax.send();
        //绑定监听事件
        ajax.onreadystatechange=function(){

            if(ajax.readyState==4 && ajax.status==200){
                document.getElementById('box').innerHTML=ajax.responseText;
            }
        }

    }

</script>

<?PHP
header("content-type:text/html;charset=utf-8");
mysql_connect("127.0.0.1","root","root");
mysql_select_db("js");
mysql_query("set names utf8");
$uname=isset($_GET['uname'])?$_GET['uname']:'';
if(isset($_GET['id'])){
    $id=$_GET['id'];
    $sql="delete from fenye where id='$id'";
    mysql_query($sql);
}
if(isset($_GET['ids'])){
    $ids=$_GET['ids'];
    $sql="delete from fenye where id in ($ids)";
    mysql_query($sql);
}


$sql="select * from fenye where uname like '%$uname%'";
$res=mysql_query($sql);
//总记录数
$total=mysql_num_rows($res);
//设置每页显示的条数
$pagenum=5;
//计算共多少页
$pagetotal=ceil($total/$pagenum);
//设置当前页
$page=isset($_GET['page'])?$_GET['page']:1;
//上一页
$up=$page-1<1?1:$page-1;
//下一页
$down=$page+1>$pagetotal?$pagetotal:$page+1;
//偏移量
$limit=($page-1)*$pagenum;


$sql="select * from fenye where uname like '%$uname%' limit $limit,$pagenum";
$res=mysql_query($sql);

?>
<center>
    <tr>
        <td><input type="text" id="uname" value="<?php echo $uname; ?>"/></td>
        <td><input type="button" value="查询" onclick="checkcha()"/></td>
    </tr>
<table border="1" width="500px">
    <tr>
        <td><a href="#" onclick="checkall()">全选</a></td>
        <td>编号</td>
        <td>用户名</td>
        <td>操作</td>
    </tr>

    <?php
    while($row=mysql_fetch_assoc($res)){
        ?>
        <tr>
            <td><input type="checkbox" name="checkpre" value="<?php echo $row['id']; ?>"/></td>
            <td><?php echo $row['id']; ?></td>
            <td><?php echo $row['uname']; ?></td>
            <td><a href="#" onclick="del(<?php echo $row['id'];?>,<?php echo $page; ?>)">删除</a></td>
        </tr>

    <?php
    }
    ?>
    <tr>
        <td colspan="2"><a href="#"onclick="revcheck()">反选</a></td>
        <td colspan="2"> <a href="#"onclick="delall(<?php if($page>1){
                echo $page-1;
            }else{
                echo $page;
            }; ?>)">批量删除</a></td>

    </tr>
</table>
<a href="#" onclick="page(1)">首页</a>
<a href="#" onclick="page(<?php echo $up;?>)">上一页</a>

<a href="#" onclick="page(<?php echo $down;?>)">下一页</a>
<a href="#" onclick="page(<?php echo $pagetotal;?>)">尾页</a>
第<?php echo $page; ?>页
共<?php echo $pagetotal; ?>页
<input type="text" id='page' size="1">
<input type="button" value="Go!" onclick="show(<?php echo $pagetotal; ?>)">
</center>