Answers

• Neicul Posts: 6Questions: 3Answers: 0

  March 2016

  Datatables needs a format like this:

  {
  "data":[
  {
  "message":"This is a message",
  "ticket":"This is a ticket",
  ...
  }
  ]
  }
• Karkuro Posts: 7Questions: 5Answers: 0

  March 2016 edited March 2016

  I modified my method a bit.

  This is my array :

     $arrayMess['data'][] = array('date' => $value->date ,'dest' => $value->recname." ".$value->recfirstname, 'message' => $value->message, 'exp' => $value->expname." ".$value->expfirstname);
  

  When I json_encode it, and echo it, I get that :

  {  
     "data":[  
        {  
           "date":"2016-03-04 15:33:15",
           "dest":"Dias Marco",
           "message":"ztest",
           "exp":"Dias Marco"
        },
        {  
           "date":"2016-03-04 15:33:15",
           "dest":"Dias Marco",
           "message":"ztest",
           "exp":"Dias Marco"
        },
  

  So it seems to be good now ?

  The thing is I try to put it in my dataTable like this :

  $('#datatable').DataTable( {
          "ajax": "<?php echo $arrayMess; ?>",
          "columns": [
              { "data": "date" },
              { "data": "dest" },
              { "data": "message" },
              { "data": "exp" }
          ]
      } );
  

  And I get on Firebug (Firefox extension) :

  SyntaxError: missing } after property list
      
  
  "ajax": "{"data":[{"date":"2016-03-04 15:33:15","dest":"Dias Marco","me
  
• Neicul Posts: 6Questions: 3Answers: 0

  March 2016

  I'm pretty sure that's just a syntax error.
  You're echoing that script form a PHP file, right?
  Watch your quotation marks
• Karkuro Posts: 7Questions: 5Answers: 0

  March 2016 edited March 2016

  Yes it's a .php file, the javascript is in the same file actually since it's the view of one of my pages. I'm gonna try to look into the quotation marks, hopefully it's the problem.