<?php
//error_reporting(0); 
class index_model extends CI_Model{

    function __construct() {

        parent::__construct();

        $this->load->database();
		$this->load->helper('url');
    } 
	  function manageCategory() {		
		$result=$this->db->query("SELECT * FROM category  ");		
		return $result->result_array();
		}


		function freshnews($id) {		
		$result=$this->db->query("SELECT * FROM products  order by pro_id desc ");		
		return $result->result_array();
		} 

		function category($id) {		
		$result=$this->db->query("SELECT * FROM products where pro_catid='".$id."'  ");		
		return $result->result_array();
		} 


		function news($id) {		
		$result=$this->db->query("SELECT * FROM products where pro_id='".$id."'  ");		
		return $result->result_array();
		} 

		function products($id) {		
		$result=$this->db->query("SELECT * FROM products where pro_id='".$id."'  ");		
		return $result->result_array();
		} 


		function services($id) {		
		$result=$this->db->query("SELECT * FROM services where ser_id='".$id."'  ");		
		return $result->result_array();
		} 

		function editCategory($id) {		
		$result=$this->db->query("SELECT * FROM category where cat_id='".$id."'  ");		
		return $result->result_array();
		} 
 
	 function ContactUs() {		
		$result=$this->db->query("SELECT * FROM contactus  ");		
		return $result->result_array();
		}
		
		 
	 function managepage() {		
		$result=$this->db->query("SELECT * FROM page  ");		
		return $result->result_array();
		}  

		  
		 
	 function newcontactrequests() {		
		$result=$this->db->query("SELECT * FROM newcontactrequests  ");		
		return $result->result_array();
		}  

		
		function editGallery($id) {		
		$result=$this->db->query("SELECT * FROM gallery where gal_id='".$id."'  ");		
		return $result->result_array();
		} 

		
		function contactinfo($id) {		
		$result=$this->db->query("SELECT * FROM contactinfo where id='".$id."'  ");		
		return $result->result_array();
		} 
		
		function homepagedata($id) {		
		$result=$this->db->query("SELECT * FROM homepagedata where id='".$id."'  ");		
		return $result->result_array();
		} 

		
		
		function pages($id) {		
		$result=$this->db->query("SELECT * FROM aboutus where abt_id='".$id."'  ");		
		return $result->result_array();
		} 

		
		function editServices($id) {		
		$result=$this->db->query("SELECT * FROM services where ser_id='".$id."'  ");		
		return $result->result_array();
		} 

		
		
		function manageServices() {		
		$result=$this->db->query("SELECT * FROM services  ");		
		return $result->result_array();
		} 

		
		function editProducts($id) {		
		$result=$this->db->query("SELECT * FROM products where pro_id='".$id."'  ");		
		return $result->result_array();
		} 

		
		
		function manageProducts() {		
		$result=$this->db->query("SELECT * FROM products  ");		
		return $result->result_array();
		} 


		function manageUser() {		
		$result=$this->db->query("SELECT * FROM users  where `username`!='admin' ");		
		return $result->result_array();
		}  
		
		function editpage($id) {		
		$result=$this->db->query("SELECT * FROM page where pg_id='".$id."'  ");		
		return $result->result_array();
		} 
		
	 function manageGallery() {		
		$result=$this->db->query("SELECT * FROM gallery  ");		
		return $result->result_array();
		}  
 
		
		function editContacts($id) {		
		$result=$this->db->query("SELECT * FROM contacts where con_id='".$id."'  ");		
		return $result->result_array();
		} 



	 function manageSlider() {		
		$result=$this->db->query("SELECT * FROM slider  ");		
		return $result->result_array();
		}  
 
		
		function editSlider($id) {		
		$result=$this->db->query("SELECT * FROM slider where gal_id='".$id."'  ");		
		return $result->result_array();
		} 


			
	 function manageTour() {		
		$result=$this->db->query("SELECT * FROM tournew  ");		
		return $result->result_array();
		}  
 
		
		function editTour($id) {		
		$result=$this->db->query("SELECT * FROM tournew where t_id='".$id."'  ");		
		return $result->result_array();
		} 

		
 
		
		function editStory($id) {		
		$result=$this->db->query("SELECT * FROM story where st_id='".$id."'  ");		
		return $result->result_array();
		} 

		
		
		function viewacco($id) {		
		$result=$this->db->query("SELECT * FROM touraccom where traco_tournewid='".$id."'  ");		
		return $result->result_array();
		} 

		
	 function manageStory() {		
		$result=$this->db->query("SELECT * FROM story  ");		
		return $result->result_array();
		}  
		
	 function manageAmenities() {		
		$result=$this->db->query("SELECT * FROM amenities  ");		
		return $result->result_array();
		}  
 
		
		function editAmenities($id) {		
		$result=$this->db->query("SELECT * FROM amenities where gal_id='".$id."'  ");		
		return $result->result_array();
		} 


}
	   
?>