search.php

<?php 

  include "./includes/db.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">
        <h1 class="mt-5">
            Search Results
          </h1>
          <hr />
      

        <?php 
                    
        if (isset($_POST['submit'])) {
        $search = mysqli_real_escape_string($connection,($_POST['search']));
        
        $query = "SELECT * FROM posts WHERE post_title LIKE '%$search%' OR post_content LIKE '%$search%'";
        $search_query = mysqli_query($connection, $query);

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

        $count = mysqli_num_rows($search_query);

        if($count == 0) {
            echo "<h1>No result </h1>";
        } else {
    
          while ($row = mysqli_fetch_assoc($search_query)) {
              $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>
            <i class="bi bi-clock"></i> Posted on <?php echo $post_date ?>
          </p>
          <hr />
          <img class="img-fluid" src="<?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' ?>

      <hr />

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