json_encode with correct format

Question

I can't get my json_encode format that I need.

Current Format:

{
    "substantiv": [
        {"text":"auto"},
        {"text":"noch ein auto"}
    ],
    "verben":[
        {"text":"auto fahren"}
    ]
}

What I need:

[
    {
        "type":"substantiv",
        "items": [
            {"text":"auto"},
            {"text":"noch ein auto"}
        ]
    } , {
        "type":"verben",
        "items": [
            {"text":"auto fahren"}
        ]
    }
]

My current php code:

$data = array();
while($row = $rs->fetch_assoc()){
    $tmp = array(
        "text" => $row['gtext']
        );

    $data[$row['type']][] = $tmp;
}
echo json_encode($data);

I have tried a few things but just can't figure it out.

A valid JSON data representation won't duplicate keys in the same nesting level. — Adam Rivers
– Adam Rivers, Commented Oct 16, 2013 at 8:38
The JSON array you want is invalid, as it contains duplicate property names in the same object. You probably actually need to include an additional nested array to hold each set of type and item data. — Spudley
– Spudley, Commented Oct 16, 2013 at 8:41

Louis Huppenbauer · Accepted Answer · 2013-10-16 08:43:47Z

2

You could try something like this

while($row = $rs->fetch_assoc()){
    $data[$row['type']][] = array(
        "text" => $row['gtext']
    );
}

$result = array();
foreach($data AS $type => $items) {
    $result[] = array(
        'type' => $type,
        'items' => $items
    );
}

echo json_encode($result);

answered Oct 16, 2013 at 8:43

Louis Huppenbauer

3,7141 gold badge20 silver badges24 bronze badges

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

Comments

SirDarius · Accepted Answer · 2013-10-16 08:45:06Z

1

What you actually want is this:

[
    {
        "type": "substantiv",
        "items": [
            {
                "text": "auto"
            },
            {
                "text": "noch ein auto"
            }
        ]
    },
    {
        "type": "verben",
        "items": [
            {
                "text": "auto fahren"
            }
        ]
    }
]

which is the output you'll get from Louis H.'s answer's code.

answered Oct 16, 2013 at 8:45

SirDarius

43.3k8 gold badges92 silver badges106 bronze badges

Collectives™ on Stack Overflow

json_encode with correct format

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related