Datatables callback/event when empty ajax response

Question

The code below does the following things:

Sends a request to getData.php to get some data.
The spinner is shown when the server-side code is working to retrieve data.
The spinner is hidden when the data has come

My problem is that I don't know how to do to hide the spinner even when no data is coming.

The jquery code:

<script type="text/javascript">

$(document).ready(function() {

    var spinnerOpts = {
      // Options for the spinner here...
      ...   
   };

   var target = document.getElementById('spinn');
   var spinner = new Spinner(spinnerOpts);


    $('#myTable').dataTable( {
       "bProcessing": true,
       "sAjaxSource": "getData.php",
       "fnPreDrawCallback": function() {                    
         spinner.spin(target);    // Show the spinner
       },
       "fnRowCallback": function() {                        
       spinner.stop();   // Hide the spinner
      }

    } );
} );                

</script>

The following code sends a json string from getData.php when there is no data:

echo '{
    "sEcho": 1,
    "iTotalRecords": "0",
    "iTotalDisplayRecords": "0",
    "aaData": []
}';

Oualid · Accepted Answer · 2013-10-21 13:55:29Z

2

I found the solution:

fnDrawCallback: function () {
  var rows = this.fnGetData();
  if ( rows.length === 0 ) {
     spinner.stop();
  }
},

answered Oct 21, 2013 at 13:55

Oualid

4031 gold badge9 silver badges23 bronze badges

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

Comments

Alex Tape · Accepted Answer · 2013-10-19 19:52:08Z

0

you tried to inspect the element

   "fnRowCallback": function( e ) {                        
   console.log(e);   // maybe there is a state of the response in it ;) ?
   spinner.stop();   // Hide the spinner
  }

no time for testing it properly..

answered Oct 19, 2013 at 19:52

Alex Tape

2,3014 gold badges26 silver badges37 bronze badges

Collectives™ on Stack Overflow

Datatables callback/event when empty ajax response

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related