<?php
include '../../include/conf.php';
	$get_prod = "SELECT * from shop_product_malayasia where (product_id!='173' AND product_id!='172' AND product_id!='174' AND product_id!='175' AND product_id!='176' AND product_id!='177' AND product_id!='178' ) and v_s='0'  order by name asc";
	$get_prod_det = mysqli_query($conn, $get_prod );
while ($get_prod_deta = mysqli_fetch_array($get_prod_det, MYSQLI_ASSOC)){
	$get_stock = mysqli_query($conn, "select * from tbl_malaysia_update_stock where product_id = '$get_prod_deta[product_id]' order by id desc limit 1");
$get_stock_update = mysqli_fetch_array($get_stock, MYSQLI_ASSOC);
$check_rows = mysqli_num_rows($get_stock);
	if ($check_rows > 0){
		$stock = $get_stock_update['current_stock'];
	}else{
		$stock = 0;
	}
 $data[] = array('prod_id'=>$get_prod_deta['product_id'], 'prod_name'=>$get_prod_deta['name'], 'price'=>$get_prod_deta['ean'],'id'=>$get_prod_deta['product_id'], 'current_stock'=>$stock);            
}
                 
    if(!empty($data))
        {
            echo json_encode(array(
                "aaData"=>$data));
        }
        else
        {
            echo json_encode(array('aaData'=>[]));
        }
?>