anjhar

artikel_model

Apr 29th, 2015
231
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.56 KB | None | 0 0
  1. <?php
  2. class Artikel_model extends CI_Model {
  3. function __construct() {
  4. parent::__construct();
  5. }
  6.  
  7. public function show($table){
  8. $this->db->select('*');
  9. $data = $this->db->get($table);
  10. if($data->num_rows() > 0){
  11. return $data->result_array();
  12. }else{
  13. return false;
  14. }
  15. }
  16.  
  17. function tampil_artikel($num, $offset){
  18. //$this->db->select(array( 'id', 'namalengkap', 'umur', 'alamat', "DATE_FORMAT(lastinput,'%d-%m-%Y') as tanggal" ), FALSE);
  19. $this->db->select('*');
  20. //$this->db->where('tampil', 1);
  21. $this->db->order_by('id_artikel', 'DESC');
  22. $this->db->limit($num, $offset);
  23. $query = $this->db->get('artikel');
  24. //$query = $this->db->get('pasien',$num, $offset);
  25. return $query->result();
  26. }
  27.  
  28. public function show_by_id($table, $id_artikel){
  29. //$this->db->select('*');
  30. $data = $this->db->get_where($table, array('id_artikel'=>$id_artikel));
  31. if($data->num_rows() > 0){
  32. return $data->result_array();
  33. }else{
  34. return false;
  35. }
  36. }
  37.  
  38. public function insert($data,$table){
  39. $this->db->insert($table, $data);
  40. }
  41.  
  42. function update($data, $id_artikel){
  43. $this->db->where('id_rtikel', $id_artikel);
  44. $this->db->update('artikel', $data);
  45. }
  46.  
  47. function delete($id_artikel){
  48. $this->db->where('id_artikel', $id_artikel);
  49. $this->db->delete('artikel');
  50. }
  51.  
  52. }
Advertisement
Add Comment
Please, Sign In to add comment