Formatting json_encode()

Question

I'm using json_encode() to pass data. This is my foreach loop.

foreach ($result as $val) {
    $data[] = array('item'=>$val["item"]);
    $data[] = array('availability'=>$val["stocks"]););
}

the output is

[
    {
        "item": "Anchor Butter"
    },
    {
        "availability": "no"
    },
    {
        "item": "Kraft Chedder"
    },
    {
        "availability": "yes"
    }
]

My question is how can I do the output as below?

[
    {
        "item": "Anchor Butter",
        "availability": "no"
    },
    {
        "item": "Kraft Chedder",
        "availability": "yes"
    }
]

marekful · Accepted Answer · 2015-07-05 12:47:30Z

4

You are adding 2 elements to the $data array in each iteration. Instead, try this:

foreach ($result as $val){
    $data[] = array('item'=>$val["item"], 'availability'=>$val["stocks"]));
}

answered Jul 5, 2015 at 12:47

marekful

15.4k6 gold badges39 silver badges63 bronze badges

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

Comments

Matt · Accepted Answer · 2015-07-06 17:24:23Z

2

$info=array();
while ($row = mysql_fetch_assoc($result)) {
    $info1= array();
    $info1["item"]=$row["item"];
    $info1["availability"]=$row["stocks"];
    array_push($info, $info1);  
}
print_r($info);

edited Jul 6, 2015 at 17:24

Matt

75.4k26 gold badges156 silver badges181 bronze badges

answered Jul 5, 2015 at 12:52

Erfan pj

3811 silver badge10 bronze badges

Collectives™ on Stack Overflow

Formatting json_encode()

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