function getUpdate($sqlDataArray = array()) { if (isset($sqlDataArray['info_update_id'])) { $this->sql = 'SELECT info_update_title, info_update_id, info_update_content, info_update_date FROM info_update WHERE info_update_id = :info_update_id'; } else { $this->sql = 'SELECT info_update_title, info_update_id, info_update_date FROM info_update'; } $this->results = $this->db->select($this->sql, $sqlDataArray); $this->resultsQuantity = count($this->results); foreach ($this->results as $key => $footerData) { $this->results[$key]['info_update_title_url'] = Helpers::filterUrl($this->results[$key]['info_update_title']); $this->results[$key]['info_update_date'] = Dates::convertDate($this->results[$key]['info_update_date']); } if ($this->resultsQuantity > 0) { return $this->results; } else { FlashMessages::setFlashMessage('noresult', '<b>Not Found!</b><br />Update information you are looking for does not exist.'); } }
/** * footerSystemUpdate * * Retrieve updates of the system itens from database and send to content variables * * @return function Send the variables about the update to the content variables */ public function footerSystemUpdate() { $this->sql = 'SELECT info_update_id, info_update_title FROM info_update LIMIT 6'; $this->results = $this->db->select($this->sql); foreach ($this->results as $key => $footerData) { $this->results[$key]['info_update_title_url'] = Helpers::filterUrl($this->results[$key]['info_update_title']); } View::setContentVars('footerSystemUpdate', $this->results); }