PHP parsing table/array string

Question

Hello Stack Overflow,
This is my first post and I have a problem I need to parse this text and turn it into an array (its from a database).

"TableToKeyValues"
{
    "inventory"
    {
        "slot2"
        {
            "amount"        "10"
            "item"      "wood_plank"
        }
        "slot1"
        {
            "amount"        "10"
            "item"      "metal"
        }
        "slot3"
        {
            "amount"        "10"
            "item"      "plastic"
        }
    }
}

Thanks rtm516.

rtm516 · Accepted Answer · 2015-09-04 15:14:47Z

3

I worked out how to do it by formatting it into json useing str_replace alot of times.

$inv = preg_replace( "/\r|\n/", "", $inv);
$inv = str_replace('}', '},', $inv);
$inv = str_replace('"       "', '":"', $inv);
$inv = str_replace('"           "', '","', $inv);
$inv = str_replace('"       {', '":{', $inv);
$inv = str_replace('"   {', '":{', $inv);
$inv = str_replace('"{', '":{', $inv);
$inv = trim(preg_replace('/\t+/', '', $inv));
$inv = str_replace('},}', '}}', $inv);
$inv = str_replace('},},', '}}', $inv);
$inv = str_replace('"TableToKeyValues":', '', $inv);
$inv = json_decode($inv, true);

Edit: $inv is the value from the database.

edited Sep 4, 2015 at 15:14

answered Sep 4, 2015 at 9:27

rtm516

631 silver badge9 bronze badges

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

Comments

aldrin27 · Accepted Answer · 2015-09-04 08:40:35Z

0

If you want that to be converted into array use json_decode

$arr = json_decode($dataComingFromDBHERE, true);
print_r($arr);

answered Sep 4, 2015 at 8:40

aldrin27

3,4184 gold badges31 silver badges44 bronze badges

2 Comments

aldrin27 Over a year ago

I thought it's a json. Where did the data coming from? Before inserting in the database.

rtm516 Over a year ago

A game called garrys mod using the lua function util.TableToKeyValues

Collectives™ on Stack Overflow

PHP parsing table/array string

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related