Basic support for pagination

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

diff --git a/cx/lib/posts.php b/cx/lib/posts.php
index 988d00eb008c457b873b67876d33f581213b9bba..7b1316643984a0ad2569831c7e820833df4a9874 100644 (file)
--- a/cx/lib/posts.php
+++ b/cx/lib/posts.php
@@ -127,7 +127,7 @@ function cx_posts_delete_post($post_id) {
        cx_db_exec($sql, $post_id);
 }
 
        cx_db_exec($sql, $post_id);
 }
 

-function cx_posts_get(int $limit = 0, bool $include_drafts = false) {
+function cx_posts_get(int $limit = 0, int $offset = 0, bool $include_drafts = false) {

        $sql = 'SELECT
                post_id,
                post_slug,
        $sql = 'SELECT
                post_id,
                post_slug,


@@ -147,6 +147,10 @@ function cx_posts_get(int $limit = 0, bool $include_drafts = false) {
        if ($limit > 0) {
                $sql .= ' LIMIT ' . $limit;
        }
        if ($limit > 0) {
                $sql .= ' LIMIT ' . $limit;
        }

+       
+       if ($offset > 0) {
+               $sql .= ' OFFSET ' . $offset;
+       }

 
        $sql .= ';';
 
 
        $sql .= ';';