codeigniter_test/application/models/M_post.php

34 lines
859 B
PHP
Raw Permalink Normal View History

2020-01-02 22:49:45 +07:00
<?php
class M_post extends CI_Model{
function get_post_all($perPage,$uri)
{
//$query=$this->db->query("SELECT * FROM post ORDER BY id DESC");
//return $query->result();
$this->db->select('*');
$this->db->from('post');
$this->db->order_by('id','DESC');
$getData = $this->db->get('', $perPage, $uri);
if($getData->num_rows() > 0)
{return $getData->result_array();}
else{return null;}
}
function edit_post($id)
{
$q="SELECT * FROM post WHERE id='$id'";
$query=$this->db->query($q);
return $query->row();
}
function save_edit_post($id, $judul, $isi)
{
$data = array(
'id' => $id,
'post_title' => $judul,
'post_content' => $isi
);
$this->db->where('id', $id);
$this->db->update('post', $data);
}
}