帝国CMS原生PHP实现上一篇下一篇,没有上一篇或者下一篇的时候返回当前栏目名称和链接。
按ID排序:
按发布时间newstime排序:
以上是DEMO代码,样式自己根据需求的样式修改html即可。
按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?>
以上是DEMO代码,样式自己根据需求的样式修改html即可。