Skip to main content

mau tanya tentang pagination di CI

May 22, 2010 by viovio

viovio's picture

mau tanya tentang pagination di CI kok punyaku blm jalan. memang masih bingung juga ttg paginationnya. kemarin cari2 dapet tapi kok blm jalan juga

code modelnya :

class Buku_model extends Model {
 
	function __construct(){
		parent::Model();
 
	}
 
	function get_buku()
	{
		$query=$this->db->query('select * from buku ORDER BY id_buku');
		return $query->result();
	}
}

code controlnya :

class Buku extends Controller {
 
	function Buku()
	{
		parent::Controller();	
		$this->load->database();
		$this->load->helper('url');
	}
 
	function index()
	{
		$this->load->model('rak_model');
		$this->load->model('kategori_model');
		$this->load->model('pengarang_model');
		$this->load->model('penerbit_model');
		$this->load->model('pencetak_model');
		$this->load->library("pagination");   
		$this->load->view('buku');
 
		$config['base_url'] = base_url().'index.php/buku/index/';
		$config['total_rows'] = $this->db->count_all('tabel data');
		$config['per_page'] = '10';
		$this->pagination->initialize($config);
 
		$this->load->model('buku_model');
		$data['results'] = $this->buku_model->get_buku($config['per_page'],$this->uri->segment(3));
 
		// load the HTML Table standart CI
		$this->load->library('table');
		$this->table->set_heading('id_buku', 'jdl_buku', 'isbn', 'thn_terbit');
 
		// load the view menggunakan template
		//$this->init_model->displayTemplate('front/buku', $data);
	}
}
 
code viewnya :
<?php echo $this->table->generate($results); 

 echo $this->pagination->create_links();

mohon pencerahannya,

Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Bls:

May 23, 2010 by syabac, 1 year 36 weeks ago
Comment: 6870

syabac's picture

Coba jawab ya..
sebenernya yang kamu kasih itu sudah bener,
tapi perlu diedit dikit modelnya jadi:

 
 function get_buku($limit, $offset)
    {
        $this->db->from('buku')->limit($limit)->offset($offset);
        return $this->db->get()->result();
    }

semoga membantu..

Premium Drupal Themes by Adaptivethemes