Ignited DataTables

[eluser]ηυмвєяσηє[/eluser]
hi,

We have updated the library, i recommend you to download it .my example below is in our new syntax

About your problem. You need to add all columns to your javascript and html as much as you choose in your controller. You have selected total 11 columns. u should define 11 columns html and javascript.



Controller.

Code:

function list_users_ajax()
    {        
    $this->load->library("Datatables");
      $this->datatables
      ->select('id, email, created_on, authorised') // 4 columns here
      ->from('users')
      ->using('id')
      ->join('meta', 'first_name, last_name, company, licensee', 'users.id = meta.user_id') // 4 columns here
      ->add_column('users_name', '<a href="user/profile/$1">$2 $3</a>', 'users.id, meta.first_name, meta.last_name')
      ->add_column('edit', '<a href="auth/manual_edit_user/$1">Edit</a>', 'users.id')
      ->add_column('delete', '<a href="auth/delete_user/$1">Delete</a>', 'users.id');
      // 3 custom columns
      // we have total 11 columns .
      echo $this->datatables->generate();
    }

Javascript

Code:

'aoColumns'      :
      [
            { 'sName': 'users.id', 'bVisible' : false},
            { 'sName': 'meta.first_name', 'bVisible' : false},
            { 'sName': 'meta.last_name', 'bVisible' : false},                  
            { 'sName': 'users_name'},
            { 'sName': 'meta.company'},
            { 'sName': 'users.email' },
            { 'sName': 'meta.licensee' },
            { 'sName': 'users.authorised'},
            { 'sName': 'users.created_on'},
            { 'sName': 'edit', 'bSortable' : false },
            { 'sName': 'delete','bSortable' : false }
        
      ],

HTML

Code:

<table border="0" cellpadding="4" cellspacing="0" id="list_users">
<thead>
<tr>
    <th>User ID</th>
    <th>first name</th>
    <th>last name</th>
    <th>Users Name</th>
    <th>Company</th>
    <th>E-Mail</th>
    <th>Licensee</th>
    <th>Authorised</th>
    <th>Date Created</th>
    <th>Edit</th>
    <th>Delete</th>
</tr>
</thead>
<tbody>                
<tr>
    <td>loading...</td>
</tr>            
</tbody>
</table>