Nicklas766 / Comment

     *

     * @return array

     */

    public function getAllPosts($sql, $params)

    {

        $posts = $this->findAllWhere("$sql", $params);

        return array_map(function ($post) {

            // Get e-mail for Post

            $user = new User($this->db);

            $post->img = $user->getGravatar($post->user);

            // Get comments for Post

            $comment = new Comment($this->db);

            $post->comments = $comment->getComments("parentId = ?", [$post->id]);

            // Get votes for Post

            $vote = new Vote($this->db);

            $post->vote = $vote->getVote("parentId = ? AND parentType = ?", [$post->id, "post"]);

            // Get text

            $post->markdown = $this->getMD($post->text);

            return $post;

        }, $posts);

    }

    /**

     * return question/answer, three attributes are set, comments connected to them is an array.

     *

     * @return object

    */

    public function getPost($sql, $params)

    {

        $post = $this->findWhere("$sql", $params);

        // Get e-mail for question

        $user = new User($this->db);

        $post->img = $user->getGravatar($post->user);

        // Get comments for Post

        $comment = new Comment($this->db);

        $post->comments = $comment->getComments("parentId = ?", [$post->id]);

        // Get votes for Post

        $vote = new Vote($this->db);

        $post->vote = $vote->getVote("parentId = ? AND parentType = ?", [$post->id, "post"]);

        // Start setting attributes

        $post->markdown = $this->getMD($post->text);

        return $post;

    }

}