PHP代码
//展示视频信息
case 'videoinformation';
$gid = intval($_GET['id']);
$count= $db -> query("SELECT count(*) AS count FROM `ttf_videos` ");
$num = mysql_fetch_array($count,MYSQLI_ASSOC);
$num = $num['count'];//统计某分类视频总条数
$pagesize=8; //设置每页显示8个记录
$url=$_SERVER["REQUEST_URI"];//取出URL
$url=parse_url($url);
$pagetotal = ceil($num/$pagesize);//需要显示得总页数
$page = isset($_GET['page']) ? $_GET['page'] : 1;//如果存在get就用get 不存在赋值为1
$url=$url['path'].'?action=videoinformation&id='.$gid.''; //设置URL
$start = ($page-1)*$pagesize;//偏移量
//根据页数获取数据
$result =$db -> query("SELECT * FROM `ttf_videos` ORDER BY `id` DESC LIMIT $start, $pagesize ");
while($row = mysql_fetch_array($result,MYSQLI_ASSOC)){
$data[] = $row;
}
//赋值给上一页下一页
$prev = $page-1 < 1 ? 1 : $page-1;
$next = $page+1 > $pagetotal ? $pagetotal : $page+1;
$prev = " <a href=$url&page=".$prev.">上一页</a>";
$next = " <a href=$url&page=".$next.">下一页</a>";
include './admin/videoinformation.html';
HTML代码
<div class="pagination-container text-center">
<ul class="pagination">
<!--<li>共<?php echo $pagetotal;?></li> -->
<li>
<a href="<?php echo $url.'&page=1'; ?> " >首页</a>
<div class="pagination-hvr"></div>
</li>
<!--上一页-->
<li>
<?php echo $prev;?>
</li>
<!--循环页数-->
<?php for($i=0;$i<$pagetotal;$i++){ ?>
<li <?php if($page == ($i+1)){ ?> class="active" <?php } ?>>
<a href="<?php echo $url.'&page='.($i+1); ?>"><?php echo $i+1; ?></a>
<div class="pagination-hvr"></div>
</li>
<?php } ?>
<!--下一页-->
<li>
<?php if($page != $pagetotal)echo $next;?>
</li>
<li>
<a href="<?php echo $url.'&page='.$pagetotal; ?>"><?php if($page != $pagetotal)echo '尾页';?></a>
<div class="pagination-hvr"></div>
</li>
</ul>
</div>