posts.php

<?php include "includes/header.php";?>
<?php
    //Create database object
    $db = new Database();
    if(isset($_GET['category'])){
        $category = $_GET['category'];
        //create query
        $query = "SELECT * FROM `posts` WHERE category=".$category." ORDER BY id DESC";

        //run query
        $posts = $db->select($query);
    }else{
        //create query
        $query = "SELECT * FROM `posts` ORDER BY id DESC";

        //run query
        $posts = $db->select($query);
    }





    //create query
    $query = "SELECT * FROM `categories`";

    //run query
    $categories = $db->select($query);
?>
<?php if($posts):?>
    <?php while($row = $posts->fetch_assoc()) :?>
        <div class="blog-post">
            <h2 class="blog-post-title"><?php echo $row['title'];?></h2>
            <p class="blog-post-meta"><?php echo formatDate($row['date']);?> by <a href="#"><?php echo $row['author'];?></a></p>
            <?php echo shortenText($row['body']);?>
            <a class ="readmore" href="post.php?id=<?php echo urlencode($row['id']);?>">Read More</a>
        </div><!-- /.blog-post -->
    <?php endwhile;?>
<?php else:?>
    <p>There are no posts yet</p>
<?php endif;?>

<?php include "includes/footer.php";?>