 
<?php
include("includes/db_config.php");  
if($_POST)
{
$item=$_POST['searchword'];
$sql_res=mysqli_query($conn, "select * from category where cat_name like '%$item%'");
$rows=mysqli_fetch_array($sql_res);
$cat=$rows['id'];

$sql_res1=mysqli_query($conn, "select * from sub_category where sub_category_name like '%$item%'");
$row1=mysqli_fetch_array($sql_res1);
$sub_cat=$row1['id'];

$sql_res2=mysqli_query($conn, "select * from sub_sub_category where sub_sub_cat_name like '%$item%'");
$row2=mysqli_fetch_array($sql_res2);
$ss_cat=$row2['id'];


$sql_rest=mysqli_query($conn, "select * from product where prod_name like '%$item%' or category_id='$cat' or sub_category_id='$sub_cat' or sub_sub_cat_id='$ss_cat' order by id ");
while($row=mysqli_fetch_array($sql_rest))
{
$name=$row['prod_name'];
//$category=$row['categoryname'];
$img=$row['prod_img1'];
//$subcategory=$row['subcategoryname'];

$re_name='<b>'.$item.'</b>';
//$re_category='<b>'.$item.'</b>';

$final_fname = str_ireplace($item, $re_name, $name);

//$final_lname = str_ireplace($q, $re_category, $category);


?>
<div class="display_box" style="width: 100%;backround-color:#fff;height:30px;border-bottom:1px solid #ccc; text-align: left; color:#000; text-transform:capitalize" onclick="inputsearch(<?php echo $row['id']; ?>);">
<!--<a href="item.php?product_id=<?php echo $row['product_id']; ?>">-->
<img src="admin/product/<?php echo $img; ?>" style="width:25px;padding:5px; float:left; margin-right:6px" />
<span id="searchname_<?php echo $row['id']; ?>" ><?php echo $final_fname; ?></span>
<!-- <span style="font-size:9px; color:#999999"><?php echo $subcategory; ?></span> -->
<!--</a>-->
</div>
<?php
}
}
else
{
}
?>