分页.php

来源：互联网发布：淘宝耳环好卖吗编辑：程序博客网时间：2024/05/17 09:07
<!doctype html><html lang="en"><head>    <meta charset="UTF-8">    <meta name="viewport"          content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">    <meta http-equiv="X-UA-Compatible" content="ie=edge">    <title>Document</title>    <style>        table{            border:1px solid gainsboro;        }        th,tr,td{            border:1px solid deeppink;        }    </style></head><body>    <table>        <th>id</th>        <th>用户名</th>        <th>密码</th>        <th>电话</th>        <?php            require_once "initsql.php";            define("PAGE_COUNT",5);            if ($_GET){                $page = @$_GET["page"];            }else{                $page = 0;            }            $start = $page * PAGE_COUNT;            $sql = "SELECT * FROM user LIMIT {$start},5";            $result = mysql_query($sql);            while($row = mysql_fetch_assoc($result)){                echo "<tr>";                foreach ($row as $value){                    echo "<td>";                    echo $value;                    echo "</td>";                }                echo "</tr>";            }        ?>    </table>    <?php        $sql = "SELECT COUNT(id) FROM user";        $result = mysql_query($sql);        $row = mysql_fetch_row($result);        // 总条数        $count = $row[0];        // 上一页        if ($page > 0){            $lastPage = $page - 1;            echo "<a href='fenye2.php?page= $lastPage}'>上一页</a>";        }        for($i = 0; $i < ceil($count / 5); $i++){            $showPage = $i + 1;            echo "<a href='fenye2.php?page={$i}'>{$showPage}</a>";        }        // 下一页        if ($page < ceil($count / 5) - 1){            $nexttPage = $page + 1;            echo "<a href='fenye2.php?page={$nexttPage}'>下一页</a>";        }    ?></body></html>
0 0