Replies

• PalmoSweet Posts: 13Questions: 0Answers: 0

  September 2022

  I have tried this, but it does not work.

  console.log( $( d[i][3] ).find(":selected").text() );
  
• allan Posts: 63,542Questions: 1Answers: 10,476 Site admin

  September 2022

  <select id='select'>

  This isn't valid HTML - the id attribute must be unique in the document.

  $('#example tbody').on( 'click', 'tr', function () {
    var value = $('select', this).val();
  
    console.log( value );
  });
  

  Will do it. this in that context is the tr element you clicked on and since you only have a single select in it, you can just get that element.

  Allan
• PalmoSweet Posts: 13Questions: 0Answers: 0

  September 2022 edited September 2022

  Hi Allan, unfortunately, this only works with one selection. I try to take all the selected ones and get the info from each row. i do this with a for loop that looks like this. It all happens with a push of a button.

  $('#button').click(function () {
                  //alert(table.rows('.selected').data().length + ' row(s) selected');
                  var d = (table.rows('.selected').data());
                  var length = (table.rows('.selected').data().length);
                  var value = $('select', this).val();
                  /*
                  console.log(d[0][0]);
                  console.log(d[0][1]);
                  console.log(d[0][2]);
                  //console.log( $(d[0][3]).find(":selected").text());
                  console.log( $( '#select' ).find(":selected").text() );
  
                  console.log(d[1][0]);
                  console.log(d[1][1]);
                  console.log(d[1][2]);
                  //console.log( $(d[1][3]).find(":selected").text());
                  console.log( $( '#select' ).find(":selected").text() );
                  console.log(d); */
  
                  for (let i = length; i--;) {
                      console.log(d[i][0]);
                      console.log(d[i][1]);
                      console.log(d[i][2]);
                      console.log( $( '#selection1' ).find(":selected").text() );
                      console.log( value );
                  }
                  
  
              });
  

  in this, for-loop I need to specify which row the value should be taken from which I can't figure out how to do. I changed the id to something different but the same problem.
• allan Posts: 63,542Questions: 1Answers: 10,476 Site admin

  September 2022

  table.rows({selected: true})
  

  will get you the selected rows. Then you could use rows().every() to loop over the rows - e.g.:

  table.rows({selected: true}).every(function () {
    console.log( $('select', this.node()).val() );
  });
  

  Allan
• PalmoSweet Posts: 13Questions: 0Answers: 0

  September 2022

  It works if you want to itarate thru all of them. This is what i try to do. I select the rows i want and i get every signle one of the option in the select elemnt and console.log them in different objects. This is how it looks when i use d[i][3] i = the row.

  Engelska5
  ENGENG05
  100
  <select id="selection1">
  <option value="A">A</option>
  <option value="B">B</option>
  <option value="C">C</option>
  <option value="D">D</option>
  <option value="E">E</option>
  <option value="F">F</option>
  </select>

  And this is how i want it to look like

  Engelska5
  ENGENG05
  100
  A (of i choose antother one that one should be here)

  I do this by looping thru every object in the array but with d[i][3] i get the source code and none of your tips include a parameter of which row it should be applied on which is a cruel part of the syntax that i need. i hope my question got more clear now.

  The problme with your last code is that it returnes all the rows without giving it any place like it should in the for loop
• allan Posts: 63,542Questions: 1Answers: 10,476 Site admin

  September 2022

  I'm afraid I'm just under understanding what you are trying to do. If you need the rest of the data from the row use row().data():

  table.rows({selected: true}).every(function () {
    var data = row.data();
  
    console.log(data[0]);
    console.log(data[1]);
    console.log(data[2]);
    console.log( $('select', this.node()).val() );
  });
  

  Allan
• kthorngren Posts: 21,352Questions: 26Answers: 4,955

  September 2022

  If you want to access the HTML element of a cell use row().node() or maybe better is cell().node(). I built a simple test case based on your example table data.
  http://live.datatables.net/cavawiqu/1/edit

  It uses rows().every() with the selector-modifier of {selected: true}, like Allan suggested. In the loop it uses cells().every() to loop all the cells in the row. If the column contains the select list then it uses cell().node() to get the HTML from the cell. Otherwise it uses cell().data() to get the cell's data.

  Is this what you are looking for?

  Kevin
• PalmoSweet Posts: 13Questions: 0Answers: 0

  September 2022

  Hi Kevin, your example helped me solve it, i just changed the {selected: true} to my ".selceted" class and it is now working exactly how i wanted it to. Thanks alot!
• PalmoSweet Posts: 13Questions: 0Answers: 0

  September 2022

  But i have one more ask, is it possile to get these in to a array variable?

  // Skriver ut all info i konsolen
                      table.rows('.selected').every( function (rowIdx, tableLoop, rowLoop ) {
                          table.cells( $(this), $('td') ).every( function ( rowIdx, colIdx ) {
                              if(colIdx === 3 ) {
                                  var node = this.node();
                                  console.log( $('select', node).val() );
                              } else {
                                  var data = this.data();
                                  console.log(data);
                              }
                          })
                      })
  
  

  so insted of printing it out in console put i inside a varible and then only print once in the console? i need to loop thrue the array to send the info via mysql
• kthorngren Posts: 21,352Questions: 26Answers: 4,955

  September 2022

  You should be able to with Allan's last example. The data variable is an array. You can just replace data[3] with the select value like this:

  data[3] = $('select', this.node()).val();
  

  Kevin
• PalmoSweet Posts: 13Questions: 0Answers: 0

  September 2022

  Hi Kevin, Unfirtantly i only get undefined from that. This is the code and instead of console.log I would like to store every single value in a big array and then log it as one piece once. is that possible?

  table.rows('.selected').every( function (rowIdx, tableLoop, rowLoop ) {
                          table.cells( $(this), $('td') ).every( function ( rowIdx, colIdx ) {
                              if(colIdx === 3 ) {
                                  var node = this.node();
                                  //info[1] = ( $('select', node).val() );
                                  console.log( $('select', node).val() );
                              } else {
                                  var data = this.data();
                                  console.log(data);
                              }
                          })
                          //console.log(info[1]);
                      })
  
• kthorngren Posts: 21,352Questions: 26Answers: 4,955

  September 2022

  i only get undefined from that.

  Right, there is a type in the code. Instead of var data = row.data(); it should be var data = this.data();. Changing row, which is undefined, to this. Here is the updated example building an array of the selected rows.
  http://live.datatables.net/mahuweme/1/edit

  Kevin
• PalmoSweet Posts: 13Questions: 0Answers: 0

  September 2022

  Kevin you are a hero, my problem is now solved thank you alot