editb

<?php
    include '../../inc/koneksi.php';

        ?>

<!DOCTYPE html>
<html>
<head>
    <title>input Barang</title>
</head>

<?php

    $kt = "SELECT * FROM kategori";
    $data1=mysqli_query($koneksi,$kt);
    $hasil1 =mysqli_fetch_array($data1);

?>

<body>
    <?php
        $id = @$_GET['id_barang'];
        $query = mysqli_query($koneksi,"SELECT * FROM barang WHERE id_barang='$id'");
        $data = mysqli_fetch_assoc($query);

    ?>

    <div class="col-md-4">
        <div class="row">
        <h3>Input Data</h3>

    <form method="POST">
          <div class="form-group">
            <label>Id Barang</label>
            <input name="id_barang" type="text" readonly="readonly" class="form-control" value="<?php echo $data['id_barang']; ?>">
          </div>
          <div class="form-group">
            <label>Kategori</label>
            <select name="kategori" class="form-control">
                <option value="#">Pilih Kategori</option>
                <?php  $kat = $data1; foreach($kat as $isi){ ?>
                <option value="<?php echo $isi['id_kategori'];?>"><?php echo $isi['nama_kategori'];?></option>
                <?php }?>"></option>
            </select>
          </div>
          <div class="form-group">
            <label>Nama Barang</label>
            <input name="nama" type="text" class="form-control" value="<?php echo $data['nama_barang'];?>">
          </div>
          <div class="form-group">
            <label>Merk Barang</label>
            <input name="merk" type="text" class="form-control" value="<?php echo $data['merk'];?>">
          </div>
          <div class="form-group">
            <label>Harga Beli</label>
            <input name="hbeli" type="number" class="form-control" value="<?php echo $data['harga_beli'];?>">
          </div>
          <div class="form-group">
            <label>Harga Jual</label>
            <input name="hjual" type="number" class="form-control" value="<?php echo $data['harga_jual']; ?>">
          </div>
          <div class="form-group">
            <label>Satuan Barang</label>
           <input name="satuan" type="text" class="form-control" value="<?php echo $data['satuan_barang']; ?>">
          </div>
           <div class="form-group">
            <label>Stok</label>
            <input name="stok" type="number" class="form-control" value="<?php echo $data['stok'] ?>">
          </div>
          <div class="form-group">
            <label>Tanggal Update</label>
            <input type="text" readonly="readonly" class="form-control" value="<?php echo  date("j F Y, G:i");?>" name="tgl">
          </div>
          <input type="submit"  name="fsimpan" class="btn btn-sm btn-success" value="simpan">
          <a class="btn btn-sm btn-danger" href="?menu=data_barang">kembali</a>
    </form>
        <?php
            if(isset($_POST['fsimpan'])){
                $idbarang   = $_POST['id_barang'];
                $kategori   = $_POST['kategori'];
                $namabarang = $_POST['nama'];
                $merk       = $_POST['merk'];
                $hbeli      = $_POST['hbeli'];
                $hjual      = $_POST['hjual'];
                $satuan     = $_POST['satuan'];
                $stok       = $_POST['stok'];
                $tgl        = $_POST['tgl'];

                $query      ="UPDATE barang SET id_barang='$idbarang', nama_kategori='$kategori', nama_barang='$namabarang', merk='$merk', harga_beli='$hbeli', harga_jual='$hjual', satuan_barang='$satuan', stok='$stok', tgl_update='$tgl' WHERE id_barang='$id'";
                $hasil = mysqli_query($koneksi,$query);

            }
        ?>

    </table>
    </div>
</div>
</body>
</html>