Welcome Guest, Not a member yet? Register   Sign In
Pagination Help
#1

[eluser]steviez[/eluser]
Hi,

I am trying to make pagination work with my code but no matter what i do it wont work! All my results show on the page even though i have set limits. Here is my code:

Code:
<?php

class Search extends Controller {

    function Search()
    {
        parent::Controller();
    }
    
    function index($offset = "")
    {
        $this->load->library("pagination");
        
        $limit = 1;
        
        $query = "SELECT * FROM members ";
        
        if($this->input->post("task") == "doSearch")
        {
            $query .= "";
        }
        
        $query .= "ORDER BY id ASC";
        
        $result = $this->db->query($query);
        $this->db->limit($limit, $offset);
        $searchMembers = $result->result_array();
        $numMembers = $result->num_rows();
        
        $pagination_config['base_url'] = base_url() . "search/";
        $pagination_config['total_rows'] = $numMembers;
        $pagination_config['per_page'] = $limit;
        $pagination_config['uri_segment'] = '2';
        $this->pagination->initialize($pagination_config);
        
        $data['searchMembers'] = $searchMembers;
        $data['numMembers'] = $numMembers;
        $data['pagination'] = $this->pagination->create_links();
        
        $this->load->view('header');
        $this->load->view('search', $data);
        $this->load->view('footer');
    }
}

?>

anybody any ideas?
#2

[eluser]InsiteFX[/eluser]
Code:
$this->load->library('pagination');

$config['base_url'] = 'http://example.com/index.php/test/page/';
$config['total_rows'] = '200';
$config['per_page'] = '20';
$config['num_links'] = 2;
$config['uri_segment'] = 2; // may need to change!

$this->pagination->initialize($config);

CodeIgniter Pagunation Class

InsiteFX




Theme © iAndrew 2016 - Forum software by © MyBB