Using Collimator Stakeout Using Query in Model
I want to do pagination with codeigniter but doesn't work successfully. in my model i use like this
function show_kegiatan($offset,$limit) {
$query= $this->db->query("SELECT kegiatan . * , lk . * , fakultas.* , count( kegiatan_review.reviews ) AS 'Komentar', fakultas.*
FROM kegiatan
INNER JOIN lk ON lk.id_LK = kegiatan.id_LK
INNER JOIN fakultas on fakultas.id_fakultas = lk.id_fakultas
LEFT OUTER JOIN kegiatan_review ON kegiatan.id_kegiatan = kegiatan_review.id_kegiatan
GROUP BY kegiatan.id_kegiatan
ORDER BY kegiatan.tahun_periode DESC
limit $offset",$limit);
if ($query->num_rows() > 0) {
return $query->result();
}
}
In my controller
public function kegiatan($offset=0) {
$data['user']=$this->m_login->get_user($this->session->userdata('sesi_admin'));
$jml = $this->db->get('kegiatan');
$config['base_url'] = base_url().'admin/kegiatan';
$config['total_rows'] = $jml->num_rows();
$config['per_page'] = 3;
$config['uri_segment'] = 3;
$config['full_tag_open'] = "<ul class='pagination pagination-sm' style='position:relative; top:-25px;'>";
$config['full_tag_close'] ="</ul>";
$config['num_tag_open'] = '<li>';
$config['num_tag_close'] = '</li>';
$config['cur_tag_open'] = "<li class='disabled'><li class='active'><a href='#'>";
$config['cur_tag_close'] = "<span class='sr-only'></span></a></li>";
$config['next_tag_open'] = "<li>";
$config['next_tagl_close'] = "</li>";
$config['prev_tag_open'] = "<li>";
$config['prev_tagl_close'] = "</li>";
$config['first_tag_open'] = "<li>";
$config['first_tagl_close'] = "</li>";
$config['last_tag_open'] = "<li>";
$config['last_tagl_close'] = "</li>";
$this->pagination->initialize($config);
$data['halaman'] = $this->pagination->create_links();
$data['offset'] = $offset;
$data['kegiatan'] = $this->m_admin->show_kegiatan($config['per_page'], $offset);
$this->load->templateadmin('in/admin_kegiatan',$data);
}
In my release, Offset works, but data doesn't work successfully. What's wrong with my model?
+3
source to share
2 answers
You can use $this->uri->segment(3)
to replace$offset
Please try this sample, the rest you should change according to your needs ...
In your model:
function show_kegiatan($perPage, $uri) {
$uri = ($uri == null || $uri==''?0:$uri);
$this->db->select('kegiatan.kolommu1,kegiatan.kolommu2,lk.kolommu1,lk.kolommu2')->from('kegiatan')->join('lk','lk.id_LK = kegiatan.id_LK')->order_by('kegiatan.id_kegiatan','desc')->limit($perPage,$uri);
$hasil = $this->db->get()->result_array();
return (sizeof($hasil) > 0?$hasil:null);
}
In your controller:
function kegiatan(){
$jml = $this->db->get('kegiatan')->num_rows();
$config['full_tag_open'] = "<ul class='pagination pagination-sm' style='position:relative; top:-25px;'>";
$config['full_tag_close'] ="</ul>";
$config['num_tag_open'] = '<li>';
$config['num_tag_close'] = '</li>';
$config['cur_tag_open'] = "<li class='disabled'><li class='active'><a href='#'>";
$config['cur_tag_close'] = "<span class='sr-only'></span></a></li>";
$config['next_tag_open'] = "<li>";
$config['next_tagl_close'] = "</li>";
$config['prev_tag_open'] = "<li>";
$config['prev_tagl_close'] = "</li>";
$config['first_tag_open'] = "<li>";
$config['first_tagl_close'] = "</li>";
$config['last_tag_open'] = "<li>";
$config['last_tagl_close'] = "</li>";
$config['base_url'] = site_url('admin/kegiatan');
$config['total_rows'] = $jml;
$config['per_page'] = 3;
$config['uri_segment'] = 3;
$config['first_link'] = 'Awal';
$config['last_link'] = 'Akhir';
$config['next_link'] = 'Selanjutnya';
$config['prev_link'] = 'Sebelumnya';
$this->pagination->initialize($config);
$data['kegiatan'] = $this->m_admin->show_kegiatan($config['per_page'], $this->uri->segment(3));
$data['halaman'] = $this->pagination->create_links();
$this->load->view('layout/admin/v_dashboard',$data);
$this->load->templateadmin('in/admin_kegiatan',$data);
}
+1
source to share