I have this current code.

I want to add a column at the end for ‘Actions’
add_coumn is not working

ninjayan - 20 October 2012 08:24 AM

I have this current code.

$this->load->library('datatables');
  $this->datatables
    ->select("username")
    ->select("CONCAT(salutation, '. ', first_name, ' ', middle_initial, '. ', last_name) as full_name", FALSE)
    ->select("office, position, email, privilege, datetime_registered")
    ->where("username !=", $this->session->userdata('username'))
    ->from("users")
    ->add_column('view', '<a href="">AA</a>');
  echo $this->datatables->generate(); 

I want to add a column at the end for ‘Actions’
add_coumn is not working

Ah, I see what you mean now. Sorry, I misunderstood your first post.. My mistake.

Just to confirm, is this code in your controller or your model? Is the data getting through if you try without the add_column() method in the chain?

If I remember correctly, when I tried this I only got it to work after using print() at the end of the $this->datatables() chain. Here’s the relevant code from a recent project I worked on:

In this case, I set the AJAX source in my DT initialization to a url generated by:

Not sure if there’s a better way to do this, but this worked for me. Just a thought, but maybe try use print() instead of echo() on your generate() line.

Thanks for replying.
My code is only at the controller. I haven’t tried yet to put it on my model.

Ok, I think I have to show you the codes.

controller

view:

I want to add a column Action after the ‘Date Registered’. Content of it will be icon disable user, promote/remove as admin.

ninjayan - 20 October 2012 11:04 PM

I want to add a column Action after the ‘Date Registered’. Content of it will be icon disable user, promote/remove as admin.

I suspect the biggest issue here is the fact that the number of columns between your data source (in your controller) and the number of columns in your end table (in your view), do not match. You’re trying to put data for 8 columns into a 7 column table. Out of curiosity, have you tried adding an extra column to your HTML table in your view? Sometimes the simplest solution works out best in the end.

Unfortunately though, DataTables itself doesn’t support dynamically adding columns, this question has been asked many times on the DT forum in the past. Digging through these questions again this morning, I found a link to a tutorial that looks like it does exactly what you’re asking for [link].

Otherwise, have you considered using something like the drill-down rows example, placing the ‘user specific functions’ in the row that shows up below the clicked row? This way, the data is added dynamically to the row before it’s displayed, and the row is destroyed after it’s hidden. It’s very easy to use and very efficient as well.

This is giving me ideas for another project I’m working on now.. Time to go play. (:

Thank you. I will try it.

Can I directly echo the username in the add_column? I want to put the username inside anchor tag

The first link is the same from what I’m looking for but I’m using ignited datatables.
Sorry.

cryogenix - 08 March 2011 03:39 AM

Pegasus275 - 02 March 2011 02:00 PM

How to use it with action column for example edit/delete etc.

<tr>
<td> id from db</td>
<td> name from db </td>
<td> Edit
</tr>

you can use petroz’s client side solution to create additional columns:

petroz - 02 March 2011 09:48 PM

I use a callback on the Datatables.net configuration to generate the table on the fly. Add `fnDrawCallback` to attach any javascript function/method to the generation process.

Here is one for adding columns.

Datatables.prototype.addDataColumn = function()
{
  $(”#datatable tr:gt(0)”).append(”<td>View Edit Delete</td>”);
}

or you can also modify the library where I commented:

/*
  add additional columns here
  like adding a Delete Row control for example:

  $aaData[$row_key][] = '<a href="#">Delete Button</a>';
*/ 

Can’t find this commented lines.

Okay. so I guess this will be my last question for this.

Form submit goes to ‘modify_user’ function. Now I want to store the username to a variable and I will do compare. How will I do that?

Okay so I just answered my question.
Thanks again to those who gave inputs.

I got this error, why is this?

check your database configuration. As said on the error, ‘no tables used’

other tables work fine, problem with this function, I am new to use Datatables library.

I will just share you my code

It’s work , thanks…..