PHP Criteria::setCalcFoundRows Examples

Example #1

File: SiteController.php Project: reinfire/arfooo

 function bannedAction($page = 1)
 {
     $itemsPerPage = 20;
     $c = new Criteria();
     $c->add('status', 'banned');
     $c->setPagination($page, $itemsPerPage);
     $c->setCalcFoundRows(true);
     $this->set('sites', $this->site->findAll($c));
     $totalPages = ceil($this->site->getFoundRowsCount() / $itemsPerPage);
     $this->set('pageNavigation', array('baseLink' => '/admin/site/banned/', 'totalPages' => $totalPages, 'currentPage' => $page));
 }