search.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

        if(isset($_POST['submit'])){
					$search = $_POST['search'];
					
					$search = mysqli_real_escape_string($connection, $_POST['search']);

          $query = "SELECT * FROM posts 
                    WHERE post_tags LIKE '%$search%' 
                    OR post_title LIKE '%$search%'";
          $searchQuery = mysqli_query($connection, $query);

          if(!$searchQuery) {
            die("SEARCH QUERY FAILED ". mysqli_error($connection));
          }

          $count = mysqli_num_rows($searchQuery);

          if($count === 0){
            echo "<h1>No Result</h1>";
          } else {
            
          while($row = mysqli_fetch_assoc($searchQuery)){
            $post_title = $row['post_title'];
            $post_author = $row['post_author'];
            $post_date = $row['post_date'];
            $post_image = $row['post_image'];
            $post_content = $row['post_content'];

      ?>

			<!-- First Blog Post -->
			<h2>
				<a href="#">
					<?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> Posted on
				<?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 
            }
          }
        }
      ?>
          
		</div>

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

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

	<hr>

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