Answers

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

  November 2020

  atm I have my code working fine, but I'm getting at a point where I need to have dynamic data values.

  I'm not clear what the problem is with your code, or what you're trying to achieve? Please can you elaborate and give more information.

  Colin
• Alpha.Ars Posts: 5Questions: 1Answers: 0

  November 2020

  Yes for sure, What I tried to explain was. I'm trying to get a datatable that shows all my
  db rows ( ex. if I'm adding a new value in my db, I'm expecting it to show my new value) Right now it's only showing the value's prensent during the fetch.
• colin Posts: 15,240Questions: 1Answers: 2,599

  November 2020

  You should just be able to call ajax.reload() to get the updated data from the db,

  Colin
• Alpha.Ars Posts: 5Questions: 1Answers: 0

  November 2020

  Ok perfect and where should I write this ?
  It's the first time I'm using it and I really not sure
• kthorngren Posts: 21,342Questions: 26Answers: 4,954

  November 2020

  if I'm adding a new value in my db, I'm expecting it to show my new value)

  Guessing you are using jQuery ajax to save the data to the database. In the success function of the ajax request is where you would use ajax.reload().

  Basically it will go into the success callback of whatever method you are using to save the data.

  Kevin
• Alpha.Ars Posts: 5Questions: 1Answers: 0

  November 2020 edited November 2020

  I tried adding the function, and now
  my is looking like that: (still not working)

  <script type="text/javascript" language="javascript" >
  $(document).ready(function(){
  
   var dataTable = $('#sample_data').DataTable({
    "processing" : true,
    "serverSide" : true,
    "order" : [],
    "ajax" : {
     url:"fetch.php",
     type:"POST"
    }
   });
  
   setInterval( function () {
    dataTable.ajax.reload();
  }, 3000 );
  
   $('#sample_data').on('draw.dt', function(){
    $('#sample_data').Tabledit({
     url:'action.php',
     dataType:'json',
     columns:{
      identifier : [0, 'id'],
      editable:[[5, 'auto_start', '{"0":"No","1":"Yes"}']]
     },
     restoreButton:false,
     onSuccess:function(data, textStatus, jqXHR)
     {
      if(data.action == 'delete')
      {
       $('#' + data.id).remove();
       $('#sample_data').DataTable().ajax.reload();
      }
     }
    });
   });
    
  }); 
  </script>
  

  and you can find my fetch linked above
• kthorngren Posts: 21,342Questions: 26Answers: 4,954

  November 2020

  Did you add the setInterval function to try fixing this issue? Unless you want to refresh the table every 3 seconds you should remove it.

  You will probably want to use $('#sample_data').DataTable().ajax.reload( null, false ); to stay on the same page. You have this in line 32 of the above code but it looks like it is only executed when deleting a row.

  The Tabledit() library is not a Datatalbes library and I'm not familiar with how it works. Seems like you will want to execute $('#sample_data').DataTable().ajax.reload( null, false ); in the onSuccess function all the time not just for deletes. Move it outside the if statement or remove the if and just have $('#sample_data').DataTable().ajax.reload( null, false ); . You will need to refer to the Tabledit() docs for more specifics about the onSuccess function and if there is a different callback to use.

  When using ajax.reload() the server code will return the page of data requested based on the page number and sorting. The edited data may or may not be on this page.

  Kevin
• Alpha.Ars Posts: 5Questions: 1Answers: 0

  November 2020

  Hi Kevin

  thanks for trying to help me, I'm still not getting the extpected result.
  Just to be sure, I just want to have the table showing the exact same values as in the sql, so if a row is deleted it will get awat from the table.

  kinda like this

  data.php

  <?php 
  $conn = new mysqli('localhost', 'username', 'password', 'table');
  if ($conn->connect_error) {
      die("Connection error: " . $conn->connect_error);
  }
  $result = $conn->query("SELECT * FROM users");
  if ($result->num_rows > 0) {
      while ($row = $result->fetch_assoc()) {
          echo $row['last_name'] . '<br>';
      }
  }
  
  <?php
  >
  ?>
  
  
  

  index.php:

  <!DOCTYPE html>
  <html>
  <head>
      <meta charset="utf-8">
      <meta http-equiv="X-UA-Compatible" content="IE=edge">
      <title></title>
      
  </head>
  <body>
      <div id="show"></div>
  
      <script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
      <script type="text/javascript">
          $(document).ready(function() {
              setInterval(function () {
                  $('#show').load('data.php')
              }, 1000);
          });
      </script>
  </body>
  </html>