Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include '../../inc/koneksi.php';
- if(isset($_POST['fsimpan'])&&isset($_POST['id_barang'])){
- $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
- 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='$idbarang'";
- $hasil = mysqli_query($koneksi,$query);
- if(!$hasil) die('error di:'.$query);
- }
- ?>
- <!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
- //===
- ?>
- </table>
- </div>
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment