Advertisement
Guest User

Untitled

a guest
Aug 24th, 2020
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.51 KB | None | 0 0
  1. <?php
  2.  
  3. $koneksi = mysqli_connect("localhost","root","","posijb");
  4. $noppb=$_POST['noppb'];
  5. $tgl=$_POST['tgl'];
  6. $jenis=$_POST['jenis'];
  7. $keperluan=$_POST['keperluan'];
  8. function proses_hoby($ppb_id)
  9. {
  10. if(isset($_POST["deskripsi"]))
  11. {
  12. $hoby=$_POST["deskripsi"];
  13. reset($hoby);
  14. foreach ($hoby as $key => $val) {
  15. $deskripsi =$_POST["deskripsi"][$key];
  16. $qty =$_POST["qty"][$key];
  17. $satuan =$_POST["satuan"][$key];
  18. $harga =$_POST["harga"][$key];
  19. $bayar =$_POST["bayar"][$key];
  20. $pembayaran =$_POST["pembayaran"][$key];
  21. $supplier_id =$_POST["supplier_id"][$key];
  22. $rekening =$_POST["rekening"][$key];
  23. $koneksi = mysqli_connect("localhost","root","","posijb");
  24. $sql_hoby ="UPDATE desppb(deskripsi, qty, satuan, harga, bayar, pembayaran, supplier_id, rekening) VALUES('$deskripsi','$qty','$satuan','$harga','$bayar','$pembayaran','$supplier_id','$rekening') WHERE ppb_id=$ppb_id";
  25. $hasil_hoby=mysqli_query($koneksi,$sql_hoby);
  26. }
  27. }
  28. }
  29.  
  30. $sql= "UPDATE ppb(noppb,tgl,jenis,keperluan)
  31. VALUES('$noppb','$tgl','$jenis','$keperluan') WHERE ppb_id=$ppb_id";
  32. $hasil=mysqli_query($koneksi,$sql);
  33. $ppb_id=mysqli_insert_id($koneksi);
  34. if($hasil)
  35. {
  36. proses_hoby($ppb_id);
  37. redirect('ppb');
  38. }
  39. else
  40. {
  41. echo "Data Gagal diinput";
  42. }
  43.  
  44. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement