public function getCount() { $select = $this->select; $this->select = 'COUNT(*) AS total'; $query = $this->buildBaseQuery(); $this->select = $select; $stmt = $this->database->prepare($query); foreach ($this->params as $key => $value) { $stmt->bindValue($key, $value); } if ($stmt->execute()) { $res = $stmt->fetch(Database::FETCH_ASSOC); return (int) $res['total']; } return 0; }