hi, i have one question
to my controller ex: IndexController i have query:
$categorycount = $this->modelsManager->executeQuery("SELECT count(id) AS velueviews FROM Videos WHERE category = :category:", array('category' => '1')); $this->view->setVars(array('categorycount' => $categorycount));
i want to get this data from other controller if it possible, ex: ProfileController, i don't need to write similar query to ProfileController. What can I do?