Basic support for pagination

[cx.git] / cx / lib / images.php

diff --git a/cx/lib/images.php b/cx/lib/images.php
index fd6d6227b5a45fdf3e5c0535181bccee20cc62cf..dbe55bf4b23fed11610799cf6a4f90f8348bd5b5 100644 (file)
--- a/cx/lib/images.php
+++ b/cx/lib/images.php
@@ -58,11 +58,30 @@ function cx_images_get(int $limit = 0) {
        $sql .= ';';
 
        foreach (cx_db_query($sql) as $image) {
        $sql .= ';';
 
        foreach (cx_db_query($sql) as $image) {

-               $p = new Image($image);
-               yield $p;
+               $i = new Image($image);
+               yield $i;

        }
 }
 
        }
 }
 

+function cx_images_find_image($image_id) {
+       $sql = 'SELECT
+               image_id,
+               image_uid,
+               image_type,
+               image_alt_text
+               FROM images
+               WHERE image_id == ?
+               OR image_uid LIKE ?
+               LIMIT 1;';
+
+       foreach (cx_db_query($sql, $image_id, $image_id . "%") as $image) {
+               $i = new Image($image);
+               return $i;
+       }
+
+       return null;
+}
+

 cx_setup_register(1, function() {
        cx_db_exec('CREATE TABLE images (
                        image_id INTEGER PRIMARY KEY,
 cx_setup_register(1, function() {
        cx_db_exec('CREATE TABLE images (
                        image_id INTEGER PRIMARY KEY,