Nomor 1
- File "Tampil.php" di edit menjadi :
?><h1>Tampil Data Barang</h1><table border=1><tr><td>No</td><td>Kode Barang</td><td>Nama Barang</td><td>Harga</td><td>Aksi</td></tr> <?phpwhile ($data = $query->fetch_array()){$kode = $data['KdBrg'];echo "<tr><td>" . $i++ . "</td><td>" . $data['KdBrg'] . "</td><td>" . $data['NmBrg'] . "</td><td>Rp." . number_format($data['Harga'],0,",",".") . ",-</td><td><a href='index.php?hal=ubah.php&kode=$kode'>Ubah</a> | <a href='index.php?hal=hapus.php&kode=$kode'>Hapus</a> </td></tr>";} ?></table>
- Membuat file baru yang diberi nama "Ubah.php"
<?php$kode = $_GET["kode"];$query = $koneksi->query("SELECT * FROM barang WHERE KdBrg LIKE '$kode'");$data = $query->fetch_array()?><form method="POST"><h1>Ubah Data Barang</h1><table><tr><td>Kode Barang :</td><td><input type="text" name="txtKd" value="<?php echo $data['KdBrg']; ?>"></td></tr><tr><td>Nama Barang :</td><td><input type="text" name="txtNm" value="<?php echo $data['NmBrg']; ?>"></td></tr><tr><td>Harga :</td><td><input type="text" name="txtHr" onkeyup="this.value=this.value.replace(/[^\d]/,'')" value="<?php echo $data['Harga']; ?>"></td></tr><tr><td colspan="2"><input type="submit" value="Ubah" name="btnUbah"></td></tr></table></form><?phpif (isset($_POST["btnUbah"])){#tampung ke variabel yang isian dari form$kode = $_POST["txtKd"];$nama = $_POST["txtNm"];$harga = $_POST["txtHr"];#coba cek ada gak isinyaecho $kode . $nama . $harga;$query = $koneksi->query("UPDATE barang SET NmBrg='$nama', Harga='$harga' WHERE KdBrg='$kode' ");
} #akhir tombol simpan diklik