jQuery Datatable with PHP json_encode

Question

I tried to parse database table data to jquery data table which are dynamically change. I got following output after php's json_encode function

$sql = "SELECT * FROM login";

$result = mysql_query($sql);
$a= array();
while ($row = mysql_fetch_assoc($result)) {
$a[][] = $row;
    }

    echo (json_encode($a));

Json output

[[{"id":"1","username":"test11","password":"$2y$10$NiKnEN\/ww8yGVhv3JNjSuO5FfOFSthadS2B3GcbA3KGBktAOSu6lK","role":"Administrator "}],[{"id":"2","username":"test","password":"test","role":"test"}]]

Then I called jquery data table ajax function as they said. here my coding for that

 $('#example').dataTable( {
        "ajax": 'ab.php'
    } );

But ultimately display only "Loading..." text in the jquery data table tbody section. Why is that?

What is the problem then ?

Pratik Joshi
– Pratik Joshi

2015-03-15 16:13:55 +00:00
Commented Mar 15, 2015 at 16:13 — Pratik Joshi
– Pratik Joshi, Commented Mar 15, 2015 at 16:13
jquery datatable is not getting data from php file

Top25
– Top25

2015-03-15 16:14:35 +00:00
Commented Mar 15, 2015 at 16:14 — Top25
– Top25, Commented Mar 15, 2015 at 16:14
What console error you get in Browser's console ?

Pratik Joshi
– Pratik Joshi

2015-03-15 16:24:09 +00:00
Commented Mar 15, 2015 at 16:24 — Pratik Joshi
– Pratik Joshi, Commented Mar 15, 2015 at 16:24
" TypeError: f is undefined " @jQuery.PHP.Magento.com

Top25
– Top25

2015-03-15 16:48:09 +00:00
Commented Mar 15, 2015 at 16:48 — Top25
– Top25, Commented Mar 15, 2015 at 16:48

Gyrocode.com · Accepted Answer · 2016-11-28 19:37:21Z

4

CAUSE

Apparently you're using DataTables version 1.10. By default, this version expects data to be in certain format, see DataTables documentation for more information.

{
    "data": [
        // row 1 data source,
        // row 2 data source,
        // etc
    ]
}

SOLUTION

Change $a[][] = $row; to $a['data'][] = $row in your PHP to produce data in the correct format.

edited Nov 28, 2016 at 19:37

answered Mar 16, 2015 at 11:51

Gyrocode.com

59k16 gold badges157 silver badges192 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Arka · Accepted Answer · 2015-03-17 13:02:25Z

If you using datatable 1.10 api, you need to create a json response like :

$json_data = array(
    "draw"            => intval( $_REQUEST['draw'] ),
    "recordsTotal"    => intval( $totaldata ),
    "recordsFiltered" => intval( $totalfiltered ),
    "data"            => $data
);
echo json_encode($json_data);

draw: we send same number which has been send by datatable at time of draw/request.
recordsTotal: Total numbers of records in your table.
recordsFiltered: Total numbers of filtered records after searching in your table. If you do not perform any search then recordsFiltered will be same as recordsTotal.
data: Your fetched records data. You have to fetched the data as per start, length, search value, colomn name and sorting orders parameters. you can download dummy database table from here

Please refer this link to know the details

Collectives™ on Stack Overflow

jQuery Datatable with PHP json_encode

2 Answers 2

CAUSE

SOLUTION

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

CAUSE

SOLUTION

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related