Datatables - add rows with PHP

Question

I have an issue with jquery and datatables. I want to get the informations for the datatable from an mysql database with PHP and after that update the datatable with this informations.

I already tried it with something like this:

var datatable = $("#example").DataTable();
$.get('load_session_overview.php', function(newDataArray) {
     //datatable.clear();
     datatable.row.add(['Random','12','18','Menu']);
     datatable.row.add([newDataArray]);
     datatable.draw();
});

The first line with the add is working fine, but I don't know how to format the data in the php script correctly.

And if I'm getting more rows from the php script how can I add them all the the table?

Thanks, Phil

How do you currently try to format them ? In this an inpage data or an XHR request ? — challet
– challet, Commented Jan 15, 2023 at 11:37
Inpage data - I already tried following options: $string = "'SR Reload','95','112','MenuItems'"; and $string = array('SR Reload','95','112','MenuItems'); or also tried the json_encode — PhilT
– PhilT, Commented Jan 15, 2023 at 11:46

Frederik Wordenskjold · Accepted Answer · 2023-01-15 11:48:29Z

One way to format the data correctly in your PHP script is to return it in a JSON format. You can use the json_encode() function in PHP to convert your data into a JSON string.

For example:

<?php
$data = array(
array('Random','12','18','Menu'),
array('Data1','13','19','Menu2'),
array('Data2','14','20','Menu3')
);
echo json_encode($data);
?>

Then, in your jQuery code, you can use the JSON.parse() method to convert the JSON string into a JavaScript object, and loop through the data to add each row to the table.

$.get('load_session_overview.php', 
 function(newDataArray) {
  var data = JSON.parse(newDataArray);
  for(var i = 0; i < data.length; i++) {
    datatable.row.add(data[i]);
  }
  datatable.draw();
});

Alternatively, you can use ajax call and pass the data to it to load it in the datatable and also you can use the ajax call to update the datatable as well.

$.ajax({
 url: "load_session_overview.php",
 type: "GET",
 dataType: "json",
 success: function (data) {
   datatable.clear();
   datatable.rows.add(data);
   datatable.draw();
 }
});

This way you can load the data in the datatable and also update it as well.

challet · Accepted Answer · 2023-01-15 12:05:19Z

0

There are several ways to achieve this, for instance

php writes javascript code in an html script tag

see How to print JSON array inside script tag?

XHR request

see Displaying JSON data in HTML

answered Jan 15, 2023 at 12:05

challet

99010 silver badges22 bronze badges

Collectives™ on Stack Overflow

Datatables - add rows with PHP

2 Answers 2

Comments

php writes javascript code in an html script tag

XHR request

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

php writes javascript code in an html script tag

XHR request

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related