Advertisement
Guest User

Untitled

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