public function registerCategoryIfDoesntExist()
{
$db = new Database('blog');
$category = $db->prepare("SELECT * FROM categories WHERE name = ?", [$this->name], "App\\Table\\Categories", true);
if ($category == null) {
$category = ucfirst($category);
$db->insert("\n\t\t\t\t\tINSERT INTO categories(name)\n\t\t\t\t\tVALUES(:name)\n\t\t\t\t", array("name" => $this->name));
}
}
public static function selectUsers($banned = false, $amIin = false)
{
$db = new Database('blog');
$ban = null;
if ($banned == false) {
$ban = 0;
} else {
$ban = 1;
}
if ($amIin == true) {
$query = $db->prepare("SELECT * FROM users WHERE username <> :username AND ban = :ban", array("username" => $_SESSION['admin'], "ban" => $ban), "App\\Table\\User");
} else {
$query = $db->prepare("SELECT * FROM users WHERE ban = :ban", array("ban" => $ban), "App\\Table\\User");
}
return $query;
}
public static function getArticlesWritedIn($year)
{
$db = new Database('blog');
$query = $db->prepare("SELECT * FROM articles WHERE Year(dateOfWriting) = :year ORDER BY id ASC", array("year" => $year), "App\\Table\\Article");
return $query;
}
