/** * Administator view of users. */ public function action_index() { // set the template title (see Controller_App for implementation) $this->template->title = __('user.administration'); // create a user $user = ORM::factory('user'); // This is an example of how to use Kohana pagination // Get the total count for the pagination $total = $user->count_all(); // Create a paginator $pagination = new Pagination(array('total_items' => $total, 'items_per_page' => 30, 'auto_hide' => false, 'view' => 'pagination/useradmin')); // Get the items for the query $sort = isset($_GET['sort']) ? $_GET['sort'] : 'username'; // set default sorting direction here $dir = isset($_GET['dir']) ? 'DESC' : 'ASC'; $result = $user->limit($pagination->__get('items_per_page'))->offset($pagination->__get('offset'))->order_by($sort, $dir)->find_all(); // render view // pass the paginator, result and default sorting direction $this->template->content = View::factory('user/admin/index')->set('users', $result)->set('paging', $pagination)->set('default_sort', $sort); }