View difference between Paste ID: tENRq00B and TagRz73D
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>