diff options
Diffstat (limited to 'core/namespace/Page/Repository.php')
-rw-r--r-- | core/namespace/Page/Repository.php | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/core/namespace/Page/Repository.php b/core/namespace/Page/Repository.php new file mode 100644 index 0000000..b76ef85 --- /dev/null +++ b/core/namespace/Page/Repository.php @@ -0,0 +1,17 @@ +<?php +namespace Page; + +class Repository extends \Repository { + public static function getTableName(): string { return 'page'; } + public static function getClassName(): string { return 'Page\Entity'; } + + public function getCountByUser(\User\Entity $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(); + } +} |