From 916d4521cb595493bc5df8b7f9ef52310b6d013a Mon Sep 17 00:00:00 2001
From: winter
Date: Mon, 23 Dec 2024 22:17:41 +0000
Subject: actor profile page

---
 Digitigrade/Model.php | 13 +++++++++++--
 1 file changed, 11 insertions(+), 2 deletions(-)

(limited to 'Digitigrade/Model.php')

diff --git a/Digitigrade/Model.php b/Digitigrade/Model.php
index 0db27ef..dca1484 100644
--- a/Digitigrade/Model.php
+++ b/Digitigrade/Model.php
@@ -153,12 +153,21 @@ abstract class Model {
         return static::fromDbRow($stmt->fetch(\PDO::FETCH_ASSOC));
     }
 
-    public static function findAllWhere(string $whereClause, array $parameters): array {
+    public static function findAllWhere(
+        string $whereClause,
+        array $parameters,
+        ?int $limit = null,
+        int $offset = 0
+    ): array {
         $classNameParts = explode('\\', static::class);
         $className = $classNameParts[count($classNameParts) - 1];
         $tableName = self::mangleName($className);
 
-        $stmt = Db::getInstance()->getPdo()->prepare("SELECT * FROM $tableName WHERE $whereClause");
+        $query = "SELECT * FROM $tableName WHERE $whereClause";
+        if ($limit != null) {
+            $query .= " LIMIT $limit OFFSET $offset";
+        }
+        $stmt = Db::getInstance()->getPdo()->prepare($query);
         $stmt->execute($parameters);
         return array_map(function ($row) {
             return static::fromDbRow($row);
-- 
cgit v1.3