Welcome Guest, Not a member yet? Register   Sign In
Codeigniter pagination
#11

[eluser]khagendra[/eluser]
Here is Your code
Code:
$pagination_config['base_url'] = base_url().'index.php/quotes/showchapter/'.$chapter_id.'/';
$pagination_config['total_rows'] = $query->num_rows();
$pagination_config['per_page'] = QUOTES_PER_PAGE;
$pagination_config['num_links'] = 2;
$pagination_config['first_link'] = 'Start';
$pagination_config['last_link'] = 'End';
$pagination_config['next_link'] = ' > ';
$pagination_config['prev_link'] = ' < ';
$pagination_config['uri_segment'] = 2;
$this->pagination->initialize($pagination_config);

-- I think u need to do some changes
1. Load the library pagination in ur controller(u can load in constructor function)

Code:
$this->load->library('pagination');

2. Where u have written the Query in ur code
Code:
$pagination_config['total_rows'] = $query->num_rows(); // $query ???

3. According to ur $pagination_config['base_url'] = base_url().'index.php/quotes/showchapter/'.$chapter_id.'/';, I think uri_segment should be 4
Code:
$pagination_config['uri_segment'] = 4;

4. Have u retrieved the list of data from any table with limit and offset valu, here is one line of code that u can write before $this->pagination->initialize($pagination_config); like this
Code:
$data['data_list'] = $this->model_name->function_name($config['per_page'],$this->uri->segment(4));
$this->pagination->initialize($pagination_config);

5. Here is the model function name example
Code:
function function_name($limit, $offset)
{
...ur codes
  $query = $this->db->get('tblname', $limit, $offset);
  $data=$query->result();
  $query->free_result();
  return $data;
}

6.last thing, u should have to write this line in ur view file to show links
Code:
echo $this->pagination->create_links();

Hope this will help you


Messages In This Thread
Codeigniter pagination - by El Forum - 10-26-2009, 11:30 PM
Codeigniter pagination - by El Forum - 10-26-2009, 11:37 PM
Codeigniter pagination - by El Forum - 10-27-2009, 12:47 AM
Codeigniter pagination - by El Forum - 10-27-2009, 04:14 AM
Codeigniter pagination - by El Forum - 10-27-2009, 05:22 AM
Codeigniter pagination - by El Forum - 10-27-2009, 05:28 AM
Codeigniter pagination - by El Forum - 10-27-2009, 05:47 AM
Codeigniter pagination - by El Forum - 10-27-2009, 05:50 AM
Codeigniter pagination - by El Forum - 10-27-2009, 05:53 AM
Codeigniter pagination - by El Forum - 10-27-2009, 05:58 AM
Codeigniter pagination - by El Forum - 10-27-2009, 06:08 AM
Codeigniter pagination - by El Forum - 10-27-2009, 06:09 AM
Codeigniter pagination - by El Forum - 10-27-2009, 06:16 AM
Codeigniter pagination - by El Forum - 11-04-2009, 02:40 PM
Codeigniter pagination - by El Forum - 11-04-2009, 02:46 PM



Theme © iAndrew 2016 - Forum software by © MyBB