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

if(isset($_GET['category']))

{

$the_get_category_id = $_GET['category'];

if(isset($_SESSION['user_role']) && $_SESSION['user_role'] == 'Admin')

{

$query = "SELECT * FROM posts WHERE post_category_id = $the_get_category_id";

}

else

{

$query = "SELECT * FROM posts WHERE post_category_id = $the_get_category_id AND post_status = 'published'";

}

$result = mysqli_query($connection, $query);

if(mysqli_num_rows($result) < 1)

{

echo "<h2 class='text-center text-danger'>No posts</h2>";

}

else

{

while($row = mysqli_fetch_array($result))

{

$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_image'];

$post_content = substr($row['post_content'], 0, 50);

$post_tags = $row['post_tags'];

$post_comment_count = $row['post_comment_count'];

$post_status = $row['post_status'];

?>

<h1 class="page-header">

Page Heading

<small>Secondary Text</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

} }} else

{

header("Location: index.php");

}

?>

</div>

<!-- Blog Sidebar Widgets Column -->

<?php include("includes/sidebar.php"); ?>

</div>

<!-- /.row -->

<hr>

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