php分页显示例子

最新推荐文章于 2021-04-11 13:10:43 发布

牵手生活

最新推荐文章于 2021-04-11 13:10:43 发布

阅读量404

点赞数

分类专栏： php开发知识体系整理

本文链接：https://blog.csdn.net/caizhigui/article/details/53332106

版权

php开发知识体系整理专栏收录该内容

9 篇文章 0 订阅

订阅专栏

php分页显示例子

数据结构参见：mysql 创建数据库、表结构

<html>
<head>
    <meta http-equiv="CONTENT-TYPE" content="text/html; charset=utf-8">
</head>

<style>
    body{
        font-size: 12px;
        width: 100%;
    }
    div.page_bannar{
        text-align: center;

    }
    div.page_bannar a {
        border: #aaaadd 1px solid;padding: 2px 5px 2px 5px ;text-decoration: none;margin: 2px;
    }

    div.title  {
        padding: 2px 5px 2px 5px;color: #5d41ff;text-align: center;
    }
    div.page_bannar span.current{
        border:#000099 1px solid;background-color: #000099;padding: 4px 6px 4px 6px; margin: 2px;color: white;

    }


    div.content  {
        text-align: center;height: 300px;
    }


    div.page_bannar form{
        display: inline;  /*不换行*/
    }


</style>

<body>
<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2016/11/21
 * Time: 21:51
 *     //传入页码
//根据页码取出数据：php->mysql处理
//显示数据(显示数据和显示分页条）
 */
//require 'mysql_pdo_connect.php';
    /**===1传入页码=====**/
    if(isset($_GET['p'])){
        $page = $_GET['p'];   //get参数存放到page参数
    }else{
        $page = 1;
    }


    //    echo  '参数p='.$page."<br>";
    echo "<div class ='title'>插件日志查询 </div><br>";

    /**====根据页码取出数据：php->mysql处理  =====**/
    $host = "localhost:3306";
    $username = "a2393827_zhigui";
    $passwoed = "mysql2000";
    $db = "wechatplugin";



    $conn = mysql_connect($host,$username, $passwoed);



//     print_r($conn) ;
    if (!$conn) {
        echo "数据库连接失败";
        die(mysql_error());
        exit;
    }


    //选择所要操作的数据库
    mysql_select_db("wechatplugin", $conn);
    ;
    /**=====设置编码方式为utf8 =======**/
    mysql_query("SET NAMES 'utf8'");
    mysql_query("SET CHARACTER SET utf8");
    mysql_query("SET CHARACTER_SET_RESULT=utf8");

    $pagesize = 10;
    $showpage = 5 ;//要显示的页码

    //编写sql获取分页数据SELECT * FROM plugin_userLog LIMIT 起始位置, 显示条数
    //$sql ="SELECT * FROM plugin_userLog LIMIT 2, 10"
    $sql="select * from plugin_userLog LIMIT ".($page-1)*$pagesize.",".$pagesize;


//    echo $sql."<br>";
//    $result = mysqli_query($sql);
    $result = mysql_query($sql);
    //处理我们的数据
//while ($row = mysql_fetch_assoc($result)){
//    echo $row['pluginName'].$row['wechatVersion'].$row['alias'].$row['logType']
//        .$row['tag'].$row['logInfo'].$row['logDatatime']
//        ."<br>";
//}
    echo "<div class='content'>";
    echo "<table border='1' cellspacing=0 width=80% align=center>";
    echo "<tr>";
        echo "<td align='center'>插件</td>";
        echo "<td align='center'>微信版本</td>";
        echo "<td align='center'>微信号</td>";
        echo "<td align='center'>logType</td>";

        echo "<td align='center'>TAG标签</td>";

        echo "<td align='center'>日志</td>";
        echo "<td align='center'>时间</td>";
    echo "</tr>";


    while ($row = mysql_fetch_assoc($result)){
        echo "<tr>";
        echo "<td >{$row['pluginName']}</td>";
        echo "<td>{$row['wechatVersion']}</td>";
        echo "<td>{$row['alias']}</td>";
        echo "<td align='center'>{$row['logType']}</td>";
        echo "<td>{$row['tag']}</td>";
        echo "<td>{$row['logInfo']}</td>";
        echo "<td align='center'>{$row['logDatetime']}</td>";
        echo "</tr>";
    }
    echo "</table>" ;
    echo "</div>";
    //释放结果，关闭链接
    mysql_free_result($result);
    //获取数据总记录数
    $total_sql = "select count(*) from plugin_userLog";
    $total_result = mysql_fetch_array(mysql_query($total_sql));
    $total = $total_result[0];

    //计算页数
    $total_pages = ceil($total/$pagesize);  //总共多少页
    echo "总记录数：".$total."总页数:".$total_pages."<br>";
    mysql_close($conn);
    $page_bannar = "<div class ='page_bannar''>";


    if ($page>1){
        $page_bannar .= "<a href='".$_SERVER['PHP_SELF']."?p=1'><首页</a>";
        $page_bannar .= "<a href='".$_SERVER['PHP_SELF']."?p=".($page-1)."'><上一页</a>";
    }

    $pageOffset =  ($showpage-1)/2; //计算偏移量
    $start =1;
    $end = $total_pages;
    if($total_pages>$showpage){
        if ($page>$pageOffset+1){
            $page_bannar .="...";
        }
        if ($page>$pageOffset){
            $start = $page - $pageOffset;
            $end = $total_pages >$page+$pageOffset ? $page+$pageOffset : $total_pages;
        }else{
            $start =1;
            $end = $total_pages>$showpage ? $showpage:$total_pages;
        }
        if($page+$pageOffset>$total_pages){
            $start = $start -($page + $pageOffset -$end);

        }

    }
    //页码跳转
    for($i=$start;$i<=$end;$i++){
        if ($page ==$i){  //当前页与页码相等是的
            $page_bannar .= "<span class ='current'>{$i}</span>";
        }else{
            $page_bannar .= "<a href='".$_SERVER['PHP_SELF']."?p=".$i."'>{$i}</a>";
        }


    }
    //尾部省略号
    if ($total_pages>$showpage && $total_pages>$page+$pageOffset){
        $page_bannar .="...";

    }
    if ($page<$total_pages){
        $page_bannar .= "<a href='".$_SERVER['PHP_SELF']."?p=".($page+1)."'>下一页></a>";
        $page_bannar .= "<a href='".$_SERVER['PHP_SELF']."?p=".$total_pages."'>尾页></a>";
    }
    $page_bannar .= "共{$total_pages}页，";
    $page_bannar .= "<form action='userLog.php' method='get'>";
    $page_bannar .="到第<input type='text' size='2' name='p'>页";
    $page_bannar .="<input type='submit' value='确定'>";
    $page_bannar .="</form></div>";



    /**=====显示数据(显示数据和显示分页条=====**/

    echo $page_bannar;

?>
</body>
</html>

牵手生活

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
打赏
0
评论
php分页显示例子

php分页显示例子html>head> meta http-equiv="CONTENT-TYPE" content="text/html; charset=utf-8">head>style> body{ font-size: 12px; width: 100%; } div.page_bannar{
复制链接

扫一扫