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