<?php

//error_reporting(0); 

class index_model extends CI_Model{



    function __construct() {



        parent::__construct();



        $this->load->database();

		$this->load->helper('url');

    } 



		function ViewComments($id) {		

		$result=$this->db->query("SELECT * FROM commentpost where newsid='".$id."'  ");		

		return $result->result_array();

		} 




    		  function manageform() {		

		$result=$this->db->query("SELECT * FROM form where typ='".$_GET['typ']."'  ");		

		return $result->result_array();

		}

		

		function editform($id) {		

		$result=$this->db->query("SELECT * FROM form where id='".$id."'  ");		

		return $result->result_array();

		} 




    		  function manageVideo() {		

		$result=$this->db->query("SELECT * FROM video  ");		

		return $result->result_array();

		}



		

		function editVideo($id) {		

		$result=$this->db->query("SELECT * FROM video where gal_id='".$id."'  ");		

		return $result->result_array();

		} 

		

	  function managesubCategory() {		

		$result=$this->db->query("SELECT * FROM subcategory  ");		

		return $result->result_array();

		}



		

		function editsubCategory($id) {		

		$result=$this->db->query("SELECT * FROM subcategory where subcat_id='".$id."'  ");		

		return $result->result_array();

		} 

		

		function editPages($id) {		

		$result=$this->db->query("SELECT * FROM aboutus where abt_id='".$id."'  ");		

		return $result->result_array();

		} 

  function managePages() {		

		$result=$this->db->query("SELECT * FROM aboutus  ");		

		return $result->result_array();

		}



  function manageCategory() {		

		$result=$this->db->query("SELECT * FROM category  ");		

		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 share_something() {		

		$result=$this->db->query("SELECT * FROM share_something");		

		return $result->result_array();

	} 



		  

		 

	 function subscribers() {		

		$result=$this->db->query("SELECT * FROM subscriber  ");		

		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 aboutus($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 where pro_typ='".$_GET['typ']."'  ");		

		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();

		} 





}

	   

?>