21.19
Inayah Dreamer
Mambuat Aplikasi CRUD Sederhana dengan PHP dan MySQL
1.
Buat
database
CREATE DATABASE IF NOT EXISTS db_latihan;
USE db_latihan;
CREATE TABLE IF NOT EXISTS barang (
id_barang int(11) NOT NULL AUTO_INCREMENT,
nama_barang varchar(50) DEFAULT NULL,
satuan varchar(25) DEFAULT NULL,
harga_beli decimal(10,0) DEFAULT NULL,
harga_jual decimal(10,0) DEFAULT NULL,
jumlah_stok int(11) DEFAULT NULL,
user_name varchar(25) DEFAULT NULL,
tgl_proses datetime DEFAULT NULL,
PRIMARY KEY (id_barang)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
INSERT INTO barang (id_barang, nama_barang, satuan, harga_beli, harga_jual, jumlah_stok, user_name, tgl_proses) VALUES
(1, 'LAPTOP HP PAVILION DV4', 'PCS', 5000000, 6000000, 5, 'ADMIN', '2013-11-02 22:13:44'),
(2, 'MOUSE GENIUS X1', 'PCS', 100000, 125000, 10, 'ADMIN', '2013-11-02 22:13:45'),
(3, 'SPEAKER ALTEC', 'PCS', 350000, 500000, 5, 'ADMIN', '2013-11-02 22:13:46'),
(4, 'KEYBOARD GENIUS', 'PCS', 50000, 75000, 3, 'ADMIN', '2013-11-02 22:14:19'),
(5, 'FLASDISK HP 2GB', 'PCS', 60000, 80000, 7, 'ADMIN', '2013-11-02 22:15:25');
2.
Buat
koneksi database
koneksi.php
<?php
$hostname = "localhost";
$database = "db_latihan";
$username = "root";
$password = "";
mysql_connect($hostname, $username, $password) or die ("koneksi
database gagal !.");
mysql_select_db($database) or die ("buka
database gagal !.");
?>
3.
Buat
file daftar
barang_tampil.php
<?php
include ("koneksi.php");
$query = "select * from barang";
$result = mysql_query($query);
$total = mysql_num_rows($result);
?>
<html>
<head>
<title>tampil barang</title>
</head>
<body>
<h2>DAFTAR BARANG</h2>
<p><a href="barang_tambah.php">TAMBAH</a></p>
<table border="1" cellspacing="1" cellpadding="1">
<tr>
<td>ID BARANG</td>
<td>NAMA BARANG</td>
<td>SATUAN</td>
<td>HARGA BELI</td>
<td>HARGA JUAL</td>
<td>JUMLAH STOK</td>
<td>USER NAME</td>
<td>TGL. PROSES</td>
<td>PROSES</td>
</tr>
<?php while ($data = mysql_fetch_array($result)) { ?>
<tr>
<td><?php echo $data['id_barang']; ?></td>
<td><?php echo $data['nama_barang']; ?></td>
<td><?php echo $data['satuan']; ?></td>
<td><?php echo $data['harga_beli']; ?></td>
<td><?php echo $data['harga_jual']; ?></td>
<td><?php echo $data['jumlah_stok']; ?></td>
<td><?php echo $data['user_name']; ?></td>
<td><?php echo $data['tgl_proses']; ?></td>
<td><a href="barang_ubah.php?id=<?php echo $data['id_barang']; ?>">UBAH</a> | <a href="barang_hapus_query.php?id=<?php echo $data['id_barang']; ?>">HAPUS</td>
</tr>
<?php } ?>
</table>
<p>JUMLAH : <?php echo $total; ?> DATA</p>
</body>
</html>
4.
Buat file tambah
barang_tambah.php
<html>
<head>
<title>tambah barang</title>
</head>
<body>
<h2>TAMBAH BARANG</h2>
<form method="post" action="barang_tambah_query.php">
<table border="1" cellspacing="1" cellpadding="1">
<tr>
<td>ID BARANG :</td>
<td><input type="text" name="id_barang" disabled></td>
</tr>
<tr>
<td>NAMA BARANG :</td>
<td><input type="text" name="nama_barang"></td>
</tr>
<tr>
<td>SATUAN :</td>
<td><input type="text" name="satuan"></td>
</tr>
<tr>
<td>HARGA BELI :</td>
<td><input type="text" name="harga_beli"></td>
</tr>
<tr>
<td>HARGA JUAL :</td>
<td><input type="text" name="harga_jual"></td>
</tr>
<tr>
<td>JUMLAH STOK :</td>
<td><input type="text" name="jumlah_stok"></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="submit" value="SIMPAN">
<input type="button" value="BATAL" onclick="self.history.back();"></td>
</tr>
</table>
</form>
</body>
</html>
barang_tambah_query.php
<?php
include("koneksi.php");
$query = "insert into barang (id_barang,
nama_barang, satuan, harga_beli, harga_jual,
jumlah_stok, user_name, tgl_proses)
values (NULL, '$_POST[nama_barang]', '$_POST[satuan]',
'$_POST[harga_beli]', '$_POST[harga_jual]',
'$_POST[jumlah_stok]', 'ADMIN', now())";
$result = mysql_query($query);
if ($result) {
header("location:barang_tampil.php");
}
else {
echo "proses
simpan gagal !.";
}
?>
5.
Buat file ubah
barang_ubah.php
<?php
include ("koneksi.php");
$query = "select * from barang where
id_barang = '$_GET[id]'";
$result = mysql_query($query);
$data = mysql_fetch_array($result);
?>
<html>
<head>
<title>ubah barang</title>
</head>
<body>
<h2>UBAH BARANG</h2>
<form method="post" action="barang_ubah_query.php">
<table border="1" cellspacing="1" cellpadding="1">
<tr>
<td>ID BARANG :</td>
<td><input type="text" name="id_barang" readonly="true" value="<?php echo $data['id_barang']; ?>"></td>
</tr>
<tr>
<td>NAMA BARANG :</td>
<td><input type="text" name="nama_barang" value="<?php echo $data['nama_barang']; ?>"></td>
</tr>
<tr>
<td>SATUAN :</td>
<td><input type="text" name="satuan" value="<?php echo $data['satuan']; ?>"></td>
</tr>
<tr>
<td>HARGA BELI :</td>
<td><input type="text" name="harga_beli" value="<?php echo $data['harga_beli']; ?>"></td>
</tr>
<tr>
<td>HARGA JUAL :</td>
<td><input type="text" name="harga_jual" value="<?php echo $data['harga_jual']; ?>"></td>
</tr>
<tr>
<td>JUMLAH STOK :</td>
<td><input type="text" name="jumlah_stok" value="<?php echo $data['jumlah_stok']; ?>"></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="submit" value="SIMPAN">
<input type="button" value="BATAL" onclick="self.history.back();"></td>
</tr>
</table>
</form>
</body>
</html>
barang_ubah_query.php
<?php
include("koneksi.php");
$query = "update barang set nama_barang = '$_POST[nama_barang]',
satuan = '$_POST[satuan]', harga_beli = '$_POST[harga_beli]', harga_jual
= '$_POST[harga_jual]', jumlah_stok = '$_POST[jumlah_stok]',
user_name = 'ADMIN', tgl_proses = now() where id_barang = '$_POST[id_barang]'";
$result = mysql_query($query);
if ($result) {
header("location:barang_tampil.php");
}
else {
echo "proses
simpan gagal !.";
}
?>
6.
Buat file hapus
barang_hapus.php
<?php
include("koneksi.php");
$query = "delete from barang where id_barang
= '$_GET[id]'";
$result = mysql_query($query);
if ($result) {
header("location:barang_tampil.php");
}
else {
echo "proses
simpan gagal !.";
}
?>
Sekarang coba jalankan aplikasinya, sebagai contoh file-file di atas di simpan dalam folder crud maka ketik di browser http://localhost/crud/barang_tampil.php atau dapat juga di download di sini.
Sekarang coba jalankan aplikasinya, sebagai contoh file-file di atas di simpan dalam folder crud maka ketik di browser http://localhost/crud/barang_tampil.php atau dapat juga di download di sini.
Posted in: PHP
0 komentar:
Posting Komentar