my all records not visible
my all records not visible
![dheeru46](https://secure.gravatar.com/avatar/329fe344249bfa5325c8db1569d9fc0d/?default=https%3A%2F%2Fvanillicon.com%2F329fe344249bfa5325c8db1569d9fc0d_200.png&rating=g&size=120)
i have 27000 records but datatable present only 100 records.
i am using codeigniter library.my code is.
$(document).ready(function() {
var table = $('#example').DataTable( {
"processing": true,
//"serverSide": true,
"ajax": "<?php echo base_url(); ?>user_record",
"lengthMenu": [ [10, 25, 50, -1], [10, 25, 50, "All"] ],
"columns": [
{
"class": 'details-control',
"orderable": false,
"data": null,
"defaultContent": ''
},
{ "adata": 0 },
{ "adata": 1 },
{ "adata": 2 },
{ "adata": 3 },
{ "adata": 4 }
],
"bJQueryUI": true,
"oLanguage": {
"sProcessing": "<img src='<?php echo base_url(); ?>media/images/ajax-loader.gif'>"
},
"order": [[1, 'desc']],
"fnRowCallback": function( nRow, aData, iDisplayIndex, iDisplayIndexFull ) {
//$(nRow).css('background', '#E2E4FF')
//$('td:eq(0)', nRow).css('background', '#E2E4FF')
//$('td:eq(0)', nRow).html(''+(iDisplayIndex+1)+'')
//if(iDisplayIndex%2==0)
//{
//$colour="RED";
//}
//else
//{
//$colour="#FFFFFF";
//}
switch(aData[5]){
case '1':
//$(nRow).css('background', $colour)
//$('td:eq(0)', nRow).css('background', $colour)
$('td:eq(5)', nRow).html('<a href="<?php echo base_url()?>home/status/'+aData[0]+'" title="Edit"><i class="fam-user-edit"></i></a> | <a href="<?php echo base_url()?>ring_adminback/home/status/'+aData[0]+'" title="Block"><i class="fam-user-green"></i></a>')
//$('td', nRow).css('color','GREEN')
break;
case '0':
//$(nRow).css('background', $colour)
//$('td:eq(0)', nRow).css('background', $colour)
$('td:eq(5)', nRow).html('<a href="<?php echo base_url()?>home/status/'+aData[0]+'" title="Edit"><i class="fam-user-edit"></i></a> | <a href="<?php echo base_url()?>ring_adminback/home/status/'+aData[0]+'" title="Block"><i class="fam-user-green"></i></a>')
//$('td', nRow).css('color','GREEN')
break;
case '2':
//$(nRow).css('background', '#FFC4D3')Delete
//$('td:eq(0)', nRow).css('background', '#FFC4D3')
$('td:eq(7)', nRow).html('<a href="<?php echo base_url()?>admin_back/update_user_login/'+aData[0]+'" title="Edit"><i class="fam-user-edit"></i></a> | <a href="<?php echo base_url()?>ring_adminback/home/status/'+aData[0]+'" title="Enable"><i class="fam-user-delete"></i></a>')
//$('td', nRow).css('color','Red')
break;
case '3':
//$(nRow).css('background', '#FFC4D3')Delete
//$('td:eq(0)', nRow).css('background', '#FFC4D3')
$('td:eq(7)', nRow).html('<a href="<?php echo base_url()?>admin_back/update_user_login/'+aData[0]+'" title="Edit"><i class="fam-user-edit"></i></a> | <a href="<?php echo base_url()?>ring_adminback/home/status/'+aData[0]+'" title="Enable"><i class="fam-user-delete"></i></a>')
//$('td', nRow).css('color','Red')
break;
}
}
} );
// Add event listener for opening and closing details
$('#example tbody').on('click', 'td.details-control', function () {
var tr = $(this).closest('tr');
var row = table.row( tr );
if ( row.child.isShown() ) {
// This row is already open - close it
row.child.hide();
tr.removeClass('shown');
}
else {
// Open this row
row.child( format(row.data()) ).show();
tr.addClass('shown');
}
} );
} );