search.php

<?php
include "includes/header.php";
include "includes/navigation.php";
?>

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

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

                <?php
                /* SEARCH */
                if (isset($_POST['submit'])) {
                    $search = $_POST['search'];

                    $query = "SELECT * FROM posts WHERE 
                            post_title LIKE '%$search%' OR
                            post_author LIKE '%$search%' OR
                            post_content LIKE '%$search%' OR
                            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 FOR ". $search . "</h1>";
                    } else {
                        /* Displaying the results from the search */
                        $search_query = mysqli_query($connection, $query);
                        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'];
                            ?>

                            <h1 class="page-header">
                                Page Heading
                                <small>Secondary Text</small>
                            </h1>

                            <h2>
                                <!--Blog Post Title--><a href="#"><?php echo $post_title ?></a>
                            </h2>
                            <p class="lead">
                                <!--Blog Post Author-->by <a href="index.php"><?php echo $post_author ?></a>
                            </p>
                                <!--Blog Post Date--><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>
                            <!--Blog Post Content--><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>

    <!-- Footer -->
<?php
include "includes/footer.php";
?>