Datatables format data output

Question

i m using datatables w/ server-side processing, everything work perfect, but i dont know how i can use a php function on data output.

i have this code

$('#exampless').dataTable({

  "bProcessing": true,
    "bServerSide": true,

    "sAjaxSource": "data/load-anunciantes.php",     

     "columnDefs": [ {
        "targets": -2,
        "data": 7, // STATUS 1 or 0

    } ]



} );

the column 7 return 1 or 0 its fine but i want to do something like this.

on php i was doing

status($status);

if status = 1 i return <label class=\"green\">Active</label> and

if status = 0 i return <label class=\"red\">Inactive</label>

Thanks for any advice.

markpsmith · Accepted Answer · 2014-12-11 15:11:02Z

1

You need to use render or mRender (depending on which version of datatables you're using):

"columnDefs": [ {
"render": function ( data, type, row ) {
    if(row[7] == 1){
        return '<label class=\'green\'>Active</label>';
    }else{
       return '<label class=\'red\'>Inactive</label>';
    }
 },

answered Dec 11, 2014 at 15:11

markpsmith

4,9182 gold badges38 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Alvaro Louzada Over a year ago

Thanks Dude, i was going on this solution i found andersontorres.com.br/hacks-e-outras-coisas/… thanks

Collectives™ on Stack Overflow

Datatables format data output

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related