Answers

• bindrid Posts: 730Questions: 0Answers: 119

  April 2018

  The data in the link is an array of arrays so datatables just takes them in the order they are given.
  Your data is an array of objects so you have to map your data to columns.

  take a look at https://datatables.net/examples/ajax/objects.html it shows an example
• dydx Posts: 8Questions: 3Answers: 0

  April 2018

  @bindrid Got it!
  Now, there's just one issue.. How do I get this prefix: "data":[ in my JSON?
  Currently my PHP looks like this:

  public function findAll()
  {
  $result = $this->query('SELECT * FROM ' . $this->table);
  return $result->fetchAll(PDO::FETCH_ASSOC);
  }

  $designsTable = new CRUD($pdo, 'design', 'id');
  $result = $designsTable->findAll();
  echo json_encode($result);

  which generates the JSON I mentioned in my OP.
  And thanks for that help, though! Just hoping you could get me sorted on this as well
• allan Posts: 63,208Questions: 1Answers: 10,415 Site admin

  April 2018 Answer ✓

  You can use the ajax.dataSrc option set to be an empty string to tell DataTables just to read a plain array of data.

  Alternatively, in PHP you could do:

  echo json_encode( [
    "data" => $result
  ] );
  

  Allan
• dydx Posts: 8Questions: 3Answers: 0

  April 2018

  Thanks so much, Allan and bindrid!!!