Guest User

simpan

a guest
Aug 24th, 2020
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.53 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 ="INSERT INTO desppb(deskripsi, qty, satuan, harga, bayar, pembayaran, supplier_id, rekening, ppb_id)
  25. VALUES('$deskripsi','$qty','$satuan','$harga','$bayar','$pembayaran','$supplier_id','$rekening','$ppb_id')";
  26. $hasil_hoby =mysqli_query($koneksi,$sql_hoby);
  27. }
  28. }
  29. }
  30.  
  31. $sql= "INSERT INTO ppb(noppb,tgl,jenis,keperluan)
  32. VALUES('$noppb','$tgl','$jenis','$keperluan')";
  33. $hasil=mysqli_query($koneksi,$sql);
  34. $ppb_id=mysqli_insert_id($koneksi);
  35. if($hasil)
  36. {
  37. proses_hoby($ppb_id);
  38. redirect('ppb');
  39. }
  40. else
  41. {
  42. echo "Data Gagal diinput";
  43. }
  44.  
  45. ?>
Add Comment
Please, Sign In to add comment