searchitems.php

<?php
    include('topmenu.php');
    $connection = mysqli_connect("localhost", "root", "", "shopping") or die("Check sql connection!");
    $tosearch=$_POST['tosearch'];
    $query="select * from products where ";
    $query_fields = Array();
    $sql = "show columns from products";
    $columnlist = mysqli_query($connection, $sql) or die(mysql_error());
    while($arr = mysqli_fetch_assoc($columnlist)) {
        extract($arr);
        $query_fields[] = $Field . " like('%" . $tosearch . "%')";
    }
    $query .= implode(" OR ", $query_fields);
    $results = mysqli_query($connection, $query) or die(mysql_error());
    echo "<table border=\"0\">";
    $x = 1;
    echo "<tr>";
    while($row = mysqli_fetch_assoc($results)) {
        if($x <= 6) {
            $x = $x + 1;
            extract($row);
            echo "<td style=\"padding-right: 15px;\">";
            echo "<a href=itemdetails.php?itemcode=$item_code>";
            echo '<img src=' . $imagename . ' style="max-width: 220px; max-height: 240px; width: auto; height: auto;"><br>';
            echo $item_name . '<br>';
            echo "</a>";
            echo '$'.$price . '<br>';
            echo "</td>";
        } else {
            $x = 1;
            echo "</tr><tr>";
        }
    }
    echo "</table>";
?>