PHP dbh::news_get_total_count示例

 /**
  * отображаем весь список материалов
  */
 function indexAction()
 {
     if (isset($_POST['status'])) {
         $_SESSION['status'] = $_POST['status'];
     }
     if (isset($_POST['status'])) {
         $limit = 1000;
     } else {
         $_total_news = dbh::news_get_total_count();
         $limit = pager::pager_limit($_total_news, ADMIN_NEWS_AT_PAGE);
     }
     // строим запрос
     $_sql = 'SELECT * FROM ' . $this->tablename . ' where id>0 ' . general::get_status_for_filter($this->tablename) . ' order by created_at desc, sort limit ' . $limit;
     // выполняем запрос + при необходимости выводим сам запрос
     $result = mysql::query($_sql, 3);
     return system::show_tpl(array('result' => $result, 'msg' => $this->msg, '_status' => isset($_POST['status']) ? $_POST['status'] : 2, 'tpl_folder' => $this->tpl_folder, '_total_news' => $_total_news), $this->tpl_folder . '/index.php');
 }