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);
}
}
