Answers

• colin Posts: 15,238Questions: 1Answers: 2,599

  March 2018

  Hi @darkstaring

  Because the data contains an array of objects, you need to define the source of the data - see this example here.

  So you'll need something like this:

  $('#lista').DataTable({
      "columns": [
          { "data": "id" },
          { "data": "nome" },
          { "data": "cognome" },
          { "data": "cf" },
          { "data": "predefinito" }
      ],
      "ajax": {
          "url": "<?php echo $myurl;?>/<?php echo $myadmin_api;?>/get",
          "dataSrc": "anagrafica"
      }
  });
  

  Cheers,

  Colin
• darkstaring Posts: 9Questions: 2Answers: 1

  March 2018

  Thank you @colin now works
• darkstaring Posts: 9Questions: 2Answers: 1

  March 2018 edited March 2018

  I have another question.....
  Ajax

      $('#lista_pazienti').DataTable( {
          "columns": [
                  { "data": "nome" },
                  { "data": "cognome" },
                  { "data": "cf" },
                  {
                  "data": null,
                  "defaultContent": "<button class='btn btn-primary' onclick='modifica_paziente();'><i class='fa fa-pencil'>&nbsp;</i></button> \
                                     <button class='btn btn-danger' onclick='delete_anagrafica();' ><i class='fa fa-times'>&nbsp;</i></button>"
                  }
              ],
              "ajax": {
              "url": "<?php echo $myurl;?>/<?php echo $myadmin_api;?>/get_GE_anagrafica",
              "dataSrc": "anagrafica"
              }
      });
  

  how can I pass the argument ID to the function
  modifica_paziente, delete_anagrafica
• colin Posts: 15,238Questions: 1Answers: 2,599

  March 2018

  Hi again,

  Take a look at this example. This is similar to your goal - to have a clickable control within a cell. Here, the event listener works out which rows the cell is on.

  Cheers,

  Colin
• darkstaring Posts: 9Questions: 2Answers: 1

  March 2018

  I do not understand..
• darkstaring Posts: 9Questions: 2Answers: 1

  March 2018

  any help?
• allan Posts: 63,332Questions: 1Answers: 10,436 Site admin

  March 2018

  I would suggest that you don't use a DOM0 event, instead use a jQuery event listener like in this example.

  Allan
• darkstaring Posts: 9Questions: 2Answers: 1

  March 2018

  Now i write this...

  var table = $('#lista_pazienti').DataTable( {
      "columns": [
              { "data": "nome" },
              { "data": "cognome" },
              { "data": "cf" },                
              {
                  "className":      'modifica',
                  "orderable":      false,
                  "data":           null,
                  "defaultContent": "<button id='btn_modifica' class='btn btn-primary'><i class='fa fa-pencil'>&nbsp;</i></button>"
              }
          ],
          "ajax": {
          "url": "<?php echo $myurl;?>/<?php echo $myadmin_api;?>/get_GE_anagrafica",
          "dataSrc": "anagrafica"
          }
  });
  
  
  
      $('#lista_pazienti tbody').on('click', 'btn_modifica', function () {
      var data = table.row( this ).data();
      console.log(data);
      //alert( 'You clicked on '+data[0]+'\'s row' );
  } );
  

  But not work
• darkstaring Posts: 9Questions: 2Answers: 1

  March 2018 Answer ✓

  Now work's

      $('#lista_pazienti tbody').on('click', '#btn_modifica', function () {
      var tr = $(this).closest('tr');
      var data = table.row(tr).data();
      console.log(data);
      });