Datatable and json data - does not work

JavaScript
1

Hi guys

data.json

[{“id”:“1”,“name”:“afes”,“company”:“sdfsatre”,“city”:“5”},{“id”:“2”,“name”:“ste”,“company”:“ser”,“city”:“1”},{“id”:“3”,“name”:“sdfdsfsd”,“company”:“sdfdsfsd”,“city”:“1”},{“id”:“4”,“name”:“asdsad”,“company”:“asdsada”,“city”:“3”},{“id”:“5”,“name”:“aaa”,“company”:“bbb”,“city”:“8”},{“id”:“6”,“name”:“sdfsfdsf”,“company”:“sdfdsfsd”,“city”:“4”},{“id”:“7”,“name”:“ss”,“company”:“ssd”,“city”:“4”}]

jquery datatable

<script>
$(document).ready(function() {
    $('#example').DataTable( {
        "ajax": 'data.json'
    } );
} );
</script>

TypeError: f is undefined
…a,,function(c){var f=sa(a,c);for(b=0;b<f.length;b++)N(a,f[b]);a.iInitDisplaySt…

Whats wrong folks?

2

I stab a guess at the HTML table headers.

3

after some reading i found a disturbing quote. sorry i lost that link of statckexchange.

it said, datatables is expecting a data in a json pattern, but json.encode() function does not format the data to that pattern. that is the problem it said.

DATA TABLE EXPECTS

{
“data”: [
[
“Tiger Nixon”,
“System Architect”,
“Edinburgh”,
“5421”,
“2011/04/25”,
“$320,800”
],
[
“Garrett Winters”,
“Accountant”,
“Tokyo”,
“8422”,
“2011/07/25”,
“$170,750”
],
[
“Donna Snider”,
“Customer Support”,
“New York”,
“4226”,
“2011/01/25”,
“$112,000”
]
]
}

PHP encode.json() format is as follows

[{“id”:“1”,“name”:“afes”,“company”:“sdfsatre”,“city”:“5”},{“id”:“2”,“name”:“ste”,“company”:“ser”,“city”:“1”},{“id”:“3”,“name”:“sdfdsfsd”,“company”:“sdfdsfsd”,“city”:“1”},{“id”:“4”,“name”:“asdsad”,“company”:“asdsada”,“city”:“3”},{“id”:“5”,“name”:“aaa”,“company”:“bbb”,“city”:“8”},{“id”:“6”,“name”:“sdfsfdsf”,“company”:“sdfdsfsd”,“city”:“4”},{“id”:“7”,“name”:“ss”,“company”:“ssd”,“city”:“4”}]

4

So you need to provide you data in required format
It is not about encoding

5

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.