index.php

<?php
include "includes/db.php";
include "includes/header.php";
include "includes/navigation.php";


?>



    <!-- Navigation -->

    <!-- Page Content -->
    <div class="container">

        <div class="row">

            <!-- Blog Entries Column -->
            <div class="col-md-8">
                <?php

                $query = "SELECT * FROM posts";
                $select_posts_query = $connection->query($query);
              while ($row = $select_posts_query->fetch_assoc()) {
                /*  $post_id = $row['post_id'];
                  $post_category_id = $row['post_category_id'];*/
                  $post_title = $row['post_title'];
                  $post_author = $row['post_author'];
                  $post_date = $row['post_date'];
                  $post_image = $row['post_picture'];
                  $post_content = $row['post_content'];

                  ?>







                <h1 class="page-header">
                    Page Heading
                    <small>Secondary Text</small>
                </h1>

                <!-- First Blog Post -->
                <h2>
                    <a href="#"><?php echo $post_title?></a>
                </h2>
                <p class="lead">
                    by <a href="index.php"><?php echo $post_author?></a>
                </p>
                <p><span class="glyphicon glyphicon-time"></span><?php echo $post_date ?></p>
                <hr>
                <img class="img-responsive" src="images/<?php echo $post_image?>" alt="">
                <hr>
                <p> <?php echo $post_content ?></p>
                <a class="btn btn-primary" href="#">Read More
                    <span class="glyphicon glyphicon-chevron-right"></span></a>

                <hr>
                    <?php   } ?>
                <!-- Second Blog Post -->
            </div>

            <!-- Blog Sidebar Widgets Column -->
            <?php include "includes/sidebar.php"; ?>

                <!-- Blog Categories Well -->


        <!-- Footer -->

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