Answers

• kthorngren Posts: 21,231Questions: 26Answers: 4,929

  February 2019

  First you would tell Datatables which column you want to use for the row ID using rowId. In your button click event you would use rows().ids() to get the row IDs and use the toArray() API to place them in an array. In order to get the IDs of the rows in the search result you would use the selector-modifier of {search: 'applied'}.

  Here is a simple example based on your example data:
  http://live.datatables.net/jehiqafu/1/edit

  Kevin
• muuucho Posts: 7Questions: 2Answers: 0

  February 2019

  Thanks a lot! It looks great.
  After the click, I like to do a redirect to a PHP controller that saves the array to a database and then display another page. Something like:

  $('button').on('click', function () {

          var ids = table.rows({search: 'applied'}).ids().toArray();
          console.log(ids);
  
          // Create object containing the array of IDs
          var dataObject = { data: ids };
  
          // Send object via POST request to server
          $.ajax({
              type: "POST",
              data: dataObject,
              url: "<?=base_url('panel/another_page');?>",
              success: function(msg) {
                  console.log("Success: " + msg);
                  window.location.href = "<?=base_url('panel/another_page');?>";
              },
              error: function(err) {
                  console.log("Error sending data to server: " + err);
              }
          });
      })
  

  The PHP Controller:
  function another_page()
  {
  $array = $_POST(ids);
  // Do whatever with the array...
  $this->load->view('another_page');
  }

  However, this doesn't work.
• kthorngren Posts: 21,231Questions: 26Answers: 4,929

  February 2019

  However, this doesn't work.

  What is happening?

  Do you get errors in your browsers console?

  Are you getting the IDs correctly?

  Kevin