Get Data from Array PHP

Question

I cant quite get my data from an array, it just shows a blank list of 3 list items when I run my foreach loop.

When I print my array it looks like this ->

Array
(
    [1] => Array
        (
            [id] => 10
            [orderinfo] => Array
            [userid] => 210
            [date] => 2013-06-20 13:46:27
        )

    [2] => Array
        (
            [id] => 18
            [orderinfo] => helo
            [userid] => 210
            [date] => 2013-06-20 15:04:58
        )

    [3] => Array
        (
            [id] => 19
            [orderinfo] => {"order":[{"id":"2","name":"Basil Cress","qty":"1"},{"id":"4","name":"Sakura Mix","qty":"1"},{"id":"6","name":"Beetroot Shoots","qty":2},{"id":"28","name":"Celery","qty":2},{"id":"24","name":"Orange Capsicums","qty":"1"}]}
            [userid] => 210
            [date] => 2013-06-20 15:06:46
        )

)

My code so far..

foreach ($orderdata as $item) {

    $orderinfo = json_decode($item->orderinfo, true);

    $orderitem[] = array(
        'date' => $item->date,
        'productname' => $orderinfo['name'],
        'productqty' => $orderinfo['qty'],
    );              
}


echo "<pre>";
print_r($orderdata);
echo "</pre>";
?>



<?php foreach ($orderitem as $orderitems) {   ?>
  <li> 
    <?php echo  $orderitems['date']; ?>
  </li>
<?php }; ?>

Is orderinfo consistent for each item, or is it sometimes an array and sometimes a JSON string? — jterry
– jterry, Commented Jun 20, 2013 at 18:04
The json is inside the array, but It still doesn't explain why the date does not appear? — Brent
– Brent, Commented Jun 20, 2013 at 18:05

Pablo S G Pacheco · Accepted Answer · 2013-06-20 18:23:11Z

2

Try to declare your array before the loop like this. Are you already doing this?

$orderitem = array();
foreach ($orderdata as $item) {

    $orderinfo = json_decode($item->orderinfo, true);

    $orderitem[] = array(
        'date' => $item->date,
        'productname' => $orderinfo['name'],
        'productqty' => $orderinfo['qty'],
    );              
}

You can also try to populate your array differently, like this:

array_push($orderitem,array(
            'date' => $item->date,
            'productname' => $orderinfo['name'],
            'productqty' => $orderinfo['qty'],
        ));

answered Jun 20, 2013 at 18:23

Pablo S G Pacheco

2,62030 silver badges29 bronze badges

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

Comments

Schleis · Accepted Answer · 2013-06-20 18:03:37Z

1

Look at the structure of the the JSON for $orderInfo. It is a nested array. So $orderInfo['name'] doesn't exist. You want $orderInfo[0]['name'] or some other numerical index to fill in the data.

This is an array of objects which gets decoded to an array of associative arrays. You need to travel one more level down to get the name.

[
    {"id":"2","name":"Basil Cress","qty":"1"},
    {"id":"4","name":"Sakura Mix","qty":"1"},
    {"id":"6","name":"Beetroot Shoots","qty":2},
    {"id":"28","name":"Celery","qty":2},
    {"id":"24","name":"Orange Capsicums","qty":"1"}
]

answered Jun 20, 2013 at 18:03

Schleis

44.1k8 gold badges73 silver badges90 bronze badges

1 Comment

Brent Over a year ago

Ok that makes sense, but it should still show the date in the list item it currently just shows blank.

Pablo S G Pacheco · Accepted Answer · 2013-06-20 18:09:54Z

1

Could it be just your css?? Background color with the same text color? I know it's silly but who knows...

Try a print_r($orderitem); just like you did with $orderdata

answered Jun 20, 2013 at 18:09

Pablo S G Pacheco

2,62030 silver badges29 bronze badges

1 Comment

Brent Over a year ago

Yeah tried to take a look and nothing just a list of bullet points

Collectives™ on Stack Overflow

Get Data from Array PHP

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related