function mybook($sort_by = 'NAME', $sort_order = 'asc', $offset = 0) { if (!isset($_REQUEST['user_id'])) { $this->is_logged_in(); } //new model instance $this->load->model('mybook_model'); $this->load->model('log_model'); $id_user_login = $this->log_model->getId(); $per_page = 8; $offset = $this->uri->segment(2) == '' ? 0 : $this->uri->segment(2); $results = $this->mybook_model->SelectAll($per_page, $offset, $sort_by, $sort_order, $id_user_login); //load database $db_init = $this->load->database('admin_education', TRUE); //pagination $this->load->library('pagination'); $config['total_rows'] = $results['num_rows']; $config['per_page'] = $per_page; $config['next_link'] = 'Trang tiếp »'; $config['prev_link'] = '« Trang sau'; $config['num_tag_open'] = ''; $config['num_tag_close'] = ''; $config['num_links'] = 10; $config['cur_tag_open'] = '<a class="currentpage">'; $config['cur_tag_close'] = '</a>'; $config['first_link'] = 'Trang đầu'; $config['last_link'] = 'Trang cuối'; $config['base_url'] = "http://myweb.pro.vn/my-book/"; $config['uri_segment'] = 2; $this->pagination->initialize($config); $pagination = $this->pagination->create_links(); if (isset($_REQUEST['category'])) { foreach ($db_init->select('*')->from('user_ebook_category')->where('id_u', $id_user_login)->where('name', $_REQUEST['category'])->get()->result_array() as $key) { } redirect('/book/mybook?id_category=' . $key['id']); } $user = $this->db->select('*')->from('qtht_users')->where('ID_U', $id_user_login)->get()->result_array(); foreach ($user as $u) { } //render view $data['book_last_row'] = array(); $data['book_top_row'] = array(); if (isset($_REQUEST['id_category'])) { $data['id_category'] = $_REQUEST['id_category']; $query_result = $db_init->select('*')->from('user_ebook_category')->where('id', $_REQUEST['id_category'])->get()->result_array(); $data['cate'] = $query_result[0]['name']; } if (!isset($_REQUEST['id_category'])) { $data['id_category'] = '0'; $data['cate'] = ''; } $data['user_name'] = $u['NAME']; $data['user_id'] = $id_user_login; $data['elib'] = $results['rows']; $data['count_elib'] = $results['num_rows']; $data['pagination'] = $pagination; $data['category_names'] = $db_init->select('*')->from('user_ebook_category')->where('id_u', $id_user_login)->get()->result_array(); $data['csrf_test_name'] = $this->security->get_csrf_hash(); $header = new header(); $header->mybook('Tủ sách của ' . $u['NAME']); $this->load->view('book/user', $data); }