<?php 

include("db_config.php"); 
if($_SERVER['REQUEST_METHOD']=='POST'){
 
   $item = $_POST['product_id'];

   $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 ");
	//$sql="select * from cities where state_id='36'";
	
	if(mysqli_num_rows($sql_rest) > 0) {
		while($row[] = mysqli_fetch_assoc($sql_rest)) {
		 $tem = $row;
		 //$json = json_encode($tem);

		 }
	  $response['data']=$tem;
	  $response['status']=1;
	}
	else {
		//$json =  json_encode(array("status" => 0, "msg" => "data Not Found!"));
		$response['status']=0;
	}
	echo json_encode($response);
	mysqli_close($conn);
}