/** * Get the record count of this table. Will use a cached value only for base * tables and where there are no filters. * @return integer The record count. */ public function getCount() { // Only cache if this is a base table and there are no filters. $canCache = $this->table->isTable() && count($this->table->get_filters()) === 0; if ($canCache) { if (isset($_SESSION[$this->sessionKey()])) { return $_SESSION[$this->sessionKey()]; } } // Otherwise, run the COUNT() query. $pkCol = $this->table->getPkColumn(); if ($pkCol instanceof Column) { $count_col = '`' . $this->table->getName() . '`.`' . $pkCol->getName() . '`'; } else { $count_col = '*'; } $sql = 'SELECT COUNT(' . $count_col . ') as `count` FROM `' . $this->table->getName() . '`'; $params = $this->table->applyFilters($sql); $count = $this->table->getDatabase()->query($sql, $params)->fetchColumn(); if ($canCache) { $_SESSION[$this->sessionKey()] = $count; } return (int) $count; }