Membuat APlikasi Stok Barang dan Fungsi View, edit, Stok, dan Hapus Pada PHP

Pertama membuat kodingan formtambah.php untuk tambah  barang buatlah form biasa untuk menambah

Nama, Id Barang, Deskripsi,  Harga dan Stok

formtambah.php

<form method=”POST” action=”prosestambah.php” enctype=”multipart/form-data”>
<table>
<tr>
<td>Gambar</td>
<td>:</td>
<td><input type=”file” name=”gambar”></td>
</tr>
<tr>
<td>ID Barang</td>
<td>:</td>
<td><input type=”text” name=”id” ></td>
</tr>
<tr>
<td>Nama Barang</td>
<td>:</td>
<td><input type=”text” name=”nama” ></td>
</tr>
<tr>
<td>Deskripsi</td>
<td>:</td>
<td><textarea name=”deskripsi”></textarea></td>
</tr>
<tr>
<td>Harga</td>
<td>:</td>
<td><input type=”text” name=”harga” ></td>
</tr>
<tr>
<td>Stok</td>
<td>:</td>
<td><input type=”text” name=”jumlah” ></td>
</tr>
<tr>
<td></td>
<td></td>
<td><input type=”submit” name=”submit” ></td>
</tr>
</table>
</form>

 

langkah selanjutnya adalah membuat kodingan koneksi dulu

koneksi.php

<?php
$hostname = “localhost”;
$username = “root”;
$password = “”;
$dbname = “databarang”;
$db = new mysqli($hostname, $username, $password, $dbname);
?>

kemudian buatlah fungsi tambah berubpa tumol button submit agar data yang di input dapat tersimpan

prosestambah.php

<?php
if (isset($_POST[‘submit’])) {
$id_barang=$_POST[‘id’];
$nama_barang=$_POST[‘nama’];
$deskripsi=$_POST[‘deskripsi’];
$harga=$_POST[‘harga’];
$jumlah=$_POST[‘jumlah’];
//$foto=$_FILES[‘fileToUpload’];

$fileName = $_FILES[‘gambar’][‘name’];
move_uploaded_file($_FILES[‘gambar’][‘tmp_name’], “uploads/”.$_FILES[‘gambar’][‘name’]);

include ‘koneksi.php’;
$sql1=”INSERT INTO `barang`(`id_barang`, `nama_barang`, `gambar`, `harga`, `deskripsi`) VALUES                        (‘$id_barang’,’$nama_barang,’$fileName’, ‘$harga’, ‘$deskripsi’)”;
$sql2=”INSERT INTO `stok` (`id_barang`, `jumlah`) VALUES (‘$id_barang’, ‘$jumlah’)”;
$simpan1=mysqli_query($db,$sql1);
$simpan2=mysqli_query($db,$sql2);
if ($simpan1 && $simpan2) {
//echo “<p>POSTED</p>”;
header(‘Location:index.php’);
}else{
echo “<p>POST ERROR</p>”;
}
}
?>

Kemudian buat file indek.php yang berisi view, edit,stok dan delete.

indek.php

<div align=”center”>
<?php
include ‘koneksi.php’;
$sele=”SELECT barang.id_barang, barang.nama_barang, barang.harga, stok.jumlah FROM barang INNER JOIN stok ON barang.id_barang=stok.id_barang”;
$feed = $db->query($sele);
//$query = mysqli_query($connection,”SELECT * FROM rsh_admin ORDER BY id DESC”);

if(mysqli_num_rows($feed)>0){
$no = 1;
echo “<table border=1>”;
echo “<tr><th>IDBARANG</th> <th>Nama Barang</th> <th>Harga</th> <th>Stok</th>  <th>Aksi</th></tr>”;
while($data = mysqli_fetch_array($feed)){
echo “<tr>”;//nama
echo “<td>”;
echo $data[‘id_barang’];
echo “</td>”;
echo “<td>”;
echo $data[‘nama_barang’];
echo “</td>”;
echo “<td>”;
echo $data[‘harga’];
echo “</td>”;
echo “<td>”;
echo $data[‘jumlah’];
echo “</td>”;
echo “<td>”;
echo “<a href=’detail.php?id_barang=”.$data[‘id_barang’].”‘>View</a> || <a href=’editbarang.php?           id_barang=”.$data[‘id_barang’].”‘>Edit</a> || <a href=’updatestok.php?id_barang=”.$data[‘id_barang’].”‘>+ Stok</a> || <a href=’delectbarang.php?id_barang=”.$data[‘id_barang’].”‘>Hapus</a>”;
echo “</td>”;
echo “</tr>”;
$no++;
}
echo “</table>”;
}
?>
<a href=”formtambah.php”>Tambah barang!</a>
</div>

 

kemudian buat file detail.php untuk melihat data keseluruhan

detail.php

<?php
include ‘koneksi.php’;
$id=$_GET[‘id’];
$sele=”SELECT barang.gambar, barang.id, barang.nama, barang.deskripsi, barang.harga, stok.jumlah FROM barang INNER JOIN stok ON barang.id=stok.id where barang.id=’$id’”;
$feed = $db->query($sele);
$data = mysqli_fetch_array($feed);
?>
<form>
<table>
<tr>
<td>Gambar</td>
<td>:</td>
<td><img src=”<?php echo ‘uploads/’.$data[‘gambar’];?>” height=”100″ width=”100″></td>
</tr>
<tr>
<td>ID Barang</td>
<td>:</td>
<td><?php echo $data[‘id_barang’];?></td>
</tr>
<tr>
<td>Nama Barang</td>
<td>:</td>
<td><?php echo $data[‘nama_barang’];?></td>
</tr>
<tr>
<td>Deskripsi</td>
<td>:</td>
<td><?php echo $data[‘deskripsi’];?></td>
</tr>
<tr>
<td>Harga</td>
<td>:</td>
<td><?php echo $data[‘harga’];?></td>
</tr>
<tr>
<td>Stok</td>
<td>:</td>
<td><?php echo $data[‘jumlah’];?></td>
</tr>
</table>
</form>

 

Kemudian file editbarang.php untuk melakukan edit yang dibantu dengan file prosesupdate.php .

editbarang.php

<?php
include ‘koneksi.php’;
$id=$_GET[‘id’];
$sele=”SELECT barang.gambar, barang.id, barang.nama, barang.deskripsi, barang.harga, stok.jumlah FROM barang             INNER JOIN stok ON barang.id_=stok.id where barang.id=’$id’”;
$feed = $db->query($sele);
$data = mysqli_fetch_array($feed);
?>
<form method=”POST” action=”prosesupdate.php” enctype=”multipart/form-data”>
<table>
<tr>
<td>Gambar</td>
<td>:</td>
<td><input type=”file” name=”gambar”></td>
</tr>
<tr>
<td>ID Barang</td>
<td>:</td>
<td><input type=”text” name=”id” value=”<?php echo $data[‘id’];?>” readonly></td>
</tr>
<tr>
<td>Nama Barang</td>
<td>:</td>
<td><input type=”text” name=”nama” value=”<?php echo $data[‘nama’];?>”></td>
</tr>
<tr>
<td>Deskripsi</td>
<td>:</td>
<td><textarea name=”deskripsi”> <?php echo $data[‘deskripsi’];?> </textarea></td>
</tr>
<tr>
<td>Harga</td>
<td>:</td>
<td><input type=”text” name=”harga” value=”<?php echo $data[‘harga’];?>”></td>
</tr>
<tr>
<td>Stok</td>
<td>:</td>
<td><input type=”text” name=”jumlah” value=”<?php echo $data[‘jumlah’];?>”></td>
</tr>
<tr>
<td></td>
<td></td>
<td><input type=”submit” name=”update”></td>
</tr>
</table>
</form>

prosesupdate.php

<?php
include ‘koneksi.php’;
if (isset($_POST[‘update’])) {
$id_barang             =$_POST[‘id’];
$nama_barang   =$_POST[‘nama’];
$deskripsi             =$_POST[‘deskripsi’];
$harga                    =$_POST[‘harga’];
$jumlah                 =$_POST[‘jumlah’];
//$foto                      =$_FILES[‘fileToUpload’];

$fileName = $_FILES[‘gambar’][‘name’];
move_uploaded_file($_FILES[‘gambar’][‘tmp_name’], “uploads/”.$_FILES[‘gambar’][‘name’]);

//if (empty($error_cerita)) {
$sql1=”UPDATE `barang` SET `nama`=’$nama’,`gambar`=’$fileName’,`harga`=’$harga’,`deskripsi`=’$deskripsi’ WHERE `id`=’$id’”;
$sql2=”UPDATE `stok` SET `jumlah`=’$jumlah’ WHERE `id`=’$id’”;
$simpan1=mysqli_query($db,$sql1);
$simpan2=mysqli_query($db,$sql2);
if ($simpan1 && $simpan2) {
//echo “<p>POSTED</p>”;
header(‘Location:indek.php’);
}else{
echo “<p>POST ERROR</p>”;
}
//}

}
?>

Membuat file updatestok.php untuk melakukan stok yang digunakan untuk menambah stok.

updatestok.php

<?php
include ‘koneksi.php’;
$id=$_GET[‘id’];
$sele=”SELECT * FROM `stok` WHERE `id`=$id”;
$feed = $db->query($sele);
$data = mysqli_fetch_array($feed);

$jumlahawal=$data[‘jumlah’];
?>
<form method=”POST”>
<table>
<tr>
<td>ID Barang</td>
<td>:</td>
<td><input type=”text” name=”id” value=”<?php echo $data[‘id’];?>” readonly></td>
</tr>
<tr>
<td>Tambah Stok</td>
<td>:</td>
<td><input type=”text” name=”tambahjumlah”></td>
</tr>
<tr>
<td></td>
<td></td>
<td><input type=”submit” name=”submit” ></td>
</tr>
</table>
</form>
<?php
if (isset($_POST[‘submit’])) {
$id_barang=$_POST[‘id’];
$tambahjumlah=$_POST[‘tambahjumlah’];

$jumlah=$tambahjumlah+$jumlahawal;

$sql=”UPDATE `stok` SET `jumlah`=$jumlah WHERE `id`=$id”;
$db->query($sql);
header(‘location:indek.php’);
}
?>

File deletebarang.php untuk melakukan aksi Delete.

deletebarang.php

<?php
include ‘koneksi.php’;

$id = $_GET[‘id’];
echo $id;
$queryhapusbarang = “DELETE FROM `barang` WHERE id=$id”;
mysqli_query($db,$queryhapusbarang);

if(mysqli_affected_rows($db)>0){
header(“Location:indek.php”);
}
?>