.

%PDF- %GIF98; %PNG; . Cyber Programmer

Server : Apache
System : Linux sh00666.bluehost.com 5.14.0-687.26.1.el9_8.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Jul 14 16:32:02 EDT 2026 x86_64
User : ndkhermy ( 1200)
PHP Version : 8.5.12
Disable Function : NONE
Directory : /home1/ndkhermy/public_html/website_1ec2d7c2/apps/models/

Upload File :

Current File : /home1/ndkhermy/public_html/website_1ec2d7c2/apps/models/Blog_model.php

<?php 
defined('BASEPATH') OR exit('No direct script access allowed');

class  Blog_Model extends CI_Model {
	

public function getALLBlogCategories(){
         $this->db->select("*");
		$this->db->from('bh_blog_categories');		
		$this->db->order_by("id","asc");
		
		$query=$this->db->get();
		return $query->result_array();  
}

public function getALLBlogs(){
         $this->db->select("*");
		$this->db->from('bh_blogs');		
		$this->db->order_by("id","asc");
		
		$query=$this->db->get();
		return $query->result_array();  
}

public function getALLMonthBlogs(){
	  $sql = "SELECT DISTINCT YEAR(add_date) as year, MONTH(add_date) as month FROM bh_blogs order by add_date asc";
	   $query = $this->db->query($sql);
		
		
		return $query->result_array();  
}
public function getALLBlogsBySearch(){
	    $search_key =  $this->input->post('search_key');
         $this->db->select("*");
		$this->db->from('bh_blogs');		
			
		$this->db->like('title', $search_key);	
		$this->db->or_like('description', $search_key);	
		$this->db->order_by("id","asc");
		
		$query=$this->db->get();
		return $query->result_array();  
}


public function getALLBlogsByArchive($year,$month){
	   $month =  $this->commonmod_model->getMonthID($month);
        $this->db->select("*");
		$this->db->from('bh_blogs');		
			
		$this->db->like('add_date', date($year."-".$month), 'after');	
		$this->db->order_by("id","asc");
		
		$query=$this->db->get();
		return $query->result_array();  
}

public function getALLBlogsBycategoryId($category_id){
         $this->db->select("*");
		$this->db->from('bh_blogs');	 	
		$this->db->where("category_id",$category_id);
		$this->db->order_by("id","asc");
		
		$query=$this->db->get();
		return $query->result_array();  
}


public function GetBlogCategoryNameByID($id){
         $this->db->select("*");
		$this->db->from('bh_blog_categories');		
		$this->db->where("id",$id);
		$this->db->order_by("id","desc");
		
		$query=$this->db->get();
		$userData = $query->row_array(); 
        return $userData;
}


public function GetBlogByID($id){
         $this->db->select("*");
		$this->db->from('bh_blogs');		
		$this->db->where("id",$id);
		$this->db->order_by("id","desc");
		
		$query=$this->db->get();
		$userData = $query->result_array(); 
        return $userData;
}	

public function getALLBlogCategoryWithBlog(){
        $this->db->select("distinct(bh_blogs.category_id) as id,bh_blog_categories.category_name");
		$this->db->from('bh_blog_categories');		
		$this->db->join('bh_blogs','bh_blog_categories.id = bh_blogs.category_id','inner');		
			
		$this->db->group_by("bh_blogs.category_id");
		$this->db->order_by("bh_blogs.id","asc");
		
		$query=$this->db->get();
		return $query->result_array();  
} 




public function getALLBlogFeaturedCategory(){
        $this->db->select("bh_blog_categories.id as featured_category_id,bh_blog_categories.category_name");
		$this->db->from('bh_blog_categories');		
		$this->db->join('bh_blogs','bh_blog_categories.id = bh_blogs.category_id','left outer');		
		$this->db->where("bh_blog_categories.featured_status",'1');	
		$this->db->order_by("bh_blog_categories.id","asc");
		
		$query=$this->db->get();
		return $query->result_array();  
}

public function setHomePage($type,$blog_id=""){
	if($type=="unset"){
		$data2= array("set_home"=>'0');
		
		$this->db->update("bh_blogs",$data2);
	}else if($type=="set"){
		$updata= array("set_home"=>'1');
		
		$this->db->where("id",$blog_id);
		$this->db->update("bh_blogs",$updata);
	
	}
	
	


}
public function setBloghome(){
         $this->db->select("*");
		$this->db->from('bh_blogs');		
		$this->db->where("status",'1');
		$this->db->where("set_home",'1');
		$this->db->order_by("id","desc");
		
		$query=$this->db->get();
		$userData = $query->result_array(); 
        return $userData;
}	

}

VaKeR 2022