private function getCore() { include_once CORE_SYSTEM . '/lib/utils.class.php'; include_once CORE_SYSTEM . '/lib/database/PDO_DAO.php'; PDO_DAO::connect(); Utils::setSiteVars(); }
public function getData() { $query = 'SELECT * FROM users WHERE username = :username && password = :password LIMIT 1'; $bind = ['username' => $this->username, 'password' => $this->password]; $this->results = PDO_DAO::singleObject($query, $bind); }
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); } } }
private static function prepare($query) { try { self::$stmt = self::$db->prepare($query); } catch (PDOException $e) { Utils::logToFiles($e); } }