我这个系统是一个音频网站,所有的音频数据都是写在一个字段里,如果有几千条的话!不做分页的话打开网站基本是会卡死的。分享下前台和后台代码给大家,希望功能学习
演示站点:http://vi.huixuetong.com.cn/?s=vod-read-id-120.html

后台代码//分页开始
$rs = M('Vod');
$user = array();
$user['q_islock'] = $_REQUEST['q_islock'];
$selectType = $_REQUEST['q_selectType'];
$wd = urldecode(trim($_REQUEST['wd']));
$user['selectType'] = $selectType;
$user['wd'] = $wd;
$user['p'] = '';

if ($user['q_islock'] == 1) {
$where['islock'] = array('eq', 1);
}
else if ($user['q_islock'] == 2) {
$where['islock'] = array('eq', 0);
}

if (!empty($selectType) && !empty($wd)) {
$where[$selectType] = array('like', '%' . $wd . '%');
}
$ida=$_GET['id'];
$vod_url=$rs->where("vod_id=$ida")->getfield("vod_url");
$count=(substr_count($vod_url,"$")-3)/2;
$limit = C('url_num_admin');
$totalpages = ceil($count / $limit);
$currentpage = (!empty($_GET['p']) ? intval($_GET['p']) : 1);
$currentpage = get_maxpage($currentpage, $totalpages);
$pageurl = U('/read-id-'.$ida, $user, false, false) . '{!page!}' . C('url_html_suffix');
$user['p'] = $currentpage;
$_SESSION['user_jumpurl'] = U('/read-id-'.$ida, $user) . C('url_html_suffix');
$page = '共' . $count . '个 当前:' . $currentpage . '/' . $totalpages . '页 ' . getpage($currentpage, $totalpages, 3, $pageurl, 'pagego(\'' . $pageurl . '\',' . $totalpages . ')');
$user['page'] = $page;
$f['currentpage']=$currentpage;
$sq['vod_id']=$ida;
$vod_playlist=$rs->find($ida);
$this->assign($f);
$this->assign($user);
//分页结束模板代码块<php>$fj=($currentpage-1)*20</php>
<volist name="gxlcms_playlist" id="gxlcms">
<if condition="$gxlcms.playname eq ts">
<fflist name="gxlcms['son']" id="gxlcmsson" order="asc" offset="$fj" length='20'>

<li ><time>更新时间:{$vod_addtime|date='Y-m-d H:i:s',###}</time><i class="icon-play-d"></i><a href="{$gxlcmsson.playurl}">{$gxlcmsson.playname}</a></li>
</fflist>

</if> </volist>

评论() 相关

收藏

赞

g13721792528

ThinkPHP 是一个免费开源的,快速、简单的面向对象的 轻量级PHP开发框架 ,创立于2006年初,遵循Apache2开源协议发布,是为了敏捷WEB应用开发和简化企业应用开发而诞生的。ThinkPHP从诞生以来一直秉承简洁实用的设计原则,在保持出色的性能和至简的代码的同时,也注重易用性。并且拥有众多的原创功能和特性,在社区团队的积极参与下,在易用性、扩展性和性能方面不断优化和改进,已经成长为国内最领先和最具影响力的WEB应用开发框架,众多的典型案例确保可以稳定用于商业以及门户级的开发。