我正试图使数据表与一些过滤器选项和分页。(以后还想添加排序列)。
如果我试图过滤第一页的数据,它工作得很好。但是当我在另一个页面上,并试图过滤数据,它给出错误invalid argument supplied for foreach()
public function fetch_rows($limit, $start)
{
$emp_id = $this->input->post('emp_id');
$this->db->like('employee_id',$emp_id);
$emp_fname = $this->input->post('emp_fname');
$this->db->like('first_name',$emp_fname);
$emp_login = $this->input->post('emp_login');
$this->db->like('login_id',$emp_login);
$emp_position = $this->input->post('emp_position');
$this->db->like('position',$emp_position);
$this->db->limit($limit, $start);
$query = $this->db->get($this->_table_name);
var_dump($query);
if ($query->num_rows() > 0) {
foreach ($query->result() as $row)
{
$data[] = $row;
}
return $data;
}
return FALSE;
}
控制器public function employees()
{
$this->data['title'] = '<i class="fa fa-users"></i> ' . lang('emp_all');
$config = array();
$config['base_url'] = base_url() . 'admin/hr/employees';
$config['total_rows'] = $this->employees_model->row_count();
$config['per_page'] = 10;
$config['uri_segment'] = 4;
$this->pagination->initialize($config);
$page = ($this->uri->segment(4)) ? $this->uri->segment(4) : 0;
$this->data['results'] = $this->employees_model->fetch_rows($config['per_page'], $page);
$this->data['links'] = $this->pagination->create_links();
$this->load->view('hr/employees/index', $this->data);
}
<<p> 视图/strong> <div class="form-group">
<div class="row">
<?= form_open(); ?>
<div class="col-xs-1">
<?= form_input(array('name' => 'emp_id', 'id' => 'emp_id', 'class' => 'form-control', 'placeholder' => 'Employee ID')); ?>
</div>
<div class="col-xs-2">
<?= form_input(array('name' => 'emp_fname', 'id' => 'emp_fname', 'class' => 'form-control', 'placeholder' => 'First Name')); ?>
</div>
<div class="col-xs-1">
<?= form_input(array('name' => 'emp_login', 'id' => 'emp_login', 'class' => 'form-control', 'placeholder' => 'Login Id')); ?>
</div>
<div class="col-xs-2">
<?= get_positions('dropdown', 'emp_position'); ?>
</div>
<div class="col-xs-1">
<?= form_submit('filters', 'Go', 'class="btn-default btn"'); ?>
</div>
<div class="col-xs-2">
</div>
<?= form_close(); ?>
</div>
</div><!-- End filter form -->
<table cellpadding="0" cellspacing="0" border="0" class="table table-striped table-bordered datatables" id="">
<thead>
<tr class="active">
<?= is_system_admin() ? '<th class="center">ID<span>*</span></th>' : NULL; ?>
<th>Photo</th>
<th>Employee ID</th>
<th>Name</th>
<th>Position</th>
<th>Login ID</th>
<th>Email</th>
<th>Status</th>
</tr>
</thead>
<tbody>
<?php
if (count($results) > 0): foreach ($results as $data):
echo '<tr>';
echo is_system_admin() ? '<td class="center">' . $data->id . '</td>' : NULL;
echo '<td><img src="' . get_employee_snap($data->employee_id, $data->employee_snap) . '" alt="snap" width="64"/></td>';
echo '<td>' . $data->employee_id . '</td>';
echo '<td>' . $data->first_name . ' ' . $data->last_name . '</td>';
echo '<td>' . get_position_by_code($data->position) . '</td>';
echo '<td>' . $data->login_id . '</td>';
echo '<td>' . $data->email . '</td>';
echo '<td>' . $data->employment_status . '</td>';
echo '</tr>';
endforeach;
else:
echo show_alert('No Postions record found in database.', FALSE, 'warning');
endif;
?>
</tbody>
</table><!--end table-->
<?= $links; ?>
如何解决这个问题,无论我在哪个页面上都可以过滤,我也想使列可排序。
注意:我还想根据过滤器的结果来更新页码
百万谢谢…:)
代替
foreach ($query->result() as $row)
{
$data[] = $row;
}
return $data;
你可以直接使用
return $query->result_array();
和我发现,如果没有找到结果,$this->data['results']
将为false, FALSE
将导致foreach
错误,因为它不是数组。
注意:如果结果集为空,则返回一个空数组;
so in model而不是
if ($query->num_rows() > 0) {
foreach ($query->result() as $row)
{
$data[] = $row;
}
return $data;
}
return FALSE;
直接用
return $query->result_array();
像这样修改你的模型:
if ($query->num_rows() > 0) {
$data = array();
foreach ($query->result() as $row)
{
$data[] = $row;
}
return $data;
}
由于任何原因,如果查询无法加载数据,则认为$data
为未定义。因为foreach没有被执行