Search

var table = new DataTable('#example', { stateSave: true, stateSaveParams: function(settings, data) { // Keep only length (entries per page); remove all other state Object.keys(data).forEac

new DataTable('#example', { columnControl: ['order', ['search', 'searchList']], ordering: { indicators: false, handler: false }, stateSave: true });

$('#example').DataTable().state();

$('#example').DataTable().rows().deselect();

Do you have the raw SQL for what you want? If so, can you show me that?

DataTable.defaults.columnTitleTag = 'div'; new DataTable('#example');

$("#example").DataTable({ columns: [...], columnControl: [ "order", [ 'searchClear', { 'search' } ] ], serverSide: true, ajax: { url: '/ajax/data', contentType:

new DataTable('#example', { ajax: '../php/staff.php', columns: [ { data: null, render: (data) => data.first_name + ' ' + data.last_name },

I added columns.title to populate the header after the $('#example').empty(); statement.

var table = $('#example').DataTable(); // Initialize your DataTable

var table = $('#example').DataTable(); // Initialize your DataTable DataTable('#example', { createdRow: function(row, data, dataIndex) { // Assign a sequential ID starting from 1

DataTable('#example', {

$('#example tbody tr').removeClass('red-odd'); $('#example tbody tr td:nth-child(odd)').addClass('red-odd'); }

drawCallback: function () { $('#example tbody tr').removeClass('odd'); $('#example tbody tr:even').addClass('red-odd'); }

$('#update-class').on('click', function () { $('#example tbody tr').removeClass('odd'); $('#example tbody tr:odd').addClass('my-odd') });

$('#example tbody tr').removeClass('odd');

drawCallback: function () { $('#example tbody tr').removeClass('odd'); $('#example tbody tr:odd').addClass('odd') }

var table = $('#example').DataTable().on('click', 'tbody td:last-child', function (e) { table.editor().inline(this, 'permission[].id'); });

limit: 4 } ], table: '#example' }); $('#example').DataTable({ ajax: { url: '../../controllers/joinArray.php', type: 'POST' }, columns: [

$("#example").mark("R*os", { wildcards: "enabled", caseSensitive: true });