regex syntax to get data into separated variables

Question

I have this code inserted into the database: {"2":{"qty":1,"price":"10.00","room_id":{"1002":"1"}},"1":{"qty":2,"price":"35.00","room_id":["2"]},"3":{"qty":1,"price":"18.00","room_id":["1"]}}

I want to get the values FROM {"2":{"qty":1,"price":"10.00","room_id":{"1002":"1"}} TO "3":{"qty":1,"price":"18.00","room_id":["1"]}} and store each digit in a separate variable.

What would be the regular expression to match this?

score 11 · Answer 1 · answered Jan 22 '13 at 20:16

11

what's the sytax i should use as regex please?

The answer is "none". You should not try to parse JSON using regexes. Use the json_decode() function instead.

answered Jan 22 '13 at 20:16

sorry, posted my answer as comment to your, it's fixed now – Peter Butkovic Jan 22 '13 at 20:20
@PeterButkovic No problem, I removed my comment. – Jan 22 '13 at 20:22
1

http://stackoverflow.com/a/1732454/1344461 – C0deH4cker Jan 22 '13 at 20:35
@C0deH4cker Been there, seen that :) – Jan 22 '13 at 20:38

score 0 · Answer 2 · edited May 23 '17 at 12:21

0

If you need to store json data in the database, why don't you use some noSQL one that does json internally?

I'd go for MongoDB. Or possibly any of these: Databases using JSON as storage/transport format

edited May 23 '17 at 12:21

Community

1
1

answered Jan 22 '13 at 20:20

Peter Butkovic

11,143
10
57
81

regex syntax to get data into separated variables

2 Answers2