category.php

<?php ob_start(); ?>

<!-- header -->
<?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

                if(isset($_GET['category'])) {
                    $post_category_id = $_GET['category'];

                    if(is_Admin($_SESSION['username'])) {
                        $stmt1 = mysqli_prepare($connection, "SELECT post_id, post_title, post_author, post_date, post_image, post_content, post_status FROM posts WHERE post_category_id = ?");
                    }
                    else {
                        $stmt2 = mysqli_prepare($connection, "SELECT post_id, post_title, post_author, post_date, post_image, post_content, post_status FROM posts WHERE post_category_id = ? AND post_status= ?");
                        $published = 'published';
                    }
        
                if(isset($stmt1)) {
                    mysqli_stmt_bind_param($stmt1, "i", $post_category_id);
                    mysqli_stmt_execute($stmt1);
                    mysqli_stmt_bind_result($stmt1, $post_id, $post_title, $post_author, $post_date, $post_image, $post_content, $post_status);
                    $stmt = $stmt1;
                }
                else {
                    mysqli_stmt_bind_param($stmt2, "is", $post_category_id, $published);
                    mysqli_stmt_execute($stmt2);
                    mysqli_stmt_bind_result($stmt2, $post_id, $post_title, $post_author, $post_date, $post_image, $post_content, $post_status);
                    $stmt = $stmt2;
                }

                mysqli_stmt_store_result($stmt);

                if(mysqli_stmt_num_rows($stmt) === 0) {
                    echo "<h1 class='text-center'>No category available 😅</h1>";
                }
                
                while(mysqli_stmt_fetch($stmt)): 
                    
                        ?>

            <h1 class="page-header">
                All posts
                <small>Category</small>
            </h1>

            <!-- First Blog Post -->
            <h2>
                <a href="post.php?p_id=<?php echo $post_id; ?>"><?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 endwhile; 
                mysqli_stmt_close($stmt);
            }
            else {
                header("Location: index.php");
            } ?>

        </div>

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

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

    <hr>

    <!-- footer -->
    <?php include 'includes/footer.php'?>