Answers

• kthorngren Posts: 21,344Questions: 26Answers: 4,954

  April 22

  See this FAQ. Here is a simple example:
  https://live.datatables.net/huyexejo/1925/edit

  It derives the column names from the object keys in the row data. You could return a specific object with the column header names. Use columns.title to define the header names.

  Kevin
• gmstephane Posts: 11Questions: 5Answers: 0

  April 22

  Hello kthorngren
  Thank you for your quick reply. it put me on the right track.
  But one more, in the example https://live.datatables.net/huyexejo/1925/edit is there a particular format of the json data to be used in the javascript?
  here is a sample of the code

          $rank= 1;
  
          $code_selected =$_SESSION['code'];
          
          $sql_da2 = "SELECT * FROM `donnees` WHERE `id_source`='$code_selected'";
          $rs_da2 = $conP_bdcc->query($sql_da2);
  
          $data = array();
          $annees_inventaire = 2022;
          $annees_temporelles=1990;
  
  while ($row_da2 = $rs_da2->fetch_assoc()) {
  
      $data[] = array(
          "rank" => $rank,
          "annee_inv" => $annees_inventaire,
          "annee_tempo" => $annees_temporelles,
          "code" => $_SESSION['code'],
          "valeur" => $row_da2['valeur'],
          "unit" => $row_da2['unit'],
          "libelle" => $_SESSION['libelle']
      );
  
      $rank++;
  }
  
  
          $datax = array('data' => $data);
          echo json_encode($datax);
  
  
• kthorngren Posts: 21,344Questions: 26Answers: 4,954

  April 22

  The Ajax docs provide details of what Datatables expects for the row data. The example I provided simply uses the first object in the array to build the column headers from the object keys.

  If this doesn't do what you want you can return the header names in a different object along side the data object. Since this is something you are adding and Datatables doesn't use it you can return any format that works for your solution.

  Kevin