| Server IP : 103.234.187.230 / Your IP : 216.73.216.216 Web Server : Apache System : Linux lserver42043-ind.megavelocity.net 3.10.0-1160.108.1.el7.x86_64 #1 SMP Thu Jan 25 16:17:31 UTC 2024 x86_64 User : apache ( 48) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/adeetieadmin/application/modules/news/models/ |
Upload File : |
<?php
Class Posts_model extends CI_Model
{
public function categories()
{
return $this->db->select('id,category_name')->where('status',1)->get(TBL_CATEGORIES)->result_array();
}
public function insertpost($data)
{
$this->db->insert(TBL_POSTS, $data);
if($this->db->affected_rows())
{
return true;
}
else
{
return false;
}
}
public function updatepost($id,$data)
{
$this->db->where('id',$id);
$this->db->update(TBL_POSTS, $data);
if($this->db->affected_rows())
{
return true;
}
else
{
return false;
}
}
public function selectpost($id)
{
$this->db->select("*");
$this->db->from(TBL_POSTS);
$this->db->where('id', $id);
$this->db->where('status!=',2);
$query = $this->db->get();
return $query->result_array();
}
public function check_slug($slug)
{
return $this->db->select("page_slug")->where(array('status'=>1,'page_slug'=>$slug))->limit(1)->get(TBL_PAGES)->result_array();
}
}