json_encode does not print the array name

Question

I'm not experienced with json_encode and am trying to return an arrray of array which should be called aaData - for DataTables with server-side processing.

The output should be like:

{
    "sEcho": 3,
    "iTotalRecords": 57,
    "iTotalDisplayRecords": 57,
    "aaData": [
        [
            "Gecko",
            "Firefox 1.0",
            "Win 98+ / OSX.2+",
            "1.7",
            "A"
        ],
        [
            "Gecko",
            "Firefox 1.5",
            "Win 98+ / OSX.2+",
            "1.8",
            "A"
        ],
        ...
    ] 
}

but the actuall output of my PostgreSQL 8.4-driven PHP-script

if (isset($_REQUEST['json'])) {
    $aaData = array();
    while ($row = $sth->fetch(PDO::FETCH_NUM)) {
        array_push($aaData, $row);
    }
    print json_encode($aaData);
}

is actually missing outside brackets (object like?) and the aaData name:

[
    [ .... ],
    [ .... ],
    [ .... ]
]

How would you do this best?

salathe · Accepted Answer · 2011-09-23 12:25:11Z

11

Another option is to use the code in the question but change one line:

print json_encode(array('aaData' => $aaData));

answered Sep 23, 2011 at 12:25

salathe

52.1k12 gold badges108 silver badges134 bronze badges

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

Comments

Brian · Accepted Answer · 2011-09-23 12:21:50Z

5

If you want it to have aaData as the name, then you'll need to give your array an associative index, like so:

if (isset($_REQUEST['json'])) { 
    $arr['aaData'] = array(); 
    while ($row = $sth->fetch(PDO::FETCH_NUM)) { 
        array_push($arr['aaData'], $row); 
    } 
    print json_encode($arr); 
}

edited Sep 23, 2011 at 12:21

answered Sep 23, 2011 at 12:12

Brian

13.6k13 gold badges62 silver badges103 bronze badges

1 Comment

Alexander Farber Over a year ago

That gives me {"aaData":null}

cweiske · Accepted Answer · 2011-09-23 12:23:37Z

1

To explain the root of your problem: The name of the variable, $aaData, has nothing to do with the data itself. Thus, json_encode does not serialize it.

answered Sep 23, 2011 at 12:23

cweiske

31.4k15 gold badges150 silver badges206 bronze badges

Collectives™ on Stack Overflow

json_encode does not print the array name

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related