Basic support for pagination

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

diff --git a/cx/lib/posts.php b/cx/lib/posts.php
index 0a2ac4d997ff9c5133c0c0a27cffc6e4ee376f9e..7b1316643984a0ad2569831c7e820833df4a9874 100644 (file)
--- a/cx/lib/posts.php
+++ b/cx/lib/posts.php
@@ -2,13 +2,7 @@
 
 cx_require('lib', 'db.php');
 cx_require('lib', 'setup.php');
-cx_require('third_party', 'parsedown', 'Parsedown.php');
-
-function mk_markdown($markdown) {
-       static $Parsedown = new Parsedown();
-
-       return $Parsedown->text($markdown);
-}
+cx_require('lib', 'markdown.php');
 
 class PostMetadata {
        public $hero_image;
@@ -37,13 +31,13 @@ class Post {
                $this->date = $dict['post_date'];
                $this->is_draft = $dict['post_is_draft'];
                $this->data = $dict['post_data'];
-               $this->html_content = mk_markdown($this->data);
+               $this->html_content = cx_markdown_generate_html($this->data);
                $this->html_excerpt = null;
 
                // Read more...
                $segments = explode('---', $this->data, 2);
                if (count($segments) > 1) {
-                       $this->html_excerpt = mk_markdown($segments[0]);
+                       $this->html_excerpt = cx_markdown_generate_html($segments[0]);
                }
        }
 
@@ -133,7 +127,7 @@ function cx_posts_delete_post($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,
@@ -153,6 +147,10 @@ function cx_posts_get(int $limit = 0, bool $include_drafts = false) {
        if ($limit > 0) {
                $sql .= ' LIMIT ' . $limit;
        }
+       
+       if ($offset > 0) {
+               $sql .= ' OFFSET ' . $offset;
+       }
 
        $sql .= ';';