solusi 105

<?php
$koneksi = mysqli_connect("localhost", "root", "", "posijb");
$noppb = $_POST['noppb'];
$tgl = $_POST['tgl'];
$jenis = $_POST['jenis'];
$keperluan = $_POST['keperluan'];
function proses_hoby($ppb_id)
{
    if (isset($_POST["deskripsi"]))
    {
        $hoby = $_POST["deskripsi"];
        reset($hoby);
        $koneksi = mysqli_connect("localhost", "root", "", "posijb");
        foreach ($hoby as $key => $val)
        {
            $deskripsi = $_POST["deskripsi"][$key];
            $qty = $_POST["qty"][$key];
            $satuan = $_POST["satuan"][$key];
            $harga = $_POST["harga"][$key];
            $bayar = $_POST["bayar"][$key];
            $pembayaran = $_POST["pembayaran"][$key];
            $supplier_id = $_POST["supplier_id"][$key];
            $rekening = $_POST["rekening"][$key];

            if (mysqli_connect_errno()) {
              echo "Failed to connect to MySQL: " . mysqli_connect_error();
              exit();
            }
            $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";
            $hasil_hoby = mysqli_query($koneksi, $sql_hoby) or die($sql_hoby."\n<br>error:".mysqli_error($koneksi);

        }
    }
}

$sql = "UPDATE ppb(noppb,tgl,jenis,keperluan)
                      VALUES('$noppb','$tgl','$jenis','$keperluan') WHERE ppb_id=$ppb_id";
//$hasil = mysqli_query($koneksi, $sql);
$hasil_hoby = mysqli_query($koneksi, $sql) or die($sql."\n<br>error:".mysqli_error($koneksi);
//$ppb_id = mysqli_insert_id($koneksi);
//insert yg balikin id bukan update
if($hasil)
{
    proses_hoby($ppb_id);
    redirect('ppb');
}
else
{
    echo "Data Gagal diinput";
}

?>