protected function getContent() { $query = "SELECT count(TABLE_ID) AS total FROM `INNODB_SYS_TABLES` "; $bind = ""; $count = PDO_DAO::singleObject($query, $bind); $this->countResults = $count ? $count->total : 0; $this->paginate->total = $this->countResults; if ($count) { $query = "SELECT * FROM `INNODB_SYS_TABLES` " . $this->paginate->limit(); $bind = []; $this->results = PDO_DAO::multiObjects($query, $bind); } }
static function pageSettings() { if (!isset($_SESSION['settings'])) { try { $query = 'SELECT * FROM settings'; $bind = ''; foreach (PDO_DAO::multiObjects($query, $bind) as $res) { $_SESSION['settings'][$res->name] = $res->value; } } catch (Exception $e) { Utils::logToFiles($e); } } }