<?php

 $mysql = Mysqli_connect("localhost","root","","tugasdb");

if(isset($_POST['tambah'])){
    $idbarang = $_POST['idbarang'];
    $namabarang = $_POST['namabarang'];
    $hargajual = $_POST['hargajual'];
    $hargabeli = $_POST['hargabeli'];
    $sql1="insert into barang values('$idbarang','$namabarang','$hargajual','$hargabeli')";

    $result1=mysqli_query($mysql,$sql1);
    //echo "Barang Telah ditambahkan";
    header("location:barang.php");
 }
 if(isset($_POST['hapus'])){
    $idbarang = $_POST['idbarang'];
    $namabarang = $_POST['namabarang'];
    $sql1="delete from barang where idbarang='$idbarang'";
    $result1=mysqli_query($mysql,$sql1);
    //echo "Barang Telah ditambahkan";
    header("location:barang.php");
}

 if(isset($_POST['edit'])){
    $idbarang = $_POST['idbarang'];
    $namabarang = $_POST['namabarang'];
    $hargajual = $_POST['hargajual'];
    $hargabeli = $_POST['hargabeli'];

    if($namabarang != null || $namabarang != "") {
    $sql1="update barang set namabarang='$namabarang' where IdBarang ='$idbarang'";
    $result1=mysqli_query($mysql,$sql1);
    //echo $sql1;
    //echo "Barang Telah ditambahkan";

    } else if($hargajual != null || $hargajual != "") {
    $sql1="update barang set hargajual='$hargajual' where IdBarang ='$idbarang'";
    $result1=mysqli_query($mysql,$sql1);

    }else if($hargabeli != null || $hargabeli != "") {
    $sql1="update barang set hargabeli='$hargabeli' where IdBarang ='$idbarang'";
    $result1=mysqli_query($mysql,$sql1);

    } else if( $hargabeli != null && $hargabeli != "" && $hargajual != null && $hargajual != "" ){
    $sql1="update barang set hargabeli='$hargabeli', hargajual ='$hargajual' where IdBarang ='$idbarang'";
    $result1=mysqli_query($mysql,$sql1);
    }
 echo $sql1;
//header("location:barang.php");
}
mysqli_close($mysql);

?>