index.php

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

<!-- Navigation -->
<?php include "includes/nav.php" ?>

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

	<div class="row">

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

			<?php

			// sets how many results you want to show per page
				$per_page = 4;

				if(isset($_GET['page'])) {
					$page = $_GET['page'];
				}  else {
					$page = "";
				}

				if($page == "" || $page == 1) {
					$page_1 = 0;
				} else {
					$page_1 = ($page * $per_page) - $per_page;
				}


				$postQueryCount = "SELECT * FROM posts";
				$findCountQuery = mysqli_query($connection, $query);
				$count = mysqli_num_rows($findCountQuery);

				$count = ceil($count / $per_page);

				$query = "SELECT * FROM posts LIMIT $page_1, $per_page";
				$selctAllPostQuery = mysqli_query($connection, $query);

				while($row = mysqli_fetch_assoc($selctAllPostQuery)){
					$postId= $row['post_id'];
					$postTitle = $row['post_title'];
					$postAuthor = $row['post_author'];
					$postDate = $row['post_date'];
					$postImage = $row['post_image'];
					$postContent = substr($row['post_content'],0,150) . "..";
					$postStatus = $row['post_status'];

					if($postStatus === 'published') {

			?>

			<!-- First Blog Post -->
			<h2>
				<a href="post.php?p_id=<?php echo $postId; ?>">
					<?php echo $postTitle ?>
				</a>
			</h2>
			<p class="lead">
				by <a href="authorPost.php?author=<?php echo $postAuthor ?>&p_id=<?php echo $postId; ?>">
					<?php echo $postAuthor ?></a>
			</p>
			<p><span class="glyphicon glyphicon-time"></span> Posted on
				<?php echo $postDate ?>
			</p>
			<hr>
			<a href="post.php?p_id=<?php echo $postId; ?>">
				<img class="img-responsive" src="images/<?php echo $postImage ?>" alt="" width="700" height="auto">
			</a>
			<hr>
			<p>
				<?php echo $postContent;?>
			</p>
			<a class="btn btn-primary" href="post.php?p_id=<?php echo $postId; ?>">Read More<span class="glyphicon glyphicon-chevron-right"></span></a>

			<hr>


			<?php } }?>
		</div>

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

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

	<hr>

	<ul class="pager">
		<?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>";
				}
			}
		?>

		
		
	</ul>

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