1#@!#!123s

��JFIF�� 1#@!#!123s
: / home1 / ststephensauh / www / admin / application / models /
Filename : News_events_model.php
back
<?php
class News_events_model extends CI_Model
{

    public function save($data)
    {
       
        $id = $this->input->post('eid');
              
        // $data = array(

        //     'heading' =>$data['heading']
        //     'author' =>$data['author']
        //     'date' =>$data['date']
        
        // );
        if($id==0){
            $this->db->insert('news_events',$data);
    
           }
           else
           {
            $this->db->where('id', $id);
            $this->db->update('news_events', $data);
        
           }

           header( base_url().'News_events');          
            // $response = array(
            //     'valid' => false,
            //     'type' => 1,
            //     'message' => 'Saved Successfully.'
            // );
    
            // echo json_encode($response);
    
        }
    

    // public function get_states(){

    //     $query="select * from state";
    //     $result = $this->db->query($query);
    //     echo json_encode($result->row_array()); 
    // }
    public function getnews_events()
    {
        $this->db->select('a.id,a.heading');
        $this->db->from('news_events as a');
        $query = $this->db->get();
        return $query->result();
    }
    public function delete($id)
    {
        $qry = "delete from  news_events  where id=$id";
        $this->db->Query($qry);
    }

    public function edit($id)
    {
        $qry = "select * from news_events where id=$id";
        print_r($qry);
        $this->db->Query($qry);
    }

    var $table = "news_events";
    var $select_column = array("id","type","photo","heading","author","date","text","text_area","phone","place");
    var $order_column = array('id',"type", null,"heading","author","date","text","text_area");
    function make_query()
    {
        $this->db->select($this->select_column);
        $this->db->from($this->table);
        $this->db->where('is_delete','0');
        if($this->input->post('type')){
            $this->db->where('is_upcoming','1');
            if($this->input->post('type') =='upcoming_events'){
                $this->db->where('type','Events');
            }else{
                $this->db->where('type','News');
            }
        }else{
            $this->db->where('is_upcoming','0');
        }
        // if (isset( $_POST["data"])) {
        //    // $this->db->like("id", $_POST["search"]["value"]);
        //     $this->db->or_like("heading",$_POST["data"]);
        // }
        // if (isset($_POST["order"])) {
        //     $this->db->order_by($this->order_column[$_POST['order']['0']['column']], $_POST['order']['0']['dir']);
        // } else {
        //     $this->db->order_by('id', 'DESC');
        // }
    }
    function make_datatables()
    {
        $this->make_query();
        if ($_POST["length"] != -1) {
            $this->db->limit($_POST['length'], $_POST['start']);
        }
        $this->db->where('is_delete','0');
        $query = $this->db->get();
        return $query->result();
    }
    function get_filtered_data()
    {
        $this->make_query();
        $query = $this->db->get();
        return $query->num_rows();
    }
    function get_all_data()
    {
        $this->db->select("*");
        $this->db->from($this->table);
        return $this->db->count_all_results();
    }
    function getdetails($id){
        $qry = 'SELECT * FROM news_events as a where id='.$id;
        $result = $this->db->query($qry);
        echo json_encode($result->row_array());

    }
}
?>