Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- class m_barang extends CI_Model{
- function tampil_data(){
- //Menggunakan data Relasi 2 Tabel
- $query = "SELECT b.barang_id,b.nama_barang,b.harga,kb.nama_kategori "
- . "FROM barang as b,kategori_barang as kb "
- . "WHERE b.kategori_id=kb.kategori_id";
- return $this->db->query($query);
- }
- function post($data){
- //menginpukan data ke DB
- //membawa parameter yg memuat nilai
- //yg di dekarasikan pd controller
- $this->db->insert('barang',$data);
- }
- function get_one($id){
- //memintai nilai yg akan di edit
- $param = array('barang_id' => $id);
- return $this->db->get_where('barang',$param);
- }
- function edit($data,$id){
- $this->db->where('barang_id',$id);
- $this->db->update('barang',$data);
- }
- //menghapu data
- function hapus($id){
- $this->db->where('barang_id',$id);
- //nama tabel
- $this->db->delete('barang');
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement