
<?php
    $id=$_GET['id'];
    // buka koneksi ke mysql db
    $koneksi = mysqli_connect("localhost","balipape_bali","R#DF,~E1UFg-","balipape_bali") or die("Error " .mysqli_error($koneksi));

    //ambil baris tabel dari mysql db
    $sql = "select a.transaction_id,a.product_id,a.quantity,b.sku,b.name,a.unit_price_inc_tax from transaction_sell_lines a,products b 
     where a.product_id=b.id and a.transaction_id=$id";
    $hasil = mysqli_query($koneksi, $sql) or die("Kesalahan dalam Memilih " .mysqli_error($koneksi));

   
if(mysqli_num_rows($hasil) > 0 ){
  $response = array();
  $response["djual"] = array();
  while($x = mysqli_fetch_array($hasil)){
    $h['transaction_id'] = $x["transaction_id"];
    $h['product_id'] = $x["product_id"];
    $h['quantity'] = $x["quantity"];
	$h['sku'] = $x["sku"];
	$h['name'] = $x["name"];
	$h['unit_price_inc_tax'] = $x["unit_price_inc_tax"];
	array_push($response["djual"], $h);
  }
  echo json_encode($response);
}else {
  $response["djual"]="[{}]";
  echo json_encode($response);
}
    // tutup koneksi db
    mysqli_close($koneksi);
?>