protected function setModelBody($language) { $this->_db = DataBaseSetting::getInstance('mysql'); $sql = "SELECT c.* FROM category c, mainmenu m WHERE c.language = '{$language}' and m.language = '{$language}' and m.id_cat = c.id and c.status != 1"; $result = $this->_db->query($sql); $this->_body = $result->fetchAll(PDO::FETCH_ASSOC); }
public function __construct() { $this->_db = DataBaseSetting::getInstance('mysql'); }