php - 如何在joomla中实现分页？

Question

我在joomla实现分页，下面是代码

      $db = JFactory::getDbo();
      $query = $db->getQuery(true)
                        ->select('c.*,cat.alias as catalias')
                        ->from('#__content AS c')
                        ->from('#__categories AS cat')
                        ->where('c.catid=19','AND')
                        ->where('c.state=1','AND')
                        ->where('c.catid = cat.id')
                        ->order('c.created '.' ASC');

    $db->setQuery($query,0,5);
    $results = $db->loadAssocList();
    $db->setQuery('SELECT FOUND_ROWS();');
    jimport('joomla.html.pagination');
    $pager= new JPagination($db->loadResult(), 0, 2);

    foreach ($results as $res) {  
    echo $res['id'];
    ....
    .....
    }

    echo $pager->getListFooter();

这在页脚处显示页码(如带超链接的 1 2 3)基于页数限制(3 页中有 6 条记录(页数限制为 2))。但所有记录都显示在单页中。不像每页中有两条记录页面。

这里需要更改什么。请帮助我。

提前致谢

Answer 1

我得到了我的问题的解决方案:

    $db = JFactory::getDbo();
    $app = JFactory::getApplication();
    $limit = $app->getUserStateFromRequest("$option.limit", 'limit', 2, 'int');
    $limitstart = $app->input->get('limitstart', 0, 'INT');
    $query = $db->getQuery(true)
             ->select('SQL_CALC_FOUND_ROWS c.*,cat.alias as catalias')
             ->from('#__content AS c')
             ->from('#__categories AS cat')
             ->where('c.catid=19','AND')
             ->where('c.state=1','AND')
             ->where('c.catid = cat.id')
             ->order('c.created '.' ASC');

    $db->setQuery($query,$limitstart, $limit);
    $results = $db->loadAssocList();
    if(!empty($results)){
        $db->setQuery('SELECT FOUND_ROWS();');
        jimport('joomla.html.pagination');
        $pager= new JPagination($db->loadResult(), $limitstart, $limit);

        foreach ($results as $res) {  
            echo $res['id'];
            YOUR_CODE_HERE
        }

        echo $pager->getListFooter();
   }