kura2yamato

gagal update?

Aug 25th, 2020 (edited)
291
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. $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.         {
  28.             echo "Failed to connect to MySQL: " . mysqli_connect_error();
  29.             exit();
  30.         }
  31.         $sql_hoby = "replace into 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";
  32.         $hasil_hoby = mysqli_query($koneksi, $sql_hoby);
  33.  
  34.     }
  35. }
  36.  
  37. $sql = "replace into 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. ?>
  54.  
Add Comment
Please, Sign In to add comment