filter

catalogue.php(view) load->view('site/header'); ?>

• Browse by Book Status

  
  

  Available Books Unavailable Books

• Category

  • Browse by category_name ?>

    id; $sub_cat = $this->db->where('CategoryId', $ids)->get('subcategory')->result(); // print_r($data['sub_cat']); ?>

    SubCategory ?>

• Browse By Author

  author ?>

• Browse By Series

  series ?>

Top ↑

load->view('site/footer'); ?> controller public function books_catalogue(){ // $data['book_avail'] = $this->db->select('status')->where('status =', '1')->group_by('status')->get('book_info')->row(); $data['book_author'] = $this->db->select('author')->where('author <> ', '')->group_by('author')->get('book_info')->result(); $data['book_series'] = $this->db->select('series')->where('series <> ', '')->group_by('series')->get('book_info')->result(); $data['book_category'] = $this->db->get('category')->result(); $data ['book_cat'] = $this->db->get('book_info')->result(); $this->load->view('site/catalogue2',$data); } function fetch(){ $limit=$this->input->post('limit'); $start=$this->input->post('start'); $output = ''; // $this->load->model('scroll_pagination_model'); $data = $this->basic->fetch_data($limit,$start); return $this->output ->set_content_type('application/json') ->set_status_header(200) ->set_output(json_encode($data)); } modal function fetch_data($limit,$start) { $query= $this->db->select('*') ->join('category bc','bc.id=b.category_id') ->join('subcategory sc','sc.Id=b.subcategory_id') ->order_by('b.title','DESC') ->limit($limit,$start) ->get('book_info b')->result(); return $query; } route $route['books-catalogue'] = 'home/books_catalogue'; $route['fetch-books-catalogue'] = 'home/fetch_books_catalogue'; $route['fetch'] = 'home/fetch';