Answers

• kthorngren Posts: 21,303Questions: 26Answers: 4,947

  January 2023

  There are many ways this can be done. A common way is to load the table data from the server using Ajax. See the Ajax docs for details. There are Ajax examples you can look at.

  Its best to ask more specific questions and to provide basic information of your environment.

  Kevin
• lupomeo Posts: 6Questions: 2Answers: 0

  January 2023

  Yes i have seen the examples but my problem is that when i use ajax with this code the data are succesfully inserted in the table BUT the table don't display the pages, display the wrong nuber of items, and lose the search input.

  function view_data(){
  $con = connection();
  $query = "SELECT * FROM tipologie";
  $result = mysqli_query($con, $query);

  if(mysqli_num_rows($result)){
      while($row = mysqli_fetch_assoc($result)){
      $table .= '<tr>';
      $table .= '<td>' . $row['descrizione'] . '</td>';
      $table .= '<td>' . $row['ore'] . '</td>';
      $table .= '<td>' . $row['validita'] . '</td>';
      $table .= "<td style='text-align:center'><a data-id='" . $row['id'] . "' data-toggle='modal' data-target='#editModal' href='' id='update' class='edit'>
      <i class='fa fa-edit'></i></a>  <a data-id='" . $row['id'] . "' class='delete' id='delete' href='' data-toggle='modal' data-target='#deleteModal'><i class='fa fa-trash'></i></a> </td>";
      $table .= '</tr>';
      }    
      echo json_encode(['status'=>'success', 'table' => $table]);
  } else {
      $table .= '<tr colspan="8"';
      $table .= '<td>NO DATA!</td>';
      echo json_encode(['status' => 'success', 'table' => $table]);
  }
  

  }
• kthorngren Posts: 21,303Questions: 26Answers: 4,947

  January 2023

  If you are populating the HTML table data this way then don't use ajax. Read about the supported Data Sources. Looks like you will want to initialize using DOM sourced data. See this example.

  Kevin
• lupomeo Posts: 6Questions: 2Answers: 0

  January 2023

  Anyone else that can really help ?
• allan Posts: 63,464Questions: 1Answers: 10,466 Site admin

  January 2023

  I think Kevin's answer is spot on (as they always are).

  Maybe we should take a step back - first of all: how do you want to populate the table's data? Via Ajax? If so, don't have the Ajax response return HTML for the table rows. Let DataTables do that for you! Reply to the Ajax request with JSON - e.g.:

  $data[] = [
    'descrizione' => $row['descrizione'],
    'ore' => $row['ore'],
    ...
  ];
  

  Then:

  echo json_encode([
    'data' => $data
  ]);
  

  Then you can populate your DataTable in the say way as this example.

  See this section of the manual for more details on this.

  Allan