首页 ν 建站知识 ν 帝国CMS原生PHP实现上一篇下一篇浏览量收藏文章海报

帝国CMS原生PHP实现上一篇下一篇，没有上一篇或者下一篇的时候返回当前栏目名称和链接。
按ID排序：

<?php
/*
$infopre; // 上一篇
$infonext; // 下一篇
*/
// 上一篇
$pre_r = $empire->fetch1("select isurl,titleurl,classid,id,title from {$dbtbpre}ecms_" . $class_r[$GLOBALS['navclassid']]['tbname'] . " where id<{$navinfor['id']} and classid='{$GLOBALS['navclassid']}' order by id DESC limit 1");
if(empty($pre_r['id'])){
$infopre = '<a href="' . sys_ReturnBqClassUrl($class_r[$GLOBALS['navclassid']]) . '">'. $class_r[$GLOBALS['navclassid']]['classname'] . '</a>';
}else{
$infopre = '<a href="' . sys_ReturnBqTitleLink($pre_r) . '">' . $pre_r['title'] . '</a>';
}
// 下一篇
$next_r = $empire->fetch1("select isurl,titleurl,classid,id,title from {$dbtbpre}ecms_" . $class_r[$GLOBALS['navclassid']]['tbname'] . " where id>{$navinfor['id']} and classid='{$GLOBALS['navclassid']}' order by id limit 1");
if(empty($next_r['id'])){
$infonext = '<a href="' . sys_ReturnBqClassUrl($class_r[$GLOBALS['navclassid']]) . '">'. $class_r[$GLOBALS['navclassid']]['classname'] . '</a>';
}else{
$infonext = '<a href="' . sys_ReturnBqTitleLink($next_r) . '">' . $next_r['title'] . '</a>';
}
?>
上一篇：<?=$infopre?><br >
下一篇：<?=$infonext?>

按发布时间newstime排序：

<?php
/*
$infopre; // 上一篇
$infonext; // 下一篇
*/
// 上一篇
$pre_r = $empire->fetch1("select isurl,titleurl,classid,id,title from {$dbtbpre}ecms_" . $class_r[$GLOBALS['navclassid']]['tbname'] . " where newstime<{$navinfor['newstime']} and classid='{$GLOBALS['navclassid']}' order by newstime DESC limit 1");
if(empty($pre_r['id'])){
$infopre = '<a href="' . sys_ReturnBqClassUrl($class_r[$GLOBALS['navclassid']]) . '">'. $class_r[$GLOBALS['navclassid']]['classname'] . '</a>';
}else{
$infopre = '<a href="' . sys_ReturnBqTitleLink($pre_r) . '">' . $pre_r['title'] . '</a>';
}
// 下一篇
$next_r = $empire->fetch1("select isurl,titleurl,classid,id,title from {$dbtbpre}ecms_" . $class_r[$GLOBALS['navclassid']]['tbname'] . " where newstime>{$navinfor['newstime']} and classid='{$GLOBALS['navclassid']}' order by newstime limit 1");
if(empty($next_r['id'])){
$infonext = '<a href="' . sys_ReturnBqClassUrl($class_r[$GLOBALS['navclassid']]) . '">'. $class_r[$GLOBALS['navclassid']]['classname'] . '</a>';
}else{
$infonext = '<a href="' . sys_ReturnBqTitleLink($next_r) . '">' . $next_r['title'] . '</a>';
}
?>
上一篇：<?=$infopre?><br >
下一篇：<?=$infonext?>