Loading

php 学生信息表小项目 扩展模仿百度分页的完全实现

 

 

<?php
include 'public.php';//链接数据库
$sql = "select * from stu";
$result = mysqli_query($conn,$sql);

//分页的实现
$page = isset($_GET['page']) ? $_GET['page'] : 1; //如果没有传值,默认为0
$pageShow = 5; //每页显示多少10个
$total = mysqli_num_rows($result); //信息总个数
$totalPages = ceil($total / $pageShow); //总页数
$pagesize = $page>=1 ? ($page-1)* $pageShow : 0; //禁止输入小于0的值,只显示首页
$sql .= " order by id desc limit $pagesize,$pageShow"; //查询从哪开始查询的条数
$result = mysqli_query($conn,$sql); //query执行

?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <script type="text/javascript" src="jquery.min.js" ></script>
    <title>学生信息表</title>
    <style>
        .page-wrap{
            float: left;
            width: 100%;
            text-align: center;
            margin-top: 20px;
        }
        .page-wrap span{
            display: inline-block;
            padding: 5px 10px;
            font-size:15px;
            color: #333;
            border: solid 0px #eee;
            margin: 0 5px;
        }
        .page-wrap a{
            display: inline-block;
            padding: 5px 10px;
            font-size:15px;
            color: #333;
            border: solid 1px #eee;
            margin: 0 5px;
            transition: all .3s;
        }
        .page-wrap a:hover{
            color: #222;
            border: solid 1px #999;
        }
    </style>
</head>
<body>
    <h2 style="float:left;width:100%;margin-top:50px; text-align:center">学生信息管理中心</h2>
    <div style="text-align:center">
    <a href="adds.php" style="padding:3px;font-size:16px;background-color:greenyellow">添加学生信息</a>
    共有<?php echo mysqli_num_rows($result); ?>个学生信息
    </div>
    <table style="margin-top:60px" align="center" width="60%" border="" cellspacing="0" cellpadding="0">
        <tr><th>id</th><th>姓名</th><th>性别</th><th>年龄</th><th>爱好</th><th>学历</th><th>工资</th><th>奖金</th><th>所在城市</th><th>操作</th></tr>
        <?php 
            if(mysqli_num_rows($result) > 0){
                while ($row = mysqli_fetch_assoc($result)) {
        ?>
        <tr style='background-color:aqua'>
            <td align="center"><?php echo  $row['id'];  ?></td>
            <td align="center"><?php echo  $row['name'];  ?></td>
            <td align="center"><?php echo  $row['sex'];  ?></td>
            <td align="center"><?php echo  $row['age'];  ?></td>
            <td align="center"><?php echo  $row['city'];  ?></td>
            <td align="center"><?php echo  $row['edu'];  ?></td>
            <td align="center"><?php echo  $row['salary'];  ?></td>
            <td align="center"><?php echo  $row['bonus'];  ?></td>
            <td align="center"><?php echo  $row['city'];  ?></td>
            <td align="center">
                <a href="edit.php?id=<?php echo  $row['id'];  ?>" style="color:forestgreen">修改</a> | <a href="javascript:del_sure(<?php echo  $row['id'];  ?>)" style="color:crimson">删除</a>
            </td>
        </tr>
        <?php   
             }
            }else{
                echo '没有数据';
            }
        ?>
    </table>
    <div class="page-wrap">
        <?php 

            $start = $page-5;
            $end = $page+4;
            
            if($page < 7 ){ //前面页面小于7的时候start从1开始,这样就不会出现负数
                $start =1;
                $end = 10;
            }
            if($page >= $totalPages-4){ //到后面 $start开始从总数减9开始  ,这样页码就不会多出来
                $start =$totalPages-9;
                $end = $totalPages;
            }
            if($totalPages < 10){  //如果小于10个分页 最后按钮等于总页数
                $start = 1;
                $end = $totalPages;
            }
            
            //上一页
            $page_prev = $page>1 ? $page - 1 : 1;
            if($page == 1){
                echo "<span style='color:#999'>上一页</span>";
            }else{
                echo "<a href='?page={$page_prev}'>上一页</a>";
            }//结束

            for($i=$start;$i<=$end;$i++)//从$start = $page-5;开始. 到$end = $page+4;结束.
            {
                if($page == $i)
                {
                    echo '<span>'.$i.'</span>';
                }else
                {
                    echo "<a href='?page={$i}'>".$i.'</a>';
                }
            }
            //下一页
            $page_next = $page != $totalPages ? $page + 1 : $totalPages;
            if($page == $totalPages){
                echo "<span style='color:#999'>下一页</span>";
            }else{
                echo "<a href='?page={$page_next}'>下一页</a>";
            }//结束
        ?>
    </div>
    <script>
        function del_sure(id){//形参
        if(confirm("确认删除吗") ==true){
            window.location.href="delete.php?id="+id;
        }else{
            return ;
        }
      }
    </script>
</body>
</html>

 

posted @ 2019-07-20 09:58  mingBolg  阅读(392)  评论(0)    收藏  举报