<?php include("db_config.php"); 
if($_SERVER['REQUEST_METHOD']=='POST'){
	$product_id = $_POST['product_id'];
	$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 product.id='$product_id'";
    $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);
}


?>