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: http://stackoverflow.com/questions/5164404/json-decode-to-array — Suriyamoorthy Baskaran, Sep 23 '12 at 10:05

score 2 · Answer 1 · answered Sep 23 '12 at 10:01

2

Use json_decode :

echo json_decode($jsonarr);

answered Sep 23 '12 at 10:01

Mahmoud Gamal

78,257
17
139
164

1

@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. – Mahmoud Gamal Sep 23 '12 at 10:09

score 2 · Answer 2 · answered Sep 23 '12 at 10:04

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 '12 at 10:04

NullPoiиteя

56,591
22
125
143

score 1 · Accepted Answer · edited Sep 23 '12 at 10:34

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 '12 at 10:34

Marcin Orlowski

72,056
11
123
141

answered Sep 23 '12 at 10:14

GBD

15,847
2
46
50

How to convert URL encoded JSON array into PHP array

3 Answers3