Пагинация для компонента. - Joomla 1.5: Общие вопросы

$db =& JFactory::getDBO();

		$lim   = $mainframe->getUserStateFromRequest("$option.limit", 'limit', 2, 'int'); //I guess getUserStateFromRequest is for session or different reasons
		$lim0  = JRequest::getVar('limitstart', 0, '', 'int');
		$db->setQuery('SELECT id, title FROM #__catalog_cat_id WHERE id ',$lim0, $lim);
		$rL=&$db->loadAssocList();
		if (empty($rL)) {$jAp->enqueueMessage($db->getErrorMsg(),'error'); return;}  
		else {
		////Here the beauty starts
		$db->setQuery('SELECT id, title FROM #__catalog_cat_id');  //no reloading the query! Just asking for total without limit
		jimport('joomla.html.pagination');
		$pageNav = new JPagination( $db->loadResult(), $lim0, $lim );
		
		echo '<table width="100%" border="0" cellspacing="2" cellpadding="5">';
		foreach($rL as $r) {
		echo '
		<tr bgcolor="#f4f4f4">
   			 <td  bgcolor="#f4f4f4">'.$r['title'].'</td>
   			 <td width="100" bgcolor="#f4f4f4" align="center">
			 <a href="index.php?option=com_hello&view=hello&layout=view_cat&del='.$r['id'].'" >Удалить</a>
			 </td>
   			 <td width="100" bgcolor="#f4f4f4" align="center">
			 <a href="index.php?option=com_hello&view=hello&layout=view_cat&id='.$r['id'].'" >Редактировать</a>
			 </td>
	 	</tr>';
		
		}
		echo '</table>';
		}
		echo $pageNav->getListFooter(); //Displays a nice footer

$db =& JFactory::getDBO();

        $lim   = $mainframe->getUserStateFromRequest("$option.limit", 'limit', 2, 'int'); //I guess getUserStateFromRequest is for session or different reasons
        $lim0  = JRequest::getVar('limitstart', 0, '', 'int');
        $db->setQuery('SELECT id, title FROM #__catalog_cat_id WHERE id ',$lim0, $lim);
        $rL=&$db->loadAssocList();
        if (empty($rL)) {$jAp->enqueueMessage($db->getErrorMsg(),'error'); return;}  
        else {
        ////Here the beauty starts
        $db->setQuery('SELECT id, title FROM #__catalog_cat_id');  //no reloading the query! Just asking for total without limit
        jimport('joomla.html.pagination');
        $pageNav = new JPagination( $db->loadResult(), $lim0, $lim );
        
        echo '<table width="100%" border="0" cellspacing="2" cellpadding="5">';
        foreach($rL as $r) {
        echo '
        <tr bgcolor="#f4f4f4">
                <td  bgcolor="#f4f4f4">'.$r['title'].'</td>
                <td width="100" bgcolor="#f4f4f4" align="center">
             <a href="index.php?option=com_hello&view=hello&layout=view_cat&del='.$r['id'].'" >Удалить</a>
             </td>
                <td width="100" bgcolor="#f4f4f4" align="center">
             <a href="index.php?option=com_hello&view=hello&layout=view_cat&id='.$r['id'].'" >Редактировать</a>
             </td>
         </tr>';
        
        }
        echo '</table>';
        }
        echo $pageNav->getListFooter(); //Displays a nice footer

<form method="get"></form>

<?php
$db =& JFactory::getDBO();
$lim   = 4; //Кол-во на одной странице
$lim0  = JRequest::getVar('limitstart', 0, '', 'int');
$db->setQuery('SELECT title FROM #__content',$lim0, $lim);
$rL=&$db->loadObjectList();
if (empty($rL)) {$jAp->enqueueMessage($db->getErrorMsg(),'error'); return;}  
else {
////Here the beauty starts
$db->setQuery('SELECT COUNT(id) FROM #__content');  //no reloading the query! Just asking for total without limit
jimport('joomla.html.pagination');
$pageNav = new JPagination( $db->loadResult(), $lim0, $lim);

foreach($rL as $r) {
	echo $r->title;
}
echo $pageNav->getPagesLinks(  ); //Displays PagesLinks
} ?>

"$option.limit"

«Первая Предыдущая 1 2 3 4 5 6 7 8 9 10 Следующая Последняя»

Fatal error: Call to a member function enqueueMessage() on a non-object in Z:\home\com.ru\www\components\com_hello\views\hello\tmpl\view_cat.php on line 72

<?php
$db =& JFactory::getDBO();
$lim   = 4; //Кол-во на одной странице
$lim0  = JRequest::getVar('limitstart', 0, '', 'int');
$db->setQuery('SELECT title FROM #__content',$lim0, $lim);
$rL=&$db->loadObjectList();
if (empty($rL)) {$jAp->enqueueMessage($db->getErrorMsg(),'error'); return;}  
else {
////Here the beauty starts
$db->setQuery('SELECT COUNT(id) FROM #__content');  //no reloading the query! Just asking for total without limit
jimport('joomla.html.pagination');
$pageNav = new JPagination( $db->loadResult(), $lim0, $lim);
 
foreach($rL as $r) {
    echo $r->title;
}
echo $pageNav->getPagesLinks(  ); //Displays PagesLinks
} ?>