
<?php 

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

	//$sql="select * from product_detail where prod_discount=(SELECT MAX(prod_discount) FROM product_detail) ";
	//$sql="select product.*,product_detail.* from product join product_detail on product.id=product_detail.prod_id GROUP BY product_detail.prod_id ORDER BY prod_discount DESC LIMIT 7";
	$sql="SELECT p.*, pd.* FROM 'product' p
	LEFT JOIN 'product_description' pd 
	    ON p.'product_id' = pd.'product_id' 
	ORDER BY p.'id' DESC
	LIMIT 10";
    $result = mysqli_query($conn, $sql);
	
	if(mysqli_num_rows($result) > 0) {
		while($row[] = mysqli_fetch_assoc($result)) {
 
		 $tem = $row;

		 }
	  $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);
}