Answers

• kthorngren Posts: 20,264Questions: 26Answers: 4,764

  September 2019

  Everything seems to be working well until when my table's data is paginated.

  Do you mean you enabled "serverSide: true"?

  May I know how I can get all the value of the checked checkbox across all pages?

  If you have Server Side Processing enabled then the only data available in the client is the data on the page being shown. Would you be able to use client side processing by turning of "serverSide: true"?

  If you don't have server side processing enabled then please provide more details of what you are doing. A link to your page or a test case will help us understand what you have to offer suggestions.
  https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

  Kevin
• fmsthird Posts: 8Questions: 2Answers: 0

  September 2019 edited September 2019

  hi @kthorngren thanks for noticing this one. Actually I have the same issue with this one https://datatables.net/forums/discussion/comment/97682/

  But I'm new to DataTable that's why I don't really understand how to implement the solution. And if possible I want it to be done from PHP, not in Javascript

  Also, I'm developing from my local machine.

  Here's how I defined my DataTable:

  $('#myTable').DataTable({
        "paging":   true,
        "filter":     true,
        "info":     true,
        "select": true,
        "scrollX": true,
        columnDefs: [
          { orderable: false, targets: '_all' }
        ],
        "order":  [[ 2, "desc" ]],
        "language": { search: '', searchPlaceholder: "Search shipment" },
        "sDom": 'fr<"#buttons">ti<"#pagePrevNext"lp>'
      });
  
• kthorngren Posts: 20,264Questions: 26Answers: 4,764

  September 2019 edited September 2019

  Sorry, I'm not a PHP coder but suspect the problem is the same as discussed in the thread you linked. Good find BTW! If you use the browser's inspector you will find that the only rows in the DOM are the rows displayed on the page. Datatables keeps a data cache with all the data. As mentioned by the developer in the other thread you will need to use Dattaables API's to get the checkboxes of all pages.

  Kevin
• fmsthird Posts: 8Questions: 2Answers: 0

  September 2019

  @kthorngren given the code snippet I have above, what would be the adjustments I need to make? How can I use DataTables API's .. ?
  Thanks much
• kthorngren Posts: 20,264Questions: 26Answers: 4,764

  September 2019

  I haven't tried it but did you try the API that the developer posted in the thread you linked to ?

  dataTable.rows().nodes().to$().find('input[type="checkbox"]').each(function(){
  

  Kevin