我使用codeigniter做了分页,从database里的table抽出显示。一页二十行。是限制到了一页二十行,但是翻页后(第二页或其他)就显示不了了。我的代码缺少了什么吗?Controllerpublic function abuse_report() {
$offset=0;
$dbb = $this->load->database('biitalk', TRUE);
$this->load->model('report_model'); $this->form_validation->set_rules('from_date', 'Start Date', 'required');
$this->form_validation->set_rules('to_date', 'End Date', 'required');
$this->load->library('pagination'); $config['base_url'] = site_url("admin/report/abuse_report/search/");
$config['total_rows'] = $this->report_model->get_abuse();
$config['per_page'] = 20;
$config['uri_segment'] = 5;
$this->pagination->initialize($config);
$data['page'] = $this->pagination->create_links();
$data['result'] = $this->report_model->readAbuse($config['per_page'], $this->uri->segment(5));
$data['main_content'] = 'report/abuse_report';
$this->load->view('includes/template', $data);
}
Model public function get_abuse() {
$dbb = $this->load->database('biitalk', TRUE);
$query = $dbb->get('rpt_abuse'); return $query->num_rows();
} public function readAbuse($num=null, $offset=null) {
$input = $this->set_datetime(); $dbb = $this->load->database('biitalk', TRUE);
$query = $dbb->where('create_date >=', $input['selected_date'])
->where('create_date <=', $input['selected_date_end'])
->order_by('status', 'asc')
->limit($num, $offset)
->get('rpt_abuse'); if ($query->num_rows > 0) {
foreach ($query->result_array() as $rows) {
$result[] = $rows;
} return $result;
}
}
ViewPages: <?php echo $page; ?>
跪求了...我到底错了什么?
$offset=0;
$dbb = $this->load->database('biitalk', TRUE);
$this->load->model('report_model'); $this->form_validation->set_rules('from_date', 'Start Date', 'required');
$this->form_validation->set_rules('to_date', 'End Date', 'required');
$this->load->library('pagination'); $config['base_url'] = site_url("admin/report/abuse_report/search/");
$config['total_rows'] = $this->report_model->get_abuse();
$config['per_page'] = 20;
$config['uri_segment'] = 5;
$this->pagination->initialize($config);
$data['page'] = $this->pagination->create_links();
$data['result'] = $this->report_model->readAbuse($config['per_page'], $this->uri->segment(5));
$data['main_content'] = 'report/abuse_report';
$this->load->view('includes/template', $data);
}
Model public function get_abuse() {
$dbb = $this->load->database('biitalk', TRUE);
$query = $dbb->get('rpt_abuse'); return $query->num_rows();
} public function readAbuse($num=null, $offset=null) {
$input = $this->set_datetime(); $dbb = $this->load->database('biitalk', TRUE);
$query = $dbb->where('create_date >=', $input['selected_date'])
->where('create_date <=', $input['selected_date_end'])
->order_by('status', 'asc')
->limit($num, $offset)
->get('rpt_abuse'); if ($query->num_rows > 0) {
foreach ($query->result_array() as $rows) {
$result[] = $rows;
} return $result;
}
}
ViewPages: <?php echo $page; ?>
跪求了...我到底错了什么?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货