Answers

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

  May 2020

  Are you inserting the row with Editor? Are how is the SQL making it's way into the table?

  Colin
• rodrigoasn Posts: 5Questions: 1Answers: 0

  May 2020 edited May 2020

  <table id="tabela_itens" class="table table-striped table-hover table-responsive-sm table-sm" style="width: 100%">
                      <thead style="width: 100%">
                        <tr>  
                          <th data-orderable="false">
                          <div class="custom-control custom-checkbox">
                           <input type="checkbox" class="custom-control-input">      
                          </div>
                          </th>
                          <th data-orderable="false">Checar</th>  
                          <th data-orderable="false">Alterar</th>
                          <th data-orderable="false">Deletar</th>
                          <th>Código</th>
                          <th>Classe</th>  
                          <th>Subclasse</th>  
                          <th>Fabricante</th>
                          <th>Referência</th>
                          <th>Situação</th>
                        </tr>
                      </thead>
                      <tbody>
                        <?php 
                          $equip->getEquipamentoTable();
                        ?>  
                      </tbody>
                      <tfoot>
                          <tr>
                              <th></th>
                              <th></th>
                              <th></th>
                              <th></th>
                              <th></th>
                              <th></th>
                              <th></th>
                              <th></th>
                              <th></th>
                              <th></th>
                          </tr>
                      </tfoot>
                    </table>
  

  This is the HTML code of my table.
  Inside of the HTML code i call a PHP function that write the rows of the table with a SELECT.

  public function getEquipamentoTable(){
      $query = mysqli_query($this->con->getCon(), "SELECT * FROM TABLE");
  
      while($dados = mysqli_fetch_array($query)){
             <td class='pt-2'>$dados[nu_item]</td>
         <td class='pt-2 text-uppercase'>$dados[te_classe]</td>
         <td class='pt-2 text-uppercase'>$dados[te_subclasse]</td>
         <td class='pt-2 text-uppercase'>$dados[te_fabricante]</td>
         <td class='pt-2 text-uppercase'>$dados[te_referencia_modelo]</td>
             ...
      }
  }
  

  As you can see i draw the rows of the table with a while.
  so i use like that and works perfectly and i would like to keep like that!

  Are you inserting the row with Editor?
  no, i am using the free version of datatable for a while.
  I created a submit button that after fill all the form i just press it and serialize with javascript. After that i call a php class and insert on database.

  After the inserssion i just need that the datatable refresh to show the new row/data
• kthorngren Posts: 21,327Questions: 26Answers: 4,949

  May 2020

  What I would to is insert the new row then fetch the row from the DB and return just that row to the client. In the ajax success you can then take the returned row and use row.add() to add it to the Datatable. This is essentially what the Editor would do.

  Kevin
• rodrigoasn Posts: 5Questions: 1Answers: 0

  May 2020

  This is my code that call the inserssion
  i did like you said..
  i save all the form data in variables and after i call a PHP insert file that make connection to a class and DB to insert in DB.

  and the return of it i take on ajax success.

  So, can i draw a row into my table with function row.add() without use ajax json?

  $(function($) {
      
      $(document).on('submit','#formCadastro',function(event){
          
          //PREVINE O REFRESH
          event.preventDefault();
      
          //CRIA VARIÁVEIS
          var dados         = $(this).serialize();
          var nu_item       = $("#nu_item").val();
          var id_subclasse  = $('select[name=id_subclasse]').val();
          var te_referencia = $('#te_referencia_modelo').val();
          var id_fabricante = $('select[name=id_fabricante]').val();
          var flag_ativo    = $("input[name='flag_ativo']:checked").val();
          var obs_material  = $('#obs_material').val();
          var id_usuario    = $('#id_usuario').val();
          
          //CHAM FUNÇÃO PARA CONFERIR SE A DESCRIÇÃO FOI DIGITADA
          var conferido = confereForm();
              
          if(conferido == true){
                  
              $("#sucessMsg").removeClass("col-12 alert alert-warning text-center mb-5 invisible").addClass("col-12 alert alert-warning text-center mb-5");
              
              $.ajax({
                  url: 'dist/insert_equipamento.php?nu_item='+nu_item+'&id_subclasse='+id_subclasse+'&te_referencia='+te_referencia+'&id_fabricante='+id_fabricante+'&flag_ativo='+flag_ativo+'&obs_material='+obs_material+'&id_usuario='+id_usuario,
                  type: 'post',
                  data: dados,
                  success: function(resposta){
                      
                      if(resposta){
  
                          setTimeout(function() {
                              $("#sucessMsg").html("<i class='fas fa-check'></i> Equipamento cadastrado com sucesso!").fadeIn();
                          }, 100 );
                          setTimeout(function() {
                              $("#sucessMsg").fadeOut();
                              location.reload();
                          }, 2500 );  
  
                      }
                      
                  }
  
              });
      
          }
          
      });
      
  });
  
• kthorngren Posts: 21,327Questions: 26Answers: 4,949

  May 2020

  So, can i draw a row into my table with function row.add() without use ajax json?

  Of course. You can use row.add() at any point. The purpose of the above set of steps is that the user will see exactly what was inserted into the DB. If you don't need that then simply just use row.add().

  Kevin