Loop through JSON and store values to PHP arrays

Question

I have a JSON with the Following structure.

{

 "1":{"Itemname":"dtfg","unitprice":"12","Qty":"4","price":"$48.00"},
 "2":{"Itemname":"kjh","unitprice":"45","Qty":"7","price":"$315.00"},
 "3":{"Itemname":"yjk","unitprice":"76","Qty":"8","price":"$608.00"},
 "4":{"Itemname":"hgj","unitprice":"4","Qty":"45","price":"$180.00"}

}

I need the Itemname to be made into a PHP array, Unitprice into another one, Qty to another one and price to another one. How do I do that?

I am not sure how can I use array_column here. Can you please show? — Ashif Shereef
– Ashif Shereef, Commented Jan 26, 2016 at 11:21

ameenulla0007 · Accepted Answer · 2016-01-26 11:25:41Z

1

$getArray   = get_object_vars(json_decode($json));
print_r($getArray);
echo $getArray[1]->Itemname;
echo $getArray[1]->unitprice;

you require get_object_vars as well for achieving your requirement.

answered Jan 26, 2016 at 11:25

ameenulla0007

2,6831 gold badge15 silver badges15 bronze badges

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

Comments

Progrock · Accepted Answer · 2016-01-26 11:31:06Z

1

<?php
$json =<<<JSONLIVES
{
     "1":{"Itemname":"dtfg","unitprice":"12","Qty":"4","price":"$48.00"},
     "2":{"Itemname":"kjh","unitprice":"45","Qty":"7","price":"$315.00"},
     "3":{"Itemname":"yjk","unitprice":"76","Qty":"8","price":"$608.00"},
     "4":{"Itemname":"hgj","unitprice":"4","Qty":"45","price":"$180.00"}
}
JSONLIVES;


$items = json_decode($json, TRUE);

$item_names = array();
foreach($items as $key => $item) {
    $item_names[] = $item['Itemname'];
}

Or Php >= 5.5

print_r(array_column($items, 'Itemname'));

edited Jan 26, 2016 at 11:31

answered Jan 26, 2016 at 11:27

Progrock

7,4831 gold badge21 silver badges25 bronze badges

Comments

Little Phild · Accepted Answer · 2016-01-26 11:20:32Z

0

You need a function called json_decode() to convert your json data into PHP array

$json =  {

 "1":{"Itemname":"dtfg","unitprice":"12","Qty":"4","price":"$48.00"},
 "2":{"Itemname":"kjh","unitprice":"45","Qty":"7","price":"$315.00"},
 "3":{"Itemname":"yjk","unitprice":"76","Qty":"8","price":"$608.00"},
 "4":{"Itemname":"hgj","unitprice":"4","Qty":"45","price":"$180.00"}

};
var_dump(json_decode($json));

answered Jan 26, 2016 at 11:20

Little Phild

8051 gold badge7 silver badges18 bronze badges

Comments

Noman · Accepted Answer · 2016-01-26 11:26:16Z

0

You need to decode your Json by PHP's json_decode()

$decodeJson will return object then you can read Itemname and other values by using $val->Itemname in foreach loop

$json =  '{

 "1":{"Itemname":"dtfg","unitprice":"12","Qty":"4","price":"$48.00"},
 "2":{"Itemname":"kjh","unitprice":"45","Qty":"7","price":"$315.00"},
 "3":{"Itemname":"yjk","unitprice":"76","Qty":"8","price":"$608.00"},
 "4":{"Itemname":"hgj","unitprice":"4","Qty":"45","price":"$180.00"}

}';

$decodeJson = json_decode($json);

foreach($decodeJson as $key=>$val) {

      print_r($val);
}

Live Json decode

answered Jan 26, 2016 at 11:26

Noman

4,1361 gold badge23 silver badges37 bronze badges

Comments

Jsparo30 · Accepted Answer · 2016-01-26 11:32:54Z

0

Try that:

$json = json_decode($json);

foreach($json as $obj){
   echo $obj->name;
   .....

}

answered Jan 26, 2016 at 11:32

Jsparo30

4054 gold badges10 silver badges31 bronze badges

1 Comment

Gert Arnold Over a year ago

While this code fragment may answer the OP's question, this answer would be much more useful for future visitors if you explain why it solves the problem.

Ashif Shereef · Accepted Answer · 2016-01-26 12:21:16Z

0

After some research, I found out that the most efficientt way that solves my problem here would be to do like the following.

$cash=json_decode($new_json, true);

echo $arr3[1]['Itemname'];
echo $arr3[1]['unitprice'];
:
:

and so on.

This can be put into loops easily, fetched into HTML text-fields (as I want here in this scenario) and so on.

answered Jan 26, 2016 at 12:21

Ashif Shereef

4941 gold badge9 silver badges25 bronze badges

Collectives™ on Stack Overflow

Loop through JSON and store values to PHP arrays

6 Answers 6

Comments

Comments

Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related