Cannot display comments from db in custom php mvc system

[Lesley007]

Hello everyone

I am new to php mvc and I hope someone can help me.
I have been playing around with php mvc after learning oopMy web app is CRUD capable so now I want to add a comment system to the posts. So far, I can display the form beneath the post for logged in users, and the comment is saved to database. But I am battling to get it to display on the post page. Here is my code and thanx in advance:

/** 
* Comments Model
*/
public static function addComment() {
        try {           
            $sql = ("INSERT INTO comments (id, parent_id, user_id, body, published) 
            VALUES (:id, :parent_id, :user_id, :body, :published)");            
            $db = static::getDBUserContent();
            $stmt = $db->prepare($sql);
            $stmt->bindParam(':id', $_REQUEST['id'], PDO::PARAM_INT);
            $stmt->bindParam(':parent_id', $_REQUEST['parent_id'], PDO::PARAM_INT);
            $stmt->bindParam(':user_id', $_REQUEST['user_id'], PDO::PARAM_INT);
            $stmt->bindParam(':body', $_REQUEST['body'], PDO::PARAM_STR);
            $stmt->bindParam(':published', $_REQUEST['published'], PDO::PARAM_INT);        
            return $stmt->execute();        
         }catch(PDOException $e) {
            echo $e->getMessage();
         }
         return true;
     }
     /**
     * List all Comments for a blog post
     *
     * @return array
     */
    public static function getComments() {
        try {
            $db = static::getDBUserContent();
            $stmt = $db->query('SELECT *, 
                                id as id,
                                blog_id as blog_id
                                FROM comments
                                LEFT JOIN userContent.blogs
                                ON id = blogs.id
                                WHERE published=1
                                ORDER BY date DESC
                                ');
            $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
            return $results;            
        } catch (PDOException $e) {
            echo $e->getMessage();
        }
    }

/**
* Comments Controller
*/
// Add a comment 
    public function addCommentAction() {
        $comment = new BlogsModel($_POST);
        if ($comment->addComment()) {
            $this->redirect('/');
        } 
    }
// This is where I am stuck
    public function indexAction() {        
        $comments = new BlogsModel::getComments($id);        
        }

<!-- Add a comment form -->
<form action="/comments/add" id="newComment" method="POST">
    <input type="hidden" name="blogID" value="{{ blog.blogID }}">
    <input type="hidden" name="user_id" value="{{ current_user.userID }}">
    <input type="hidden" name="parent_id" value="{{ comment.commentID }}">
    <input type="hidden" name="published" value="1">
    <textarea name="body" id="body" cols="30" rows="10"></textarea>
    <button type="submit">Create</button> 
</form>

<!-- List comments for this post -->
{% for comment in comments %}
    {% if comment.id == comment.blog_id %}
        {{ comment.body }}
        {{ comment.fname }}
    {% endif %}
{% endfor %}

My mysql comments table:

id, blog_id, parent_id, user_id, body, date, published

[requinix]

Have you tried adding that template you have for the comments into the page you already have that shows the post?