php+mysql实现分页显示

超、凢脫俗 2022-12-29 09:54 207阅读 0赞

数据库部分

DROP TABLE IF EXISTS `guestbook`;
    CREATE TABLE `guestbook` (
      `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
      `nickname` char(15) NOT NULL DEFAULT '',
      `email` varchar(100) NOT NULL DEFAULT '',
      `content` text NOT NULL,
      `createtime` int(10) unsigned NOT NULL DEFAULT '0',
      PRIMARY KEY (`id`)
    ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
    INSERT INTO `guestbook` VALUES ('1', 'admin', 'admin@qq.com', '123', '123456');
    INSERT INTO `guestbook` VALUES ('2', 'admin', 'admin@qq.com', '456', '123456');
    INSERT INTO `guestbook` VALUES ('3', 'admin', '03254', '留言测试', '123456');
    INSERT INTO `guestbook` VALUES ('4', 'admin', 'admin@qq.com', '留言测试', '123456');
    INSERT INTO `guestbook` VALUES ('5', 'admin', 'admin@qq.com', '留言测试', '123456');
    INSERT INTO `guestbook` VALUES ('6', 'admin', '789465', '留言测试', '123456');
    INSERT INTO `guestbook` VALUES ('7', 'admin', 'admin@qq.com', '留言测试', '123456');
    INSERT INTO `guestbook` VALUES ('8', 'admin', 'admin@qq.com', '留言测试', '123456');
    INSERT INTO `guestbook` VALUES ('9', 'admin', 'admin@qq.com', '留言测试', '123456');
    INSERT INTO `guestbook` VALUES ('10', 'admin', '4564saf', '留言测试', '123456');
    INSERT INTO `guestbook` VALUES ('11', 'admin', 'admin@qq.com', '留言测试', '123456');

<?php
        //数据库连接
        $link=mysqli_connect('localhost','Test','000000','Test');
    
        if(!$link){ 
            die("Couldn't connect'");
        }
        
        //每页显示的留言数
        $pagesize=4;
    
        //确定当前页数$p的参数
        $p=$_GET["p"]?$_GET['p']:1; //三元运算符，如果存在p=$_get["p"]否则p=1
        //数据指针
        $offset=($p-1)*$pagesize;
    
        //查询本页显示的数据
        $sql="select * from guestbook order by id limit $offset,$pagesize";
        $result=mysqli_query($link,$sql);
        //循环输出
        while($gblist=mysqli_fetch_array($result)){ 
            echo '<a href="',$gblist['nickname'],'">',$gblist['nickname'],'</a> ';
            echo '发表于：',date("Y-m-d H:i", $gblist['createtime']),'<br />';
            echo '内容：',$gblist['content'],'<br /><hr />';
        }
    
        //分页代码
        //计算留言总数
        $count_result=mysqli_query($link,"select count(*) from guestbook");
        //一共有count_result条记录
        $count_array=mysqli_fetch_array($count_result);
        // var_dump($count_array);
        //计算总的页数
        $pagenum=ceil($count_array['count(*)']/$pagesize);
        echo "共",$count_array['count(*)'],' 条留言';
        //循环输出各页数目及连接
        if ($pagenum > 1) { 
            for($i=1;$i<=$pagenum;$i++) { 
                if($i==$p) { 
                    echo ' [',$i,']';
                } else { 
                    echo ' <a href="index.php?p=',$i,'">',$i,'</a>';
                }
            }
        }
    ?>