使用带有codeigniter的ajax datatable显示数据

Question

我想使用Ajax在我的视图中显示来自数据库的数据。但我收到了这样一条消息:DataTables warning:table ID=users-requested未知参数'0'for行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');  
        }

}

Answer 1

好的，谢谢，但我收到另一个警告:DataTables警告:table id=users-requested未知参数'6'用于行0，列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>

Answer 2

您的问题可能出在循环部分，每次循环通过这一行 时，您不是重置变量，而是实际上将一个新数组追加到 ，您应该使用 重置变量，并最终使用 将 数据追加到 变量。

 $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;
}