<link rel="stylesheet" type="text/css" href="blog.css" />
<?php

    $db = new PDO(
        "mysql:host=localhost;dbname=class_blog",
        "class_user",
        "class_password"
    );

    $get_posts_query = $db->prepare("
        SELECT * FROM `posts`
        WHERE `username` = :username
    ");

    $params = array(
        ':username' => $_GET['user']
    );

    $get_posts_query->execute($params);

    $posts = $get_posts_query->fetchAll();

    if (empty($posts))
    {
        echo 'No posts here!';
    }

    //while ($row = $get_posts_query->fetch())
    foreach ($posts as $row)
    {
        echo '
            <div class="post">
                <div class="title">' . $row['title'] .'</div>
                ' . $row['body'] . '
                <div class="footer">
                    Posted by ' . $row['username'] . '
                    on ' . $row['date'] . '
                </div>
                <div class="links">
                <a href="blog_comments.php?postid='
                    . $row['postid'] .
                '">View Comments</a>
                </div>
            </div>
        ';
    }

?>
