Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- class Artikel_model extends CI_Model {
- function __construct() {
- parent::__construct();
- }
- public function show($table){
- $this->db->select('*');
- $data = $this->db->get($table);
- if($data->num_rows() > 0){
- return $data->result_array();
- }else{
- return false;
- }
- }
- function tampil_artikel($num, $offset){
- //$this->db->select(array( 'id', 'namalengkap', 'umur', 'alamat', "DATE_FORMAT(lastinput,'%d-%m-%Y') as tanggal" ), FALSE);
- $this->db->select('*');
- //$this->db->where('tampil', 1);
- $this->db->order_by('id_artikel', 'DESC');
- $this->db->limit($num, $offset);
- $query = $this->db->get('artikel');
- //$query = $this->db->get('pasien',$num, $offset);
- return $query->result();
- }
- public function show_by_id($table, $id_artikel){
- //$this->db->select('*');
- $data = $this->db->get_where($table, array('id_artikel'=>$id_artikel));
- if($data->num_rows() > 0){
- return $data->result_array();
- }else{
- return false;
- }
- }
- public function insert($data,$table){
- $this->db->insert($table, $data);
- }
- function update($data, $id_artikel){
- $this->db->where('id_rtikel', $id_artikel);
- $this->db->update('artikel', $data);
- }
- function delete($id_artikel){
- $this->db->where('id_artikel', $id_artikel);
- $this->db->delete('artikel');
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment