how to add custom columns to dataTables with server-side processing?

Question

i have made this example work on my page http://datatables.net/examples/server_side/server_side.html, (using php5, jquery+ui and dataTables.net)

i would like to be able to add a Modify and Delete link on each row, how can i do that without sending two extra columns with the links from the server?

also how can i substitute the ids the rows have in the database and that are sent by the server with nice number starting from 1 till iTotalDisplayRecords...

thank you

it looks like a bad solution to me, sending extra data to every ajax request, sending html code for links, what if path changes one day... it would be simplier if javascript could add it on the fly — max4ever
– max4ever, Commented Jan 18, 2011 at 9:08

max4ever · Accepted Answer · 2011-01-18 10:41:32Z

4

found how

var controller_name = '<?php echo Zend_Controller_Front::getInstance()->getRequest()->getControllerName();?>';


"fnDrawCallback": function ( oSettings ) {
                    /* Need to redo the counters if filtered or sorted */

                        for ( var i=0, iLen=oSettings.aiDisplay.length ; i<iLen ; i++ )
                        {
                            var link = $('&nbsp;<a href="/'+controller_name+'/modifica/id/'+ oSettings.aoData[ oSettings.aiDisplay[i] ]._aData[0]+'">Modifica</a> <a href="/'+controller_name+'/cancella/id/'+ oSettings.aoData[ oSettings.aiDisplay[i] ]._aData[0]+'">Cancella</a>');
                            $('td:eq(0)', oSettings.aoData[ oSettings.aiDisplay[i] ].nTr ).html( i+1 );
                            $('td:eq(0)', oSettings.aoData[ oSettings.aiDisplay[i] ].nTr ).append(link);
                        }
                },

answered Jan 18, 2011 at 10:41

max4ever

12.2k13 gold badges80 silver badges119 bronze badges

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

1 Comment

max4ever Over a year ago

using fnRowCallback is much faster and responsive than fnDrawCallback!!! (when having more than 500rows or stuff) and it doesn't give errors about script not responding

Collectives™ on Stack Overflow

how to add custom columns to dataTables with server-side processing?

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