1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / ravikumarnew / application / models /
Filename : Ab_administration_model.php
back
<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Ab_administration_model extends CI_Model
{
   public function get_poem_composition_speech_datas($type, $start, $length, $search){
	
		$result = $this->db->query("SELECT * FROM `poem_composition_speech` WHERE title like '%$search%' and type ='$type' and status in(0,2) limit $start,$length");
		return $result->result();
	}

	public function get_poem_composition_speech_datas_count($type){
		
			$result = $this->db->query("SELECT * FROM `poem_composition_speech` WHERE type='$type' and status in(0,2)");
		
		return $result->result();
	}

	public function get_video($search, $start, $length) {

        $result = $this->db->query("SELECT * FROM `video` WHERE  title LIKE '%$search%'  and
        status in(0,2)  limit $start,$length");
        return $result->result();
    }

    public function get_panigal_datas($subcategory_id, $start, $length, $search){
	
		$result = $this->db->query("SELECT * FROM `panigal` WHERE title like '%$search%' and sub_category_id ='$subcategory_id' and status in(0,2) limit $start,$length");
		return $result->result();
	}

	public function get_panigal_datas_count($subcategory_id){
		
			$result = $this->db->query("SELECT * FROM `panigal` WHERE sub_category_id ='$subcategory_id' and status in(0,2)");
		
		return $result->result();
	}

	public function get_banner($search, $start, $length) {
        $result = $this->db->query("SELECT * FROM `banner_img` WHERE  banner_image	LIKE '%$search%' and
        status in(0,2)  limit $start,$length");
        return $result->result();
    }

    public function get_book($search, $start, $length) {
    	
        $result = $this->db->query("SELECT * FROM `book` WHERE  title	 LIKE '%$search%'  and
        status in(0,2)  limit $start,$length");
        return $result->result();
    }

    public function get_banners_count(){
		
			$result = $this->db->query("SELECT * FROM `banner_img` WHERE  status in(0,2)");
		
		return $result->result();
	}
	

	public function get_videos_count(){
		
			$result = $this->db->query("SELECT * FROM `video` WHERE  status in(0,2)");
		
		return $result->result();
	}

	
	public function get_books_count(){
		
			$result = $this->db->query("SELECT * FROM `book` WHERE  status in(0,2)");
		
		return $result->result();
	}

}