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">

                <h1 class="page-header">
                    DU Express
                    <small>Inpendent Student Run Platform</small>
                </h1>

                <!-- First Blog Post -->
        <?php
    
            if(isset($_GET["page"])){
                $page_num=$_GET["page"];
            }else{
                $page_num=1;
            }
            
            $offset=5*($page_num-1);
            
            
            $post_query_count="SELECT * FROM posts WHERE post_status='published'";
            $find_count=mysqli_query($connection, $post_query_count);
            $count=mysqli_num_rows($find_count);
            $count=ceil($count/5);

            $query ="SELECT * FROM posts WHERE post_status='published' ORDER BY post_id LIMIT {$offset},5";
            $select_all_posts_query= mysqli_query($connection, $query);

        if(mysqli_num_rows($find_count)==0){
       echo "<h2>Sorry there are no published posts to show</h2>";
 }else{
                             
 

            while($row=mysqli_fetch_assoc($select_all_posts_query)){
                $post_id=$row["post_id"];
                $post_title=$row["post_title"];
                $post_author=$row["post_author"];
                $post_date=$row["post_date"];
                $post_image=$row["post_image"];
                $post_content=substr($row["post_content"],0,400);

        ?>
                
                <h2>
                    <a href="post.php?p_id=<?php echo $post_id; ?>"><?php echo $post_title; ?></a>
                </h2>
                <p class="lead">
                    by <a href="author_posts.php?author=<?php echo $post_author; ?>&p_id=<?php echo $post_id; ?>"><?php echo $post_author ?></a>
                </p>
                <p><span class="glyphicon glyphicon-time"></span> <?php echo $post_date ?></p>
                <hr>
                <a href="post.php?p_id=<?php echo $post_id; ?>">
                    <img class="img-responsive" src="images/<?php echo $post_image; ?>" alt=""></a>
                <hr>
                <p><?php echo $post_content ?></p>
                <a class="btn btn-primary" href="post.php?p_id=<?php echo $post_id; ?>">Read More <span class="glyphicon glyphicon-chevron-right"></span></a>

                <hr>

                <?php }} ?>

              <hr style="width: 100%; color: black; height: 1px; background-color:black;" />
                <ul class="pager">
                
            <?php 
                    for($i=1; $i<=$count; $i++){
                        echo "<li><a href='index.php?page={$i}'>{$i}</a></li>";
                    }
                    ?>
            
        </ul>

            </div>

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

        </div>
        <!-- /.row -->

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