jacobemerick / web

     *

     * @return array|false

     */

    public function findPostByPath($category, $path)

    {

        $query = "

            SELECT `id`, `title`, `path`, `date`, `body`, `category`

            FROM `jpemeric_blog`.`post`

            WHERE `path` = :path AND `category` = :category AND `display` = :is_active

            LIMIT 1";

        $bindings = [

            'path'      => $path,

            'category'  => $category,

            'is_active' => 1,

        ];

        return $this

            ->connections

            ->getRead()

            ->fetchOne($query, $bindings);

    }

    public function getActivePosts($limit = null, $offset = 0)

    {

            ->fetchAll($query, $bindings);

    }

    public function getActivePostsCountByTag($tag)

    {

        $query = "

            SELECT COUNT(1) AS `count`

            FROM `jpemeric_blog`.`post`

            INNER JOIN `jpemeric_blog`.`ptlink` ON `ptlink`.`post_id` = `post`.`id` AND

                                                   `ptlink`.`tag_id` = :tag_id

            WHERE `display` = :is_active";

        $bindings = [

            'tag_id'    => $tag,

            'is_active' => 1,

        ];

        return $this

            ->connections

            ->getRead()

            ->fetchValue($query, $bindings);

    }

    public function getActivePostsByCategory($category, $limit = null, $offset = 0)

    {

            ->fetchAll($query, $bindings);

    }

    public function getActivePostsCountByCategory($category)

    {

        $query = "

            SELECT COUNT(1) AS `count`

            FROM `jpemeric_blog`.`post`

            WHERE `category` = :category AND `display` = :is_active";

        $bindings = [

            'category'  => $category,

            'is_active' => 1,

        ];

        return $this

            ->connections

            ->getRead()

            ->fetchValue($query, $bindings);

    }

    public function getActivePostsByRelatedTags($post, $limit = 4)

    {