<?php
include "include/header.php";
?>
<!-- Navigation -->
<?php
include "include/navigation.php"
?>
<!-- Page Content -->
<div class="container">
<div class="row">
<!-- Blog Entries Column -->
<div class="col-md-8">
<?php
$query= "select * from posts";
$select_all_posts=mysqli_query($connection,$query);
while($row = mysqli_fetch_assoc($select_all_posts)){
$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,200);
$post_status=$row['post_status'];
if($post_status !=='Published'){
}else{
?>
<h1 class="page-header">
Page Heading
<small>Secondary Text</small>
</h1>
<!-- First Blog Post -->
<h2>
<a href="post.php?action=view_post&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="img/<?php echo $post_image ?>" alt="">
<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 } } ?>
</div>
<!-- Blog Sidebar Widgets Column -->
<?php
include "include/sidebar.php"
?>
<!-- Footer -->
<?php
include "include/footer.php"
?>
