Drupal 7 實現上一篇下一篇的簡單方法

2024-08-30 19:06:39

字體：大中小

來源：轉載

供稿：網友

在建個人小站[阿亮php筆記]時，想在文章頁面實現“上一篇，下一篇”的效果，Drupal 7 是沒有默認帶這個功能的,網上也有寫好的模塊,不過個人感覺,這么一個小功能還裝個模塊的話,太浪費性能的,反正就兩條SQL搞定,就自己隨便寫一下吧.

在模板/sites/all/themes/liuzhiliang.com/template.php文件上加個函數,代碼如下:

/**

* myNodePrevNext

* 文章上一篇下一篇

* $nid - 節點id

* $type - 節點類型

*/

function myNodePrevNext($nid, $type)

{

    $output = '<ul>';

    $sql_previous = "SELECT n.nid, n.title, url.alias "

                  . "FROM {node} AS n "

                  . "LEFT JOIN {url_alias} AS url "

                  . "ON concat('node/',n.nid)=url.source "

                  . "WHERE n.nid < :nid AND n.type = :type "

                  . "ORDER BY n.nid DESC "

                  . "LIMIT 0, 1";

    $result_previous = db_query($sql_previous, array(':nid' => $nid, ':type' => $type));

    $strings = array();

    foreach ($result_previous as $data)

    {

        $data->url = ($data->alias) ? $data->alias : '/node/' . $data->nid;

        $output .= '<li>上一篇：'

                . '<a href="' . $data->url . '" title="' . $data->title . '">'

                . $data->title

                . '</a>'

                . '</li>';

    }

    $sql_next = "SELECT n.nid, n.title, url.alias "

              . "FROM {node} AS n "

              . "LEFT JOIN {url_alias} AS url "

              . "ON concat('node/',n.nid)=url.source "

              . "WHERE n.nid > :nid AND n.type = :type "

              . "ORDER BY n.nid ASC "

              . "LIMIT 0, 1";

    $result_next = db_query($sql_next, array(':nid' => $nid, ':type' => $type));

    $strings = array();

    foreach ($result_next as $data)

    { //Vevb.com

        $data->url = ($data->alias) ? $data->alias : '/node/' . $data->nid;

        $output .= '<li>下一篇：'

                . '<a href="' . $data->url . '" title="' . $data->title . '">'

                . $data->title

                . '</a>'

                . '</li>';

    }

    $output .= '</ul>';

    return $output;

}

再到/sites/all/themes/liuzhiliang.com/templates/node.tpl.php加上下面這段代碼,具體位置看自己喜歡,我是在文章底部顯示,所以在回在了<div class="content clearfix"<?php print $content_attributes; ?>>后面,代碼如下:

<?php if (!$teaser) : ?>

  <div class="previous_next">

    <?php print myNodePrevNext($node->nid, $node->type); // 上下篇 ?>

  </div>

<?php endif; ?>