每当我点击分页链接时。。。显示未找到obeject。我不知道如何将值传递给本页的{index.php/view_expenses/view&per_page=2}。不要介意这是一个愚蠢的问题,我刚刚在php和codeigniter上大了2个月。任何帮助都会很棒:D
这是我的控制器
function view($offset=0)
{
$limit=5;
$this->uri->segment(3);
$this->load->model('emp_expenses_model');
$result['contents']=$this->emp_expenses_model->getRows($limit,$offset);
$result['countRows']=$this->emp_expenses_model->countRows();
$this->load->library('pagination');
$this->load->library('table');
$config=array(
'base_url' => '/index.php/view_expenses/view',
'total_rows' => $this->db->get('emp_expenses')->num_rows($limit,$offset),
'per_page' => $limit,
'uri_segment' => 3,
'num_links' => 1,
);
$this->db->limit(5);
$this->pagination->initialize($config);
$this->load->model('emp_expenses_model');
$this->data['view_expenses'] = $this->emp_expenses_model->get_all();
//var_dump($this->data['pay_list']);die("jk");
$this->data['title'] = 'Payroll System';
$this->data['message'] = $this->session->flashdata('message');
$this->load->library('pagination');
$this->load->view('view_expenses', $this->data);
/*$this->load->view('add_list', $this->data);*/
}
这是我的型号
function getRows($limit,$offset)
{
$query=$this->db->select('expenses_id,id,dropdown,modeofpayment,amount')
->from('emp_expenses')
->limit($limit,$offset);
$result=$query->get()->result_array();
return $result;
}
function countRows()
{
$query="select count(*) as count from emp_expenses";
$result=$this->db->query($query);
return $result->result_array();
}
要创建分页HTML,可以调用create_links()
,然后将其与其他数据一起传递给视图。这将自动为您生成正确的链接。尝试将其包含在您的控制器中:
$this->data['pagination'] = $this->pagination->create_links();
确保在$this->pagination->initialize($config);
之后调用
那么在你看来:
echo $pagination;
模型的更改:
function countRows(){
//$query="select count(*) as count from emp_expenses";
$result = $this->db->count_all_results('emp_expenses');
//$result=$this->db->query($query);
return $result;
}
在您的控制器中更改以下线路,
$result['countRows']=$this->emp_expenses_model->countRows();
$this->load->library('pagination');
$this->load->library('table');
$config=array(
'base_url' => '/index.php/view_expenses/view/',
'total_rows' => $result['countRows'],
'per_page' => $limit,
'uri_segment' => 3,
'num_links' => 1,
);
我看到你已经加载了两次model
,请对第二次进行评论。如果您没有在视图中加载$result['contents']=$this->emp_expenses_model->getRows($limit,$offset);
,为什么要使用它?
在您的视图中,调用<?=$this->pagination->create_links()?>
查看分页。