Advertisement
sigitsuryono25

Untitled

Jun 13th, 2020
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.18 KB | None | 0 0
  1. function updateData($table, $data, $where){
  2. $this->db->where($where);
  3. $this->db->update($table, $data);
  4.  
  5. return $this->db->affected_rows();
  6. }
  7.  
  8. function getPostById($idArticle){
  9. return $this->db->query("SELECT * FROM tb_post WHERE id IN ('$idArticle')");
  10. }
  11.  
  12. function getDetailArticle($slugTitle) {
  13. return $this->db->query("SELECT *, tb_post.id as id_post FROM tb_post LEFT JOIN tb_kategori_source ON category=tb_kategori_source.id WHERE slug_title IN ('$slugTitle')");
  14. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement