regex syntax to get data into separated variables [closed]

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?

user529758 · Accepted Answer · 2013-01-22 20:16:07Z

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, 2013 at 20:16

user529758

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

4 Comments

Peter Butkovic Over a year ago

sorry, posted my answer as comment to your, it's fixed now

user529758 Over a year ago

@PeterButkovic No problem, I removed my comment.

C0deH4cker Over a year ago

stackoverflow.com/a/1732454/1344461

user529758 Over a year ago

@C0deH4cker Been there, seen that :)

Community · Accepted Answer · 2017-05-23 12:21:21Z

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, 2017 at 12:21

CommunityBot

11 silver badge

answered Jan 22, 2013 at 20:20

Peter Butkovic

12.3k10 gold badges62 silver badges85 bronze badges

Collectives™ on Stack Overflow

regex syntax to get data into separated variables [closed]

2 Answers 2

4 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Linked

Related