diff options
Diffstat (limited to 'core/namespace/ORM/Repositories/Page.php')
-rw-r--r-- | core/namespace/ORM/Repositories/Page.php | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/core/namespace/ORM/Repositories/Page.php b/core/namespace/ORM/Repositories/Page.php new file mode 100644 index 0000000..595b420 --- /dev/null +++ b/core/namespace/ORM/Repositories/Page.php @@ -0,0 +1,19 @@ +<?php +namespace ORM\Repositories; +use ORM\Repository; +use ORM\Entities\User; + +class Page extends Repository { + public static function getTableName(): string { return 'page'; } + public static function getClassName(): string { return 'ORM\Entities\Page'; } + + public function getCountByUser(User $User): int { + $query = 'SELECT COUNT(id) FROM %s WHERE user = ?'; + $query = sprintf($query, static::getTableName()); + + $Statement = $this->Database->prepare($query); + $Statement->execute([$User->getID()]); + + return $Statement->fetchColumn(); + } +} |