You search for $search_query";
$query = "SELECT * FROM product_service WHERE (item_value LIKE'%$search_query%' OR item_name LIKE'%$search_query%' OR item_detail LIKE'%$search_query%' OR id LIKE'%$search_query%')";
$result = mysqli_query($conn, $query) or die(mysqli_error($conn));
//loop through the query result and print
while($info = mysqli_fetch_array($result)){
$item_id=$info['id'];
$what_for=$info['what_for'];
$item_value=$info['item_value'];
$item_category=$info['item_category'];
$item_name=$info['item_name'];
$item_detail=$info['item_detail'];
$owner_location=$info['owner_location'];
$photo1 =$info['photo1'];
$photo2 =$info['photo2'];
$photo3 =$info['photo3'];
$date_uploaded =$info['date_uploaded'];
$date_modify =$info['date_modify'];
$status =$info['status'];
$item_detail = str_replace("\n", '
', $item_detail); if($photo1 != ""){ $show_img = "![](\"piks/$photo1\")
";
}else{
$show_img ="![](\"images/no_image.jpg\")
";
}
include('admin/inc_type.php');
$cat_id=$item_category;
include('admin/inc_cat.php');
if($what_for==2){
$item_value="N $item_value";
}
if($cat_status != 'hide'){
include('inc_whatsapp_enquiry.php');
print '
'.$whatapp_enq_msg.' Detail
';
}
}
}
?>
', $item_detail); if($photo1 != ""){ $show_img = "
";
}
include('admin/inc_type.php');
$cat_id=$item_category;
include('admin/inc_cat.php');
if($what_for==2){
$item_value="
'.$show_img.'
'.$item_name.'
Price:'.$item_value.'
Category:
'.$cat_name.'
'.$item_detail.'
'.$whatapp_enq_msg.' Detail