$db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select('*'); $query->from($db->quoteName('#__tablename')); $db->setQuery($query); $results = $db->loadObjectList();
$page = JRequest::getInt('page', 1); $limit = JRequest::getVar('limit', '10', 'post', 'int'); $offset = ($page - 1) * $limit; $model = JModelList::getInstance('YourModel', 'YourComponentModel'); $model->setState('filter.offset', $offset); $model->setState('list.limit', $limit); $items = $model->getItems();These examples are part of the Joomla framework and are included in the Joomla CMS package library.