Written By Firman Arifin on Sunday, July 1, 2012 | 7/01/2012 08:58:00 AM
Pada artikel kali ini, saya akan mengimplementasikan sedikit tentang penggunaan CRUD (Create, Read, Update, Delete) di bahasa pemograman php,
dengan tujuan mampu menguasai konsep dasar dari CRUD, pada studi kasus
kali ini saya mengangkat tema tentang "Sistem Informasi Barang",
terlebih dahulu sy membuat database, dengan nama database"dbcrud",
selanjutnya kita membuat tabel dengan nama tabel barang
kemudian kita buat file lainnya, dengan sourcecode sebagai berikut :
<?php
mysql_connect("localhost","root","") or die("Koneksi Gagal,!");
mysql_select_db("dbcrud") or die("Database tidak ditemukan,!");
?>
file
koneksi.php berfungsi sebagai perantara untuk mensingkronkan atau
mengoneksikan antara file host (dengan nama host+username+password
tertentu) dan database.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>.:Barang:.</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<!--[if lte IE 7]>
<style type="text/css">
#vc-main{height:100%;}
</style>
<![endif]-->
</head>
<?php include "config/koneksi.php"; ?>
<body>
<div id="container">
<div class="header">
<h1>Pemrograman Web Dinamis</h1>
<span>Cyberprotol Indonesia</span>
<ul>
<li><a href="?pil=barang">Home</a></li>
</ul>
</div>
<div class="batas"></div>
<div class="konten">
<p><?php include 'gateway.php'; ?></p>
</div>
<div class="clear"></div>
<div class="footer">
<span>
<small>Copyright © 2011 <a
href="http://cyberprotol.blogspot.com" title="Afriq">Cyberprotol
Indonesia</a> - Konsep CrUD</small>
</span>
</div>
</div>
</body>
</html>
File index.php akan ditampilkan pertama kali
/*
File <span style="color: #ff0000;"><strong>awal.php</strong></span>
*/
<?php
echo "Hello,Selamat datang...";
?>
File awal.php ini akan ditampilkan pertama kali pada konten.
/*
File <strong><span style="color: #ff0000;">gateway.php</span></strong>
*/
<link rel="stylesheet" type="text/css" href="tampilan.css">
<?php
include "config/koneksi.php";
switch($_REQUEST['pil']){
case'':
include 'awal.php';
break;
case 'depan':
include 'awal.php';
break;
case'ebarang':
include 'edit_barang.php';
break;
case'barang':
?>
<h2>Data Barang</h2>
<br>
<input type='button' class="tombol" value='Tambah Barang' onclick=location.href='?pil=inputbarang'>
<br><br>
<table class="table" border="0" cellpadding="2" cellspacing="0" >
<tr ><th class="th" width="25" align="center" valign="top">No</th>
<th class="th" width="120" align="center" valign="top">Kode Barang</th>
<th class="th" width="260" align="center" valign="top">Nama Barang</th>
<th class="th" width="80" align="center" valign="top">Aksi</th>
</tr>
<?PHP
$tampil=mysql_query("SELECT * FROM barang ORDER BY kode_barang ASC");
$no=1;
while ($w=mysql_fetch_array($tampil)){ ?>
<tr class="tr"> <td class="td" align="left" valign="top"><?PHP echo $no ?></td>
<td align="left" valign="top" nowrap class="td" style="padding-left:10px;"><?PHP echo $w[kode_barang] ?></td>
<td
class="td" align="left" valign="top"
style="padding-left:10px;"><a
href="?pil=detailbarang&id=<?PHP echo $w[id_barang];
?>"><?PHP echo $w[nama_barang] ?></a></td>
<td
class="td" align="center" valign="top"><a
href="?pil=ebarang&kode_barang=<?PHP echo $w[kode_barang];
?>"> <img src="images/edit.png" title="Edit" /></a>
|<a href="?pil=hapusbarang&kodebarang=<?PHP echo
$w[kode_barang]; ?>" onclick="return confirm('Apakah anda yakin akan
menghapus Barang bernama <?PHP echo $w[nama_barang]; ?>?')">
<img src="images/delete.png" title="Hapus" />
</a></td>
</tr>
<?PHP $no++; } ?>
</table>
<?php
break;
case'detailbarang' :
$sql=mysql_query("SELECT * FROM barang where id_barang='$_GET[id]'");
$r=mysql_fetch_array($sql);
?>
<h2>Detail Data Barang</h2>
<br>
<table width="44%" border="0" cellspacing="0" cellpadding="0">
<tr >
<td align="center" valign="top"><table class="table" border="0" cellspacing="0" cellpadding="2">
<tr class="tr" >
<td colspan="3" nowrap class="th" align="center"><strong>Data Barang</strong></td>
</tr>
<tr class="tr" >
<td
width="25%" valign="top" style="padding-left:10px; padding-right:10px;"
nowrap class="td"><font style="font-size:12px;">Kode
Barang</font></td>
<td valign="top" >:</td>
<td
width="75%" valign="top" nowrap class="td" style="padding-left:10px;
padding-right:10px;" ><font style="font-size:12px;"><?PHP
echo $r[kode_barang]; ?></font></td>
</tr>
<tr class="tr" >
<td
valign="top" style="padding-left:10px; padding-right:10px;" nowrap
class="td"><font style="font-size:12px;">Nama
Barang</font></td>
<td valign="top">:</td>
<td
valign="top" nowrap class="td" style="padding-left:10px;
padding-right:10px;"><font style="font-size:12px;"><?PHP
echo $r[nama_barang]; ?></font></td>
</tr>
<tr class="tr" >
<td
valign="top" style="padding-left:10px; padding-right:10px;" nowrap
class="td"><font
style="font-size:12px;">Jumlah</font></td>
<td valign="top">:</td>
<td
valign="top" nowrap class="td" style="padding-left:10px;
padding-right:10px;"><font style="font-size:12px;"><?PHP
echo $r[jumlah]; ?></font></td>
</tr>
<tr class="tr" >
<td
valign="top" style="padding-left:10px; padding-right:10px;" nowrap
class="td"><font
style="font-size:12px;">Harga</font></td>
<td valign="top">:</td>
<td
valign="top" nowrap class="td" style="padding-left:10px;
padding-right:10px;"><font style="font-size:12px;"><?PHP
echo $r[harga]; ?></font></td>
</tr>
<tr class="tr" >
<td nowrap class="td style1" style="padding-left:10px; padding-right:10px;">Kategori</td>
<td >:</td>
<td
nowrap class="td" style="padding-left:10px; padding-right:10px;"
><font style="font-size:12px;"><?PHP echo $r[kategori];
?></font></td>
</tr>
</table></td>
</tr>
</table>
<?PHP
;
break;
//FORM PENGISIAN DATA BARANG
case'inputbarang' : ?>
<h2>Input Data Barang</h2>
<br>
<form action="?pil=tmbhbarang" method="post" enctype="multipart/form-data" name="form1" id="form1">
<table class='table' border="0" cellspacing="0" cellpadding="3">
<tr>
<td valign="top" nowrap="nowrap">Kode Barang</td>
<td >:</td>
<td ><input name="kode_barang" type="text" id="kode_barang" size="19" /></td>
</tr>
<tr>
<td valign="top" nowrap="nowrap">Nama Barang</td>
<td>:</td>
<td><input name="nama_barang" type="text" id="nama_barang" size="19" /></td>
</tr>
<tr>
<td valign="top" nowrap="nowrap">Jumlah</td>
<td>:</td>
<td><input name="jumlah" type="text" id="jumlah" size="19" /></td>
</tr>
<tr>
<td valign="top" nowrap="nowrap">Harga</td>
<td>:</td>
<td><input name="harga" type="text" id="harga" size="19" /></td>
</tr>
<tr>
<td valign="top" nowrap="nowrap">Kategori</td>
<td>:</td>
<td><select name="kategori" id="kategori">
<option value="Elektronik" selected="selected">Elektronik</option>
<option value="Perabot">Perabot</option>
<option value="Makanan">Makanan</option>
<option value="Minuman">Minuman</option>
<option value="Pakaian">Pakaian</option>
</select>
</td>
</tr>
<tr>
<td valign="top"> </td>
<td> </td>
<td><input type="submit" name="Submit" class="tombol" value="Tambah" />
<input type="reset" name="Submit2" class="tombol" value="Ulangi" />
<input type="button" name="Submit3" class="tombol" onclick="self.history.back(-1);" value="Kembali" /></td>
</tr>
<tr>
<td valign="top" nowrap="nowrap"> </td>
<td> </td>
<td> </td>
</tr>
</table>
</form> <?PHP ;
break;
//TAMBAH DATA BARANG
case'tmbhbarang':
$sql=mysql_query("INSERT
INTO `barang` (`kode_barang`, `nama_barang` , `jumlah` , `harga` ,
`kategori` ) VALUES ('$_POST[kode_barang]', '$_POST[nama_barang]',
'$_POST[jumlah]', '$_POST[harga]', '$_POST[kategori]')");
if($sql){
echo "Anda berhasil menambah data";
echo"<meta http-equiv=\"refresh;\" content=\"2;?pil=depan;\" />";
}else{
echo"Data belum masuk";}
;break;
//MENGUPDATE BARANG
case'updatebarang':
$sql=mysql_query("UPDATE `barang` SET
`kode_barang` = '$_POST[kode_barang]',
`nama_barang` = '$_POST[nama_barang]',
`jumlah` = '$_POST[jumlah]',
`harga` = '$_POST[harga]',
`kategori` = '$_POST[kategori]'
where kode_barang='$_POST[kodebarang]'");
if($sql){
echo'Sukses Mengupdate data.'."<meta http-equiv=\"refresh;\" content=\"2;?pil=m_barang;\" />";
}else{
echo'Gagal Mengupdate data'."<meta http-equiv=\"refresh\" content=\"2;?pil=m_barang;\" />";
};
break;
//MENGHAPUS BARANG
case'hapusbarang':
$hapus=mysql_query("DELETE FROM `barang` WHERE `barang`.`kode_barang`='$_GET[kodebarang]'");
if($hapus){echo"Data berhasil dihapus";}
;break;
}//end switch
?>
File
gateway.php akan ditampilkan di konten. Di dalamnya ada kondisi switch
yang mana pemanggilannya tergantung kita waktu memilihnya, misal kita
mau menghapus data, maka case’hapusbarang’ yang akan dipilih. Jadi,
hanya konten saja yang berubah tampilannya, header dan footer tidak.
Bisa kita lihat bahwa di file gateway.php terdapat
case’edit_barang,detailbarang,tambahbarang,updatebarang,hapusbarang,dan
lainnya’.
/*
File <span style="color: #ff0000;"><strong>detail_barang.php</strong></span>
*/
<?PHP $sql=mysql_query("SELECT * FROM barang where id_barang='$_GET[id]'");
$r=mysql_fetch_array($sql);
;?>
<table class="table" width="1%" border="0" cellspacing="0" cellpadding="0">
<tr class"tr">
<td class"td" width="80%" align="left" valign="top"><table width="1%" border="0" cellspacing="0" cellpadding="0">
<tr class"tr">
<td class"td" width="25%" style="padding-left:10px;" nowrap>Kode Barang</td>
<td class"td" width="1%">:</td>
<td class"td" width="75%"><?PHP echo $r[kode_barang]; ?></td>
</tr>
<tr class"tr">
<td class"td" nowrap>Nama Barang</td>
<td class"td">:</td>
<td class"td"><?PHP echo $r[nama_barang]; ?></td>
</tr>
<tr class"tr">
<td class"td" nowrap>Jumlah</td>
<td class"td">:</td>
<td class"td"><?PHP echo $r[jumlah]; ?></td>
</tr>
<tr class"tr">
<td class"td" nowrap>Harga</td>
<td class"td">:</td>
<td class"td"><?PHP echo $r[harga]; ?></td>
</tr>
<tr class"tr">
<td class"td" nowrap>Kategori</td>
<td class"td">:</td>
<td class"td"><?PHP echo $r[kategori]; ?></td>
</tr>
</table></td>
</tr>
</table>
<?PHP
?>
File detail_barang.php ini akan menampilkan detail barang.
/*
File <strong><span style="color:
#ff0000;">edit_barang.php</span></strong> */ <link
rel="stylesheet" type="text/css" href="tampilan.css" /> <form
action="?pil=updatebarang" method="post" enctype="multipart/form-data"
name="form_edit_post" id="form_edit_post"> <?PHP
$sql=mysql_query("SELECT * FROM barang where
kode_barang='$_GET[kode_barang]'"); $r=mysql_fetch_array($sql); ?>
<input name="kodebarang" type="hidden" id="kodebarang"
value="<?PHP echo $_GET[kode_barang]; ?>"/> <br>
<br> <table width="42%" border="0" cellspacing="0"
cellpadding="0"> <tr class"tr"> <td width="17%" valign="top"
> Kode Barang </td> <td width="1%" valign="top"
class"td">:</td> <td width="82%" valign="top" > <input
name="kode_barang" type="text" id="kode_barang" value="<?PHP echo
$r[kode_barang]; ?>" size="19"> </td> </tr> <tr
class"tr"> <td valign="top"" nowrap class"td>Nama
Barang</td> <td valign="top" class"td">:</td> <td
valign="top" class"td"><input name="nama_barang" type="text"
id="nama_barang" value="<?PHP echo $r[nama_barang]; ?>"
size="19"></td> </tr> </tr> <tr class"tr">
<td valign="top"" nowrap class"td>Jumlah</td> <td
valign="top" class"td">:</td> <td valign="top"
class"td"><input name="jumlah" type="text" id="jumlah"
value="<?PHP echo $r[jumlah]; ?>" size="19"></td>
</tr> <tr class"tr"> <td valign="top"" nowrap
class"td>Harga</td> <td valign="top"
class"td">:</td> <td valign="top" class"td"><input
name="harga" type="text" id="harga" value="<?PHP echo $r[harga];
?>" size="19"></td> </tr> <tr class"tr"> <td
valign="top"" nowrap class"td>Kategori</td> <td valign="top"
class"td">:</td> <td valign="top"
class"td"><label> <select name="kategori" id="kategori">
<?PHP if ($r[kategori]=='Elektronik') { ?> <option
value="Elektronik" selected="selected">Elektronik</option>
<?PHP } else{?>
<option value="Elektronik">Elektronik</option> <?PHP }
if ($r[kategori]=='Perabot') {?> <option value="Perabot"
selected="selected">Perabot</option> <?PHP } else{?>
<option value="Perabot" >Perabot</option> <?PHP } if
($r[kategori]=='Makanan') { ?> <option value="Makanan"
selected="selected">Makanan</option> <?PHP } else {?>
<option value="Makanan" >Makanan</option> <?PHP } if
($r[kategori]=='Minuman') { ?> <option value="Minuman"
selected="selected">Minuman</option> <?PHP } else {?>
<option value="Minuman">Minuman</option> <?PHP } if
($r[kategori]=='Pakaian') { ?> <option value="Pakaian"
selected="selected">Pakaian</option> <?PHP } else { ?>
<option value="Pakaian">Pakaian</option> <?PHP } ?>
</select> </label></td> </tr> <tr
class="class""tr"> <td valign="top"" nowrap
class="class""td> </td> <td valign="top"
class="class""td"> </td> <td valign="top"
class="class""td"><label> <input name="ubah" type="submit"
class="tombol" id="ubah" value="Ubah" /> </label> <label>
<input type="reset" name="Submit2" class="tombol" value="Ulangi"
/> </label></td> </tr> <tr class"tr">
<td valign="top"" nowrap class"td> </td> <td
valign="top" class"td"> </td> <td valign="top"
class"td"> </td> </tr> </table> <br>
</form>
File
<strong><span style="color:
#ff0000;">edit_barang.php</span></strong> */ <link
rel="stylesheet" type="text/css" href="tampilan.css" /> <form
action="?pil=updatebarang" method="post" enctype="multipart/form-data"
name="form_edit_post" id="form_edit_post"> <?PHP
$sql=mysql_query("SELECT * FROM barang where
kode_barang='$_GET[kode_barang]'"); $r=mysql_fetch_array($sql); ?>
<input name="kodebarang" type="hidden" id="kodebarang"
value="<?PHP echo $_GET[kode_barang]; ?>"/> <br>
<br> <table width="42%" border="0" cellspacing="0"
cellpadding="0"> <tr class"tr"> <td width="17%" valign="top"
> Kode Barang </td> <td width="1%" valign="top"
class"td">:</td> <td width="82%" valign="top" > <input
name="kode_barang" type="text" id="kode_barang" value="<?PHP echo
$r[kode_barang]; ?>" size="19"> </td> </tr> <tr
class"tr"> <td valign="top"" nowrap class"td>Nama
Barang</td> <td valign="top" class"td">:</td> <td
valign="top" class"td"><input name="nama_barang" type="text"
id="nama_barang" value="<?PHP echo $r[nama_barang]; ?>"
size="19"></td> </tr> </tr> <tr class"tr">
<td valign="top"" nowrap class"td>Jumlah</td> <td
valign="top" class"td">:</td> <td valign="top"
class"td"><input name="jumlah" type="text" id="jumlah"
value="<?PHP echo $r[jumlah]; ?>" size="19"></td>
</tr> <tr class"tr"> <td valign="top"" nowrap
class"td>Harga</td> <td valign="top"
class"td">:</td> <td valign="top" class"td"><input
name="harga" type="text" id="harga" value="<?PHP echo $r[harga];
?>" size="19"></td> </tr> <tr class"tr"> <td
valign="top"" nowrap class"td>Kategori</td> <td valign="top"
class"td">:</td> <td valign="top"
class"td"><label> <select name="kategori" id="kategori">
<?PHP if ($r[kategori]=='Elektronik') { ?> <option
value="Elektronik" selected="selected">Elektronik</option>
<?PHP } else{?>
<option value="Elektronik">Elektronik</option> <?PHP }
if ($r[kategori]=='Perabot') {?> <option value="Perabot"
selected="selected">Perabot</option> <?PHP } else{?>
<option value="Perabot" >Perabot</option> <?PHP } if
($r[kategori]=='Makanan') { ?> <option value="Makanan"
selected="selected">Makanan</option> <?PHP } else {?>
<option value="Makanan" >Makanan</option> <?PHP } if
($r[kategori]=='Minuman') { ?> <option value="Minuman"
selected="selected">Minuman</option> <?PHP } else {?>
<option value="Minuman">Minuman</option> <?PHP } if
($r[kategori]=='Pakaian') { ?> <option value="Pakaian"
selected="selected">Pakaian</option> <?PHP } else { ?>
<option value="Pakaian">Pakaian</option> <?PHP } ?>
</select> </label></td> </tr> <tr
class="class""tr"> <td valign="top"" nowrap
class="class""td> </td> <td valign="top"
class="class""td"> </td> <td valign="top"
class="class""td"><label> <input name="ubah" type="submit"
class="tombol" id="ubah" value="Ubah" /> </label> <label>
<input type="reset" name="Submit2" class="tombol" value="Ulangi"
/> </label></td> </tr> <tr class"tr">
<td valign="top"" nowrap class"td> </td> <td
valign="top" class"td"> </td> <td valign="top"
class"td"> </td> </tr> </table> <br>
</form>
File edit_barang.php ini akan mengupdate data barang yang ada di database.
/*
File <span style="color: #ff0000;"><strong>style.css</strong></span>
*/
@charset "utf-8";
/* CSS Document */
@charset "utf-8";
/* CSS Document */
*{
padding:0;
margin:0;
}
html, body{
background:#F2EBB3;
margin:0;
padding:0;
height:100%;
font-family:Georgia, "Times New Roman", Times, serif;
}
i{
text-decoration:none;
font-size:8;
margin-top:10px;
}
a{
text-decoration:none;
color:#000000;
}
a:hover{
text-decoration:underline;
/*color:#FFCC66;*/
color:#0066FF;
}
#container{
min-height:100%;
position:relative;
}
.header{
background:#713800;
width:100%;
height:150px;
}
.header h1{
padding: 10px 0 0 30px;
}
.header ul{
padding:50px 0 10px 45px;
/**/list-style:none;
}
ul a{
text-decoration:none;
color:#FFFFFF;
}
ul a:hover{
text-decoration:none;
border-bottom:solid #000000 2px;
color:#000000;
}
span{
color:#CC9933;
padding:32px;
}
.batas{
margin:25px;
}
.konten {
border:solid #FFBE7D 1px;
border-radius: 8px;
padding: 5px 10px 10px 25px;
margin:auto auto;
width:700px;
min-height:150px;
}
.konten p{
margin:auto auto;
padding-right:20px;
width:100%;
height:100%;
}
.clear{
clear:both;
/*margin-top:20px;*/
}
.footer{
margin-top:20px;
background:#713800;
height:100%;
position:fixed;
width:100%;
}
.footer span, small{
padding-top:5px;
float:right;
}
File style.css untuk mengatur tampilan halaman web secara keseluruha
/*
File <span style="color: #ff0000;"><strong>tampilan.css</strong></span>
/*
@charset "utf-8";
/* CSS Document */
h2{
font-size:19px;
border-bottom:1px dashed #000000;
}
.tombol{
padding:5px;
}
.table {
font-family: Tahoma;
font-size: 10pt;
border: solid 1px #999999;
background-color:#F2EBB3;
border-collapse: collapse;
}
.th{
color: #000000;
font-size: 9pt;
border: solid 1px #CC6600;
border-collapse: collapse;
background-color: #FFD2A6;
padding:3px;
}
.td{
vertical-align: top;
border: solid 1px #999999;
border-collapse: collapse;
}
.tr{
vcolor: #000000;
font-size: 9pt;
border: solid 1px #CC6600;
border-collapse: collapse;
background-color: #F2EBB3;
padding:3px;
}
File tampilan.css untuk mengatur tampilan tabelnya saja. Sekian untuk artikel kali ini, terima kasih telah berkunjung
Tidak ada komentar:
Posting Komentar