1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / ravikumarnew / application / models.20200114 /
Filename : Web_model.php
back
<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Web_model extends CI_Model
{
   public function get_speeches_for_home(){
	
		$result = $this->db->query("SELECT * FROM `poem_composition_speech` where status = 0 and type = 3 and image !='' ORDER BY id DESC LIMIT 2");
		return $result->result();
	}
	
	public function get_compositions_for_home(){
	
		$result = $this->db->query("SELECT * FROM `poem_composition_speech` where status = 0 and type = 2 and image !='' ORDER BY id DESC LIMIT 2");
		return $result->result();
	}
	
	public function get_video_for_home(){
	
		$result = $this->db->query("SELECT * FROM `video` where status = 0  ORDER BY id DESC LIMIT 1");
		return $result->row();
	}

	public function get_banners_for_home(){
	
		$result = $this->db->query("SELECT * FROM `banner_img` where status = 0  ORDER BY id DESC");
		return $result->result();
	}

	public function get_books_for_home(){
	
		$result = $this->db->query("SELECT * FROM `book` where status = 0  ORDER BY id DESC  LIMIT 6");
		return $result->result();
	}

	 public function latest_speech(){
	
		$result = $this->db->query("SELECT * FROM `poem_composition_speech` where status = 0 and type = 3 ORDER BY id DESC LIMIT 4");
		return $result->result();
	}
	
	 public function latest_composition(){
	
		$result = $this->db->query("SELECT * FROM `poem_composition_speech` where status = 0 and type = 2 ORDER BY id DESC LIMIT 3");
		return $result->result();
	}
	

	 public function latest_kavithai(){
	
		$result = $this->db->query("SELECT * FROM `poem_composition_speech` where status = 0 and type = 1 ORDER BY id DESC LIMIT 4");
		return $result->result();
	}

	

}