原声搜索分页删除

最新推荐文章于 2022-07-28 17:29:32 发布

wjn_123

最新推荐文章于 2022-07-28 17:29:32 发布

阅读量220

点赞数 2

本文链接：https://blog.csdn.net/wjn_123/article/details/53636836

版权

<?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="查询" οnclick="checkcha()"/></td>
    </tr>
<table border="1" width="500px">

    <tr>
        <td><a href="#" οnclick="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="#" οnclick="del(<?php echo $row['id'];?>,<?php echo $page; ?>)">删除</a></td>
        </tr>
    <?php
    }
    ?>
    <tr>
        <td colspan="2"><a href="#"οnclick="revcheck()">反选</a></td>
        <td colspan="2"><a href="#"οnclick="delall(<?php echo $page; ?>)">批量删除</a></td>

    </tr>
</table>
<a href="#" οnclick="page(1)">首页</a>
<a href="#" οnclick="page(<?php echo $up;?>)">上一页</a>
<a href="#" οnclick="page(<?php echo $down;?>)">下一页</a>
<a href="#" οnclick="page(<?php echo $pagetotal;?>)">尾页</a>
第<?php echo $page; ?>页
共<?php echo $pagetotal; ?>页
<input type="text" id='page' size="1">
<input type="button" value="GO!" οnclick="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="查询" οnclick="checkcha()"/></td>
    </tr>
<table border="1" width="500px">
    <tr>
        <td><a href="#" οnclick="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="#" οnclick="del(<?php echo $row['id'];?>,<?php echo $page; ?>)">删除</a></td>
        </tr>

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

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

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