codeigniter_test2/application/models/barang_model.php

39 lines
1.0 KiB
PHP
Raw Permalink Normal View History

2020-01-02 23:07:40 +07:00
<?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');
}
}