<?php 
include'../dbc.php';
	header('Access-Control-Allow-Origin: *');//old
	header('Access-Control-Allow-Methods: GET, POST,PATCH,PUT,DELETE,OPTIONS');
	header('Access-Control-Allow-Headers: Origin,Content-Type,X-Auth-Token');
	header('Content-Type:application/json');//old
	
$sqlC=mysqli_query($conn,"select * from tbl_category ") or die(mysqli_error($conn));
while($rows=mysqli_fetch_assoc($sqlC)){
    $categoryNameAry[$rows['id']]=$rows['name'];
}

	$sql=mysqli_query($conn,"select * from tbl_product") or die(mysqli_error($conn));
	if(mysqli_num_rows($sql)>0)
	{
		$response=array();
		$showname2=array();
		$responseFinal=array();
		while($row=mysqli_fetch_assoc($sql))
		{
		
			extract($row);
			$showname=array();
			$showname["id"]	        =$id;
			$showname["catname"]	=$categoryNameAry[$category_id];
			$showname["name"]       =$name;
			// $showname["image"] ="http://localhost/common_product/media/product/".$image;

			array_push($response,$showname);
		}
			$showname2["success"] =1;
			$showname2["category"] =$response;
			array_push($responseFinal,$showname2);
		echo json_encode($responseFinal);
		
	}
	else
	{
		$response=array();
		$showname=array();
		$showname["success"]="0";
		array_push($response,$showname);
		echo json_encode($response);
	}
			
			
?>