SHARE
TWEET

function simpanDetailPurchaseOrder

cumaSaputra Oct 21st, 2019 89 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function simpanDetailPurchaseOrder()
  2.         {
  3.             $db=$_POST;
  4.             $query = $db->prepare("UPDATE tbdetailpurchaseorder INNER JOIN tbdetailpurchaserequest ON (tbdetailpurchaseorder.IDPurchaseRequest = tbdetailpurchaserequest.IDPurchaseRequest) SET tbdetailpurchaseorder.IDPurchaseOrder = :IDPurchaseOrder, tbdetailpurchaseorder.IDPurchaseRequest = :IDPurchaseRequest, tbdetailpurchaserequest.status = :status, tbdetailpurchaseorder.namaOrder = :namaOrder, tbdetailpurchaseorder.tanggalOrder = :tanggalOrder, tbdetailpurchaseorder.purchaseOrder = :purchaseOrder, tbdetailpurchaseorder.IDNamaSupplier = :IDNamaSupplier, tbdetailpurchaseorder.hargaBarang = :hargaBarang, tbdetailpurchaserequest.IDNamaBarang = :IDNamaBarang, tbdetailpurchaserequest.stock = :stock WHERE tbdetailpurchaseorder.IDPurchaseRequest = :IDPurchaseOrder");
  5.  
  6.             $query->BindParam(':IDPurchaseOrder', $IDPurchaseOrder);
  7.             $query->BindParam(':IDPurchaseRequest',$IDPurchaseRequest);
  8.             $query->BindParam(':status',$status);
  9.             $query->BindParam(':namaOrder',$namaOrder);
  10.             $query->BindParam(':tanggalOrder', $tanggalOrder);
  11.             $query->BindParam(':purchaseOrder', $purchaseOrder);
  12.             $query->BindParam(':IDNamaSupplier',$IDNamaSupplier);
  13.             $query->BindParam(':hargaBarang', $hargaBarang);
  14.             $query->BindParam(':IDNamaBarang', $IDNamaBarang);
  15.             $query->BindParam(':stock', $stock);
  16.             $query->execute();
  17.         }
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top