<?php
class Mbarang extends CI_Model {
var $tabel = 'tb_barang'; //variabel nama tabel
function __construct() {
parent::__construct();
}
function getallbarang() { //query semua data di tabel barang
$this->db->from($this->tabel);
$this->db->order_by('kode_brg','DESC');
$query = $this->db->get();
//cek apakah ada barang
if ($query->num_rows() > 0) {
return $query->result();
}
}
function getbarangbyid($id) { //query berdasarkan id barang tabel barang
$this->db->from($this->tabel);
$this->db->where('kode_brg', $id);
$query = $this->db->get();
if ($query->num_rows() == 1) {
return $query->row();
}
}
function getinsert($data){ //query insert data
$this->db->insert($this->tabel, $data);
return TRUE;
}
function getupdate($id,$data) { //query update data
$this->db->where('kode_brg', $id);
$this->db->update($this->tabel, $data);
return TRUE;
}
function delbarang($id) { //query hapus data
$this->db->where('kode_brg', $id);
$this->db->delete($this->tabel);
if ($this->db->affected_rows() == 1) {
return TRUE;
}
return FALSE;
}
}
?>
selanjutnya kita akan membuat views pada tampilannya kita akan membuat 3 halaman baru yaitu halaman barang vbarang.php, halaman form vformbarang.php dan halaman detail vdetailbarang.php agar lebih rapi saya buat dalam satu folder ./barang/ dan posisi nya di folder ./application/views/barang/ otomatis kita harus sesuaikan pemanggilan views di controller nya dengan menambahkan folder barang/_nama_views setiap memanggil views nya, bisa dilihat pada controllernya.
vbarang.php
<section>
<div class="container">
<h1>Data Barang</h1>
<a href="<?php echo base_url();?>barang/tambah" class="button">Tambah</a>
<div class="pesan-sukses"><?php echo $this->session->flashdata("pesan");?></div>
<table class="table">
<tr>
<th>No</th>
<th>Kode</th>
<th>Barcode</th>
<th>Nama Barang</th>
<th>Harga </th>
<th>Jenis </th>
<th>Satuan </th>
<th>Stok </th>
<th>Keterangan </th>
<th></th>
</tr>
<?php if(!$querybarang){?>
<tr><td colspan="9">Data Masih Kosong</td> </tr>
<?php }else{
$no =0;
foreach ($querybarang as $rstbrg) {$no++;
?>
<tr>
<td><?php echo $no;?></td>
<td>#<?php echo $rstbrg->kode_brg;?></td>
<td><?php echo $rstbrg->barcode;?></td>
<td><?php echo $rstbrg->nama_brg;?></td>
<td><?php echo $rstbrg->harga_brg;?></td>
<td><?php echo $rstbrg->jenis;?></td>
<td><?php echo $rstbrg->satuan;?></td>
<td><?php echo $rstbrg->stok_brg;?></td>
<td><?php echo $rstbrg->keterangan;?></td>
<td><a href="<?php echo base_url()?>barang/edit/?id=<? echo $rstbrg->kode_brg;?>">Edit</a>
<a href="<?php echo base_url()?>barang/detail/?id=<? echo $rstbrg->kode_brg;?>">Detail</a>
<a onclick="return KonfirmasiHapus()" href="<?php echo base_url()?>barang/hapus/?id=<? echo $rstbrg->kode_brg;?>">Hapus</a>
</td>
</tr>
<?php }}?>
</table>
</div>
</section>
<script type="text/javascript">
function KonfirmasiHapus() {
return confirm("Apa anda yakin akan menghapus data ini?");
}
</script>
vformbarang.php<?php
if($aksi=='aksi_tambah'){
$kode = "";
$bkode = @$abkode;
$nama = @$anama;
$harga = @$aharga;
$stok = @$astok;
$jenis = @$ajenis;
$satuan = @$asatuan;
$keterangan = @$aket;
}elseif($aksi=='aksi_edit'){
$kode = $row->kode_brg;
$bkode = $row->barcode;
$nama = $row->nama_brg;
$harga = $row->harga_brg;
$stok = $row->stok_brg;
$jenis = $row->jenis;
$satuan = $row->satuan;
$keterangan = $row->keterangan;
}
?>
<section>
<div class="container">
<h1>Form Barang</h1>
<div class="form">
<div class="pesan-error"><?php echo $this->session->flashdata("pesan");?></div>
<form method="post" action="<?php echo base_url()?>barang/<?php echo $aksi;?>">
<label>Barcode Barang</label>
<input type="text" name="barcode" class="w4" value="<?php echo $bkode;?>">
<label>Nama Barang</label>
<input type="text" name="nama" value="<?php echo $nama;?>">
<label>Harga Barang</label>
<input type="text" name="harga" class="w3" value="<?php echo $harga;?>">
<label>Stok Barang</label>
<input type="text" name="stok" class="w3" value="<?php echo $stok;?>">
<label>Jenis</label>
<input type="text" name="jenis" class="w3" value="<?php echo $jenis;?>">
<label>Satuan</label>
<input type="text" name="satuan" class="w2" value="<?php echo $satuan;?>">
<label>Keterangan</label>
<textarea name="keterangan"><?php echo $keterangan;?></textarea>
<input type="submit" class="button" name="simpan" value="Simpan">
<a href="<?php echo base_url();?>barang" class="button2">Kembali</a>
<input type="hidden" name="kode" value="<?php echo $kode;?>">
</form>
</div>
</div>
</section>
vdetailbarang.php
<section> <div class="container"> <h1>Detail Barang</h1> <table> <tr> <td>Kode Barang</td> <td>:</td> <td>#<?php echo $rowbarang->kode_brg;?> </tr> <tr> <td>Barcode Barang</td> <td>:</td> <td><?php echo $rowbarang->barcode;?> </tr> <tr> <td>Nama Barang</td> <td>:</td> <td><?php echo $rowbarang->nama_brg;?> </tr> <tr> <td>Stok</td> <td>:</td> <td><?php echo $rowbarang->stok_brg;?> </tr> <tr> <td>Jenis</td> <td>:</td> <td><?php echo $rowbarang->jenis;?> </tr> <tr> <td>Satuan</td> <td>:</td> <td><?php echo $rowbarang->satuan;?> </tr> <tr> <td>Keterangan</td> <td>:</td> <td><?php echo $rowbarang->keterangan;?> </tr> </table> <a href="<?php echo base_url()?>barang">Kembali</a> </div> </section>
style.css
untuk css tampilannya di edit saya buka file style.css pada folder ./assets/ dan buat seperti dibawah ini
body{
color: #333;
font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;
font-size:16px;
}
header{
background: #111;
padding: 20px;
}
header h3{
float: left;
color: #FFF;
}
header nav{
float: right;
margin-top: 10px;
}
header nav ul{
padding: 0;
margin: 0;
}
header nav ul li{
float: left;
list-style: none;
}
header nav ul li a{
padding: 15px;color: #fff;text-decoration: none;}
header nav ul li a:hover{color: yellow;}
footer{ background: #111;padding: 20px;color: #fff;}
footer a{color: #fff;text-decoration: none;}
footer a:hover{ color: yellow;}
section{padding: 20px;min-height: 300px;}
.clear{ clear: both;}
.container{margin: 0px auto;width: 1100px;}
.table {border-collapse: collapse; width: 100%;}
.table td, .table th {border: 1px solid #ddd;padding: 8px; font-size: 14px;}
.table tr:nth-child(even){background-color: #f2f2f2;}
.table tr:hover {background-color: #ddd;}
.table th { padding-top: 12px;padding-bottom: 12px;text-align: left;background-color: #4CAF50;color: white;}
.button {background-color: #F00;/* Green */border: none;color: white;padding: 10px 20px;
text-align: center;text-decoration: none;display: inline-block;font-size: 16px;
border-radius: 4px;
}
.button:hover{background-color: #FE0; color: #444;}
.button2{
padding: 12px; text-align: center;background-color: #CCC;
color: #666; text-decoration: none;
display: inline-block;
border-radius: 4px;
}
input[type=text], select ,textarea{
width: 100%;
padding: 12px 10px;
margin: 8px 0;
display: inline-block;
border: 1px solid #ccc;
border-radius: 4px;
box-sizing: border-box;
}
input[type=submit] {
background-color: #4CAF50;
color: white;
padding: 14px 20px;
margin: 8px 0;
border: none;
border-radius: 4px;
cursor: pointer;
}
input[type=submit]:hover {
background-color: #45a049;
}
label{width: 100%!important; display: inline-block;}
.form {
width: 50%;
border-radius: 5px;
background-color: #f2f2f2;
padding: 20px;
}
.w1{
width: 100%!important;
}
.w2{width: 50%!important;}
.w3{width: 33.33%!important;}
.w4{width: 25%!important;}
.w5{width: 12.5%!important;}
.w1:after,.w2:after,.w3:after,.w4:after,{clear: both!important;}
input[type=text]:after{clear: both;}
.pesan-error{color:#F00; padding: 10px; font-style: italic;}
.pesan-sukses{padding: 10px; color: #48C50A;font-style: italic;}
sampai disini kita sudah selesai membangun sebuah crud codeigniter mari kita lihat hasil nya
gambar tampilan ketika aplikasi diakses
Tampilan form ketika di klik tambah
Validasi muncul ketika kita klik simpan padahal form belum di isi
Tampilan data berhasil di tambah
Oke demikian tutorial mengenai crud codeigniter ini silakan dicoba berulang2 sampai mengerti dan jika terjadi error atau kesulitan bisa buat komentar.
Untuk demo dan source code nya bisa dilihat pada link dibawah ini
DEMO | Download
0 comments: