How to convert URL encoded JSON array into PHP array

Question

how can convert URL encoded JSON sent from my android application into PHP array.Current format i am getting looks like below format.

[{\\\"product_id\\\":\\\"33\\\",\\\"amount\\\":\\\"1\\\"},{\\\"product_id\\\":\\\"34\\\",\\\"amount\\\":\\\"3\\\"},{\\\"product_id\\\":\\\"10\\\",\\\"amount\\\":\\\"1\\\"}]

How can i convert those data into below format


product_id    amount
   33         1 
   34         3 
   10         1

Because i want to insert those data into MySQL database.Can anyone please help me regarding this problem.

$jsonArray = json_decode($jsonStr, TRUE); Refer: stackoverflow.com/questions/5164404/json-decode-to-array — Suriyamoorthy Baskaran
– Suriyamoorthy Baskaran, Commented Sep 23, 2012 at 10:05

Mahmoud Gamal · Accepted Answer · 2012-09-23 10:01:36Z

2

Use json_decode :

echo json_decode($jsonarr);

answered Sep 23, 2012 at 10:01

Mahmoud Gamal

80.2k18 gold badges143 silver badges168 bronze badges

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

1 Comment

Mahmoud Gamal Over a year ago

@Damith, this means that the json passed to it cannot be decoded or if the encoded data is deeper than the recursion limit as explained in the php manual.

Mayank K. Swami · Accepted Answer · 2012-09-23 10:04:20Z

2

this can be done by json_decode

$json = '{"foo": 12345}';

$obj = json_decode($json);
print $obj->{'foo'}; // 12345

Good read

--- common mistakes using json_decode()

answered Sep 23, 2012 at 10:04

Mayank K. Swami

57.3k23 gold badges129 silver badges148 bronze badges

Comments

Marcin Orlowski · Accepted Answer · 2012-09-23 10:34:40Z

1

json_decode(jsonencoded string, TRUE) is correct way to encode json string.

But your json string encoded too deeper and recursive. your json encode string should as below

[{"product_id":9,"amount":500},{"product_id":9,"amount":500},{"product_id":9,"amount":500}]

Other wise, you will get NULL value

edited Sep 23, 2012 at 10:34

Marcin Orlowski

75.7k11 gold badges128 silver badges152 bronze badges

answered Sep 23, 2012 at 10:14

GBD

16k2 gold badges49 silver badges52 bronze badges

Collectives™ on Stack Overflow

How to convert URL encoded JSON array into PHP array

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related