示例#1
0
 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);
         }
     }
 }