SHOW:
|
|
- or go back to the newest paste.
| 1 | <?php | |
| 2 | include '../../inc/koneksi.php'; | |
| 3 | if(isset($_POST['fsimpan'])&&isset($_POST['id_barang'])){
| |
| 4 | $idbarang = $_POST['id_barang']; | |
| 5 | $kategori = $_POST['kategori']; | |
| 6 | $namabarang = $_POST['nama']; | |
| 7 | $merk = $_POST['merk']; | |
| 8 | $hbeli = $_POST['hbeli']; | |
| 9 | $hjual = $_POST['hjual']; | |
| 10 | $satuan = $_POST['satuan']; | |
| 11 | $stok = $_POST['stok']; | |
| 12 | $tgl = $_POST['tgl']; | |
| 13 | ||
| 14 | $query ="UPDATE barang SET | |
| 15 | nama_kategori='$kategori', nama_barang='$namabarang', merk='$merk', | |
| 16 | harga_beli='$hbeli', harga_jual='$hjual', satuan_barang='$satuan', | |
| 17 | stok='$stok', tgl_update='$tgl' | |
| 18 | WHERE id_barang='$idbarang'"; | |
| 19 | $hasil = mysqli_query($koneksi,$query); | |
| 20 | if(!$hasil) die('error di:'.$query);
| |
| 21 | ||
| 22 | } | |
| 23 | ?> | |
| 24 | ||
| 25 | <!DOCTYPE html> | |
| 26 | <html> | |
| 27 | <head> | |
| 28 | <title>input Barang</title> | |
| 29 | </head> | |
| 30 | ||
| 31 | <?php | |
| 32 | ||
| 33 | $kt = "SELECT * FROM kategori"; | |
| 34 | $data1=mysqli_query($koneksi,$kt); | |
| 35 | $hasil1 =mysqli_fetch_array($data1); | |
| 36 | ||
| 37 | ?> | |
| 38 | ||
| 39 | <body> | |
| 40 | <?php | |
| 41 | $id = @$_GET['id_barang']; | |
| 42 | $query = mysqli_query($koneksi,"SELECT * FROM barang WHERE id_barang='$id'"); | |
| 43 | $data = mysqli_fetch_assoc($query); | |
| 44 | ||
| 45 | ?> | |
| 46 | ||
| 47 | <div class="col-md-4"> | |
| 48 | <div class="row"> | |
| 49 | <h3>Input Data</h3> | |
| 50 | ||
| 51 | <form method="POST"> | |
| 52 | <div class="form-group"> | |
| 53 | <label>Id Barang</label> | |
| 54 | <input name="id_barang" type="text" readonly="readonly" class="form-control" value="<?php echo $data['id_barang']; ?>"> | |
| 55 | </div> | |
| 56 | <div class="form-group"> | |
| 57 | <label>Kategori</label> | |
| 58 | <select name="kategori" class="form-control"> | |
| 59 | <option value="#">Pilih Kategori</option> | |
| 60 | <?php $kat = $data1; foreach($kat as $isi){ ?>
| |
| 61 | <option value="<?php echo $isi['id_kategori'];?>"><?php echo $isi['nama_kategori'];?></option> | |
| 62 | <?php }?>"></option> | |
| 63 | </select> | |
| 64 | </div> | |
| 65 | <div class="form-group"> | |
| 66 | <label>Nama Barang</label> | |
| 67 | <input name="nama" type="text" class="form-control" value="<?php echo $data['nama_barang'];?>"> | |
| 68 | </div> | |
| 69 | <div class="form-group"> | |
| 70 | <label>Merk Barang</label> | |
| 71 | <input name="merk" type="text" class="form-control" value="<?php echo $data['merk'];?>"> | |
| 72 | </div> | |
| 73 | <div class="form-group"> | |
| 74 | <label>Harga Beli</label> | |
| 75 | <input name="hbeli" type="number" class="form-control" value="<?php echo $data['harga_beli'];?>"> | |
| 76 | </div> | |
| 77 | <div class="form-group"> | |
| 78 | - | if(isset($_POST['fsimpan'])){
|
| 78 | + | |
| 79 | <input name="hjual" type="number" class="form-control" value="<?php echo $data['harga_jual']; ?>"> | |
| 80 | </div> | |
| 81 | <div class="form-group"> | |
| 82 | <label>Satuan Barang</label> | |
| 83 | <input name="satuan" type="text" class="form-control" value="<?php echo $data['satuan_barang']; ?>"> | |
| 84 | </div> | |
| 85 | <div class="form-group"> | |
| 86 | <label>Stok</label> | |
| 87 | <input name="stok" type="number" class="form-control" value="<?php echo $data['stok'] ?>"> | |
| 88 | </div> | |
| 89 | - | $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'"; |
| 89 | + | |
| 90 | <label>Tanggal Update</label> | |
| 91 | <input type="text" readonly="readonly" class="form-control" value="<?php echo date("j F Y, G:i");?>" name="tgl">
| |
| 92 | </div> | |
| 93 | <input type="submit" name="fsimpan" class="btn btn-sm btn-success" value="simpan"> | |
| 94 | <a class="btn btn-sm btn-danger" href="?menu=data_barang">kembali</a> | |
| 95 | </form> | |
| 96 | <?php | |
| 97 | //=== | |
| 98 | ?> | |
| 99 | ||
| 100 | </table> | |
| 101 | </div> | |
| 102 | </div> | |
| 103 | </body> | |
| 104 | </html> |