my all records not visible

my all records not visible

dheeru46dheeru46 Posts: 4Questions: 3Answers: 0

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');
    }
} );

} );

This discussion has been closed.