39 lines
1.0 KiB
PHP
39 lines
1.0 KiB
PHP
|
<?php
|
||
|
|
class barang_model extends CI_Model{
|
||
|
|
|
||
|
|
function get_barang_all()
|
||
|
|
{
|
||
|
|
$query=$this->db->query("SELECT * FROM barang ORDER BY id DESC");
|
||
|
|
return $query->result();
|
||
|
|
}
|
||
|
|
function update_barang($id)
|
||
|
|
{
|
||
|
|
$q="SELECT * FROM barang WHERE id='$id'";
|
||
|
|
$query=$this->db->query($q);
|
||
|
|
return $query->row();
|
||
|
|
}
|
||
|
|
function simpan_update_barang($id, $nama, $harga)
|
||
|
|
{
|
||
|
|
$data = array(
|
||
|
|
'id' => $id,
|
||
|
|
'nama' => $nama,
|
||
|
|
'harga' => $harga
|
||
|
|
);
|
||
|
|
$this->db->where('id', $id);
|
||
|
|
$this->db->update('barang', $data);
|
||
|
|
}
|
||
|
|
function delete_barang($id)
|
||
|
|
{
|
||
|
|
$query=$this->db->query("DELETE FROM barang WHERE id='$id'");
|
||
|
|
}
|
||
|
|
function simpan_barang()
|
||
|
|
{
|
||
|
|
$simpan_data=array(
|
||
|
|
'nama' => $this->input->post('nama_barang'),
|
||
|
|
'harga' => $this->input->post('harga'),
|
||
|
|
);
|
||
|
|
$simpan = $this->db->insert('barang', $simpan_data);
|
||
|
|
return $simpan;
|
||
|
|
redirect('barang_controller/barang','refresh');
|
||
|
|
}
|
||
|
|
}
|