Advertisement
kura2yamato

solusi 105b

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