<?php 
include("db_config.php"); 
if($_SERVER['REQUEST_METHOD']=='POST'){
$feacture = "1";
$sql="select sub_category.sub_category_name,category.cat_name,sub_sub_category.sub_sub_cat_name,product.* from product join category on product.category_id=category.id join sub_category on product.sub_category_id=sub_category.id join sub_sub_category on product.sub_sub_cat_id=sub_sub_category.id  where feacture_product='$feacture'";
$result = mysqli_query($conn, $sql);
if(mysqli_num_rows($result) > 0) {
		/*$sql_qry= mysqli_query($conn,"select product.* from product where sub_sub_cat_id='$sub_sub_cat'");
		while($res = mysqli_fetch_assoc($sql_qry)) {
		$prd_id=$res['id'];
		$sql="select * from product_detail  where prod_id='$prd_id'";
        $results = mysqli_query($conn, $sql);
		//echo json_encode(array('posts'=>$posts));
		while($rows[] = mysqli_fetch_assoc($results)) {
 
		 $prd = $rows;
		 }
		}*/
	while($row[] = mysqli_fetch_assoc($result)) {
	 $tem = $row;
	// $json = json_encode($tem);
    }

     //$response['data_prd']=$prd;
     $response['data']=$tem;
     $response['status']=1;
}
else {
	 $response['status']=0;
}
	echo json_encode($response);
	mysqli_close($conn);
}


?>