[eluser]anyamanggar[/eluser]
Helo Guys, I have trouble, and please help me about pagination
Frontend_model
Code:
<?php
class Frontend_model extends CI_Model {
function __construct()
{
parent::__construct();
}
// menampilkan template untuk di depan
function get_list($limit,$offset)
{
$this->db->order_by('id','desc');
$query = $this->db->get('template',$limit, $offset);
return $query->result_array();
}
function get_template()
{
$this->db->order_by('id','desc');
$query = $this->db->get_where('template');
return $query->result_array();
}
function get_template_kategori($limit,$offset)
{
$kategori_id = $this->input->post('kategori');
$query = $this->db->get_where('template', array('kategori' => $kategori_id), $limit,$offset);
return $query->result_array();
}
function num_rows_template()
{
return $this->db->get('template')->num_rows();
}
function num_rows_template_select()
{
$kategori_id = $this->input->post('kategori');
return $this->db->get_where('template', array('kategori' => $kategori_id))->num_rows();
}
// ini end of class model
}
home(controller)
Code:
<?php
if (!defined('BASEPATH')) exit ('No direct script access allowed');
class Home extends CI_Controller{
public function __construct(){
parent::__construct();
$this->load->model('frontend_model');
$this->load->library('form_validation');
$this->load->helper('form');
$this->load->helper('url');
$this->load->library('table');
$this->load->helper('html');
$this->load->library('pagination');
}
public function index($offset = 0){
$limit = 10;
if(empty($offset)){ $offset = 0;}
$config['first_link'] = 'Kembali Ke Halaman Depan';
$config['first_tag_open'] = '<li class="pagination">';
$config['first_tag_close'] = '</li>';
$config['last_link'] = 'Halaman Terakhir';
$config['last_tag_open'] = '<li class="pagination">';
$config['last_tag_close'] = '</li>';
// Next Link
$config['next_link'] = 'Berikutnya';
$config['next_tag_open'] = '<li class="pagination">';
$config['next_tag_close'] = '</li>';
// Previous Link
$config['prev_link'] = 'Sebelumnya';
$config['prev_tag_open'] = '<li class="pagination">';
$config['prev_tag_close'] = '</li>';
// Current Link
$config['cur_tag_open'] = '<li class="activepagination">';
$config['cur_tag_close'] = '</li>';
// Digit Link
$config['num_tag_open'] = '<li class="pagination">';
$config['num_tag_close'] = '</li>';
$data['listtemplate'] = $this->frontend_model->get_list($limit,$offset);
$config['base_url'] = base_url().'/home/index/';
$config['total_rows'] = $this->frontend_model->num_rows_template();
$config['per_page'] = $limit;
$config['uri_segment'] = 3;
$this->pagination->initialize($config);
// ini untuk dropdown menu
$data['templatedepan'] = $this->frontend_model->get_template();
$dbres = $this->db->get('kategori');
$ddmenu = array();
foreach ($dbres->result_array() as $tablerow) {
$ddmenu[$tablerow['nama_kategori']] = $tablerow['nama_kategori'];
}
$data['options'] = $ddmenu;
$this->load->view('frontend/home_view', $data);
}
function submit($offset = 0){
$limit = 10;
if(empty($offset)){ $offset = 0;}
$config['first_link'] = 'Kembali Ke Halaman Depan';
$config['first_tag_open'] = '<li class="pagination">';
$config['first_tag_close'] = '</li>';
$config['last_link'] = 'Halaman Terakhir';
$config['last_tag_open'] = '<li class="pagination">';
$config['last_tag_close'] = '</li>';
// Next Link
$config['next_link'] = 'Berikutnya';
$config['next_tag_open'] = '<li class="pagination">';
$config['next_tag_close'] = '</li>';
// Previous Link
$config['prev_link'] = 'Sebelumnya';
$config['prev_tag_open'] = '<li class="pagination">';
$config['prev_tag_close'] = '</li>';
// Current Link
$config['cur_tag_open'] = '<li class="activepagination">';
$config['cur_tag_close'] = '</li>';
// Digit Link
$config['num_tag_open'] = '<li class="pagination">';
$config['num_tag_close'] = '</li>';
$data['listtemplate'] = $this->frontend_model->get_template_kategori($limit,$offset);
$config['base_url'] = base_url().'/home/submit/';
$config['total_rows'] = $this->frontend_model->num_rows_template_select();
$config['per_page'] = $limit;
$config['uri_segment'] = 3;
$this->pagination->initialize($config);
$dbres = $this->db->get('kategori');
$ddmenu = array();
foreach ($dbres->result_array() as $tablerow) {
$ddmenu[$tablerow['nama_kategori']] = $tablerow['nama_kategori'];
}
$data['options'] = $ddmenu;
$this->load->view('frontend/sub_view', $data);
}
}
view
Code:
<div id="kategori">
<h1 class="titlekategori">Silahkan pilih kategori website yang diinginkan: </h1>
<br /> <br />
<?php
echo form_open('home/submit', $options);
echo form_dropdown('kategori',$options, 'selected = Hotels');
echo form_submit('mysubmit', 'GO','class = buttonsearch');
?>
</div>
<ul class="listtemp">
<?php
foreach ($listtemplate as $kategoridepan_item): ?>
<li><img src="<?php echo base_url();?><?php echo $kategoridepan_item['img_path'] ?>" alt="gallery thumbnail" /><br /><?php echo $kategoridepan_item['title'] ?> <br />
<a href="<?php echo $kategoridepan_item['link'] ?>">Demo</a>
The quistion is, when i click the page didnt show of with true data..