Thread

<? class My_data_page extends Controller{
    function My_data_page(){
       parent::Controller();
       $this->load->library('table');
       $this->load->library('Ajax_pagination');
    }
    function index(){
        $data['makeColumns'] = $this->makeColumns();
        $data['getTotalData'] = $this->getTotalData();
        $data['perPage'] = $this->perPage();
        $this->load->view('my_data_page', $data);
    }
    //Pull 'name' field records from table 'contact'
    function getData(){
        
        $page = $this->input->post('page'); //Look at $config['postVar']
        if(!$page):
        $offset = 0;
        else:
        $offset = $page;
        endif;
        
        $sql = "SELECT name FROM contact LIMIT ".$offset.", ".$this->perPage();
        $q = $this->db->query($sql);
        return $q->result();
    }
    function getTotalData(){
      $sql = "SELECT * FROM people";
      $q = $this->db->query($sql);
      return $q->num_rows();
    }
    
    function perPage(){
         return 10; //define total records per page
      }
    
    //Generate table from array
    function makeColumns(){
         $contact = $this->getData();
         foreach($contact as $cont):
         $data[] = $cont->name;
         endforeach;
         return  $this->table->make_columns($data, 6); //6 colums maximum
    }
} 
?>

<s\cript type="text/javascript" src="path-to-prototype.js"></s\cript>
<div id="content">
<?
$config['first_link'] = 'First';
$config['div'] = 'content'; //Div tag id
$config['base_url'] = 'index.php/my_data_page';
$config['total_rows'] = $getTotalData;
$config['per_page'] = $perPage;
$config['postVar'] = 'page';

$this->ajax_pagination->initialize($config);
print $this->ajax_pagination->create_links();
//PRINT TABLE
print $this->table->generate($makeColumns);
?> 
</div>

<? class My_data_page_loader extends Controller{
   My_data_page_loader(){
    parent::Controller;
  }
  function index(){
    $this->load->view('my_data_page_loader');
  }
}

<div id="content">
<table border="0" cellpadding="4" cellspacing="0">
... ... ...
</table>
 <b>1</b>
 <a href="#">2</a>
 <a href="#">></a>
 
</div>