Answers

• allan Posts: 63,350Questions: 1Answers: 10,443 Site admin

  February 2017

  ajax.data will let you send parameter to the server.

  Allan
• daguerfi Posts: 6Questions: 3Answers: 0

  February 2017 edited February 2017

  Thanks Allan, But how to read the data in the server side, I tried both Post and Get parameters with no luck. Is this how to use the data option?

          "data": function ( d ) {
                 d.table_name = $('#table_id').val();
           
              }
  
  

  How to read the posted data on the server-side? many thanks.

  // DB table to use
  $table = $_GET['table_name']
  
• allan Posts: 63,350Questions: 1Answers: 10,443 Site admin

  February 2017 Answer ✓

  d.table_name = $('#table_id').val();

  If your #table_id was an input element that returns a value, then yes. My guess is that that is actually your table and thus it won't have a value.

  How to read the posted data on the server-side?

  You've specifically marked it as POST so you would use $_POST['myVariable'] in PHP.

  Allan
• daguerfi Posts: 6Questions: 3Answers: 0

  February 2017 edited February 2017

  Thanks Allan, It worked like a charm God Bless.

  Please one last question if you have a time, how to reload the table with a new ajax call with the same columns, without getting this error 'Cannot Reinitialise Datatable'. I tried the 'destroy' option but I can't figure it out how to refill the table again.
  many thanks.
• allan Posts: 63,350Questions: 1Answers: 10,443 Site admin

  February 2017

  If you are getting that error, then you aren't destroying the table. You might want to use $.fn.dataTable.isDataTable() to check if a table is actually a DataTable or not before destroying it.

  Allan
• daguerfi Posts: 6Questions: 3Answers: 0

  February 2017

  Ok, I have managed to get it work, Allan thank you very much.

  Here's the entire ajax call code for those who's struggling.

  <script type="text/javascript" class="init">
      $(document).ready(function() {
  
          // check if button is clicked - remove this if not needed
          $('#load_db').click(function() {
  
              // check if table is a DataTable then destroy old one
              var table = $('#tb-data').DataTable();
              if ($.fn.dataTable.isDataTable('#tb-data')) {
                  table.destroy();
              }
  
              // call new datatable and post additional data
              $('#tb-data').DataTable({
                  "processing": true,
                  "serverSide": true,
                  "ajax": {
                      "url": 'server_processing.php',
                      "data": {
                          "table_id": $('#table_id').val()
                      }
                  }
              });
  
              return false;
          });
  
      });
  </script>
  

  I also was having an issue when sorting numbers, they weren't sorting correctly, then later I figure out that I was storing them as a string in database instead of integers (INT).

  Hope It's helps someone.
• allan Posts: 63,350Questions: 1Answers: 10,443 Site admin

  February 2017

  That's the business! There is actually one other option that is a little more efficient - using ajax.url.reload() on an already initialised table and using ajax.data as a function so it will get the value every time it is submitted:

  <script type="text/javascript" class="init">
      $(document).ready(function() {
   
          // check if button is clicked - remove this if not needed
          $('#load_db').click(function() {
   
              // check if table is a DataTable then destroy old one
              var table = $('#tb-data').DataTable();
              if ($.fn.dataTable.isDataTable('#tb-data')) {
                   $('#tb-data').DataTable().ajax.reload();
              }
              else {
                // call new datatable and post additional data
                $('#tb-data').DataTable({
                    "processing": true,
                    "serverSide": true,
                    "ajax": {
                        "url": 'server_processing.php',
                        "data": function ( d ) {
                            d.table_id: $('#table_id').val();
                        }
                    }
                }
              });
   
              return false;
          });
   
      });
  </script>
  

  Allan