index.php

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



<!-- Navigation -->

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

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

    <div class="row">

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

            <?php
            $postPerPage = 10;
            if(isset($_GET['page'])){
                $page = $_GET['page'];
                $pageStrat = ($page * $postPerPage) - $postPerPage;
            } else {
                $pageStrat = 0;
            }
            

            $query = "SELECT COUNT(*) AS postsCount FROM posts WHERE status='Published'";
            $postsCount = mysqli_query($success, $query);
            $postsCount = mysqli_fetch_object($postsCount);
            $postsCount = $postsCount->postsCount;
            if(!$postsCount){
                die("Query Failed " . mysqli_error($success));
            }
            $count = ceil($postsCount/$postPerPage);

            $query = "SELECT * FROM posts WHERE status='Published' LIMIT $pageStrat, $postPerPage";
            $allPosts = mysqli_query($success, $query);
            if (mysqli_num_rows($allPosts)==0) {
                die("<h1>No posts Here</h1>");
            }
            ?>

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

            <!-- Blog Posts -->
            <?php
            $allPosts = mysqli_query($success, $query);
            while ($post = mysqli_fetch_assoc($allPosts)) {
                $id = $post['id'];
                $title = $post['title'];
                $author = $post['author'];
                $date = $post['date'];
                $content = substr($post['content'], 0, 100);
                $image = $post['image'];
            ?>
                <h2>
                    <a href="post.php?id=<?php echo $id; ?>"><?php echo $title; ?></a>
                </h2>
                <p class="lead">
                    by <a href="authorPosts.php?author=<?php echo $author; ?>"><?php echo $author; ?></a>
                </p>
                <p><span class="glyphicon glyphicon-time"></span> Posted on <?php echo $date; ?></p>
                <hr>
                <a href="post.php?id=<?php echo $id; ?>"><img class="img-responsive" src="images/<?php echo $image; ?>" alt=""></a>
                <hr>
                <p><?php echo $content; ?></p>
                <a class="btn btn-primary" href="post.php?id=<?php echo $id; ?>">Read More <span class="glyphicon glyphicon-chevron-right"></span></a>

            <?php


            }


            ?>


            <hr>

            <!-- Pager -->
            <ul class="pager">
                <li class="previous">
                    <a href="#">&larr; Older</a>
                </li>
                <?php 
                
                for($i=1; $i <= $count; $i++ ){
                    if($i == $page){
                        echo "<li><a class='active_link' href='index.php?page={$i}'>{$i}</a></li>";
                    } else {
                        echo "<li><a href='index.php?page={$i}'>{$i}</a></li>";
                    }

                    
                }
                
                ?>
                <li class="next">
                    <a href="#">Newer &rarr;</a>
                </li>
            </ul>

        </div>

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


        <!-- /.row -->
        <hr>

        <!-- Footer -->
        <?php include "includes/footer.php"; ?>