search.php

<?php require_once "includes/header.php" ?>
<?php require "includes/db.php" ?>
    <!-- Navigation -->
  <?php require "includes/navigation.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'];
                $query = "SELECT * FROM posts WHERE post_tags 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 {
                    $query = "SELECT * FROM posts WHERE post_tags LIKE '%$search%' ";
                    $select_all_posts_query = mysqli_query($connection, $query);
                    while ($row = mysqli_fetch_assoc($select_all_posts_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'];
                        ?>
                    <h1 class="page-header">
                    Page Head   s dasdasddd
                    <small>Secondary Text</small>
                </h1>

                <!-- 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> <?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 require "includes/sidebar.php" ?>

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

        <hr>
<?php require_once "includes/footer.php" ?>