Search

doesn't work // DataTable var table = $('#example').DataTable({ "columnDefs": [ { className: "first",

What I want to do is get data from two tables in the database and then display that data in a single table with the dataTables plugin using server side processing

Yes. Sorry, I did not include the whole PHP server-side code. echo json_encode( SSP::simple( $_POST, $sql_details, $table, $primaryKey, $columns ) ); It populates my table but with all the records (Key_ID) that exist without pagination. I see all records displayed upfront.

You can try adding wrap to your table class. The Styling doc discusses the default Datatables styles. Kevin

add wrap to your table class. This will allow

I want the same table with export options but

type: 'DELETE', url: 'personnephysique/removeRow?id=_id_' } }, table: "#personne_physique_datatable", idSrc: 'id', fields:

What I need to do is run another query in a different table That's probably not necessary. You need to revise your existing query to incorporate a join to the second table.

this bit is different table .column( $(this).parent().index()+':visible' ) .search( this.value

Correct, it does not show up at all, only when I set it back to db_Workstation.Workstation // Activate the bubble editor on click of a table cell $('#example').on( 'click', 'tbody td:not(:first-child)', function (e) { editor.bubble( this ); } );