使用带codeigniter的ajax datatable显示数据
使用带codeigniter的ajax datatable显示数据
提问于 2017-12-18 21:47:31
我想使用ajax在我的视图中显示来自数据库的数据。但我收到这条消息: DataTables warning: table id=users -请求的行0，列0的未知参数'0‘。有关此错误的更多信息，请参阅http://datatables.net/tn/4
这是我的控制器：
public function listUser(){
if ($this->session->userdata("success"))
{
// les Variables de datatable
//
$draw = intval($this->input->post("draw"));
//
$start = intval($this->input->post("start"));
$length = intval($this->input->post("length"));
$user = $this->UserModel->getUsers();
$data = array();
foreach( $user as $r) {
$tab[] = array();
$tab[] = $r->username;
$tab[] =$r->usersurname;
$tab[] =$r->useremail;
$tab[] =$r->date_create;
$tab[] =$r->Num_tel;
$tab[] =$r->userright;
$tab[] = '<button type="button" name="update" id="'.$r->user_id.'" class="btn btn-warning btn-xs update">Modifier</button>';
$tab[] = '<button type="button" name="delete" id="'.$r->user_id.'" class="btn btn-danger btn-xs delete">Supprimer</button>';
$data = $tab;
}
$output = array(
"draw" => $draw,
"recordsTotal" => count($user),
"recordsFiltered" => count($user),
"data" => $data
);
echo json_encode($output);
exit();
}
// $this->load->view('users/listUser',['user'=>$user]);
// }
else
{
return redirect('Login');
}
}回答 2
Stack Overflow用户
发布于 2017-12-18 22:03:02
你的问题可能出在循环部分，每次循环经过这一行时，你并没有重置变量，而是将一个新的数组附加到$tab中，你应该使用$tab = array();来重置变量，并在最后使用$data[] = $tab;将$tab数据附加到$data变量中。
$data = array();
foreach( $user as $r) {
$tab = array();
$tab[] = $r->username;
$tab[] = $r->usersurname;
$tab[] = $r->useremail;
$tab[] = $r->date_create;
$tab[] = $r->Num_tel;
$tab[] = $r->userright;
$tab[] = '<button type="button" name="update" id="'.$r->user_id.'" class="btn btn-warning btn-xs update">Modifier</button>';
$tab[] = '<button type="button" name="delete" id="'.$r->user_id.'" class="btn btn-danger btn-xs delete">Supprimer</button>';
$data[] = $tab;
}Stack Overflow用户
发布于 2017-12-18 23:33:48
好的，谢谢，但是我保留了另一个警告: DataTables警告:表id=users -请求的行0，列6的未知参数'6‘。有关此错误的更多信息，请参见http://datatables.net/tn/4
这是我的观点：
<table class="display responsive no-wrap table table-striped table-bordered table-hover table-checkable order-column dataTable no-footer" id="users" width="100%">
<thead>
<tr>
<th>Nom</th>
<th>Prenom</th>
<th>E-mail</th>
<th>Date de creation</th>
<th>Téléphone</th>
<th>Droit</th>
<th>Modifier</th>
<th>Supprimer</th>
</tr>
</thead>
</table>
<script type="text/javascript">
$('document').ready(function() {
let mouvementTable = $("#users").DataTable({
buttons: [{
extend: "print",
className: "btn dark btn-outline"
}, {
extend: "pdf",
className: "btn green btn-outline"
}, {
extend: "excel",
className: "btn yellow btn-outline "
}, {
extend: "csv",
className: "btn purple btn-outline "
}],
"ajax": {
url : "http://localhost/logistock/index.php/ControllerUser/listUser",
"type": "POST"
},
order: [[ 1, 'asc' ]],
"select": {
"style": 'multi',
"selector": 'td:first-child'
},
"dom": "<'row' <'col-md-12'B>><'row'<'col-md-6 col-sm-12'l><'col-md-6 col-sm-12'f>r><'table-scrollable't><'row'<'col-md-5 col-sm-12'i><'col-md-7 col-sm-12'p>>",
"lengthMenu": [[5, 10, 15, 20, -1], [5, 10, 15, 20, "All"]],
"language": {
"url": "//cdn.datatables.net/plug-ins/9dcbecd42ad/i18n/French.json"
}
});
});
</script>页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/47869870
复制相关文章
相似问题
腾讯云开发者
