Parsing and looping through a JSON input string

Question

I have the following JSON input (it's in a file called customer.json) but cant seem to loop through the values -

{"posts":[
{"post":{"Customer_ID":"A & I","CustomerName":"A & I Products"}},
{"post":{"Customer_ID":"A&A","CustomerName":"A & A Mfg. Co., Inc."}}
]}

The following is the code I've tried and have been working with -

$inputJSON = file_get_contents('/srv/www/htdocs/sandbox/customer.json');
$parsedJSON = json_decode($inputJSON,true);
$parsedJSON = $parsedJSON['posts'];

foreach ($parsedJSON['post'] as $post) 
{
$custid = $post['Customer_ID'];
$custnm = $post['CustomerName'];
echo $custid; 
echo $custnm; 
}

Any help that can be offered would be greatly appreciated. Thanks,

what does print_r($parsedJSON) say?

giorgio
– giorgio

2013-10-09 13:58:06 +00:00
Commented Oct 9, 2013 at 13:58 — giorgio
– giorgio, Commented Oct 9, 2013 at 13:58

Hanky Panky · Accepted Answer · 2013-10-09 14:02:08Z

1

You are supplying wrong key for the loop, that is not the structure after json_decode. Try a print_r. It will work like:

foreach ($parsedJSON as $value) 
{
$custid = $value["post"]['Customer_ID'];
$custnm = $value["post"]['CustomerName'];
echo $custid; 
echo $custnm; 
}

This is how your array looks like

Array
(
    [0] => Array
        (
            [post] => Array
                (
                    [Customer_ID] => A & I
                    [CustomerName] => A & I Products
                )

        )

    [1] => Array
        (
            [post] => Array
                (
                    [Customer_ID] => A&A
                    [CustomerName] => A & A Mfg. Co., Inc.
                )

        )

)

Fiddle

answered Oct 9, 2013 at 14:02

Hanky Panky

46.9k9 gold badges76 silver badges95 bronze badges

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

Comments

becquerel · Accepted Answer · 2013-10-09 14:00:14Z

0

From the look of the JSON, try this:

foreach ($parsedJSON as $post) 
{
 $custid = $post['post']['Customer_ID'];
 $custnm = $post['post']['CustomerName'];
 echo $custid; 
 echo $custnm; 
}

answered Oct 9, 2013 at 14:00

becquerel

1,1317 silver badges11 bronze badges

Comments

Pj Dietz · Accepted Answer · 2013-10-09 14:04:22Z

Each $post variable is an array containing a 'post' key. You'll need to read them like this:

foreach ($parsedJSON as $post)
{
    $custid = $post['post']['Customer_ID'];
    $custnm = $post['post']['CustomerName'];
    echo $custid;
    echo $custnm;
}

Here's what a print_r looks like:

Array
(
    [posts] => Array
        (
            [0] => Array
                (
                    [post] => Array
                        (
                            [Customer_ID] => A & I
                            [CustomerName] => A & I Products
                        )

                )

            [1] => Array
                (
                    [post] => Array
                        (
                            [Customer_ID] => A&A
                            [CustomerName] => A & A Mfg. Co., Inc.
                        )

                )

        )

)

Collectives™ on Stack Overflow

Parsing and looping through a JSON input string

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related