get value from product_attribute field [SOLVED]

[guardiano78]

Hello,
i need to make a external script that read only the value of product attribute from #__virtuemart_order_items table.

this is my product_attribute string value:

Code Select Expand


{
    "1": {
        "2": {
            "comment": "AJ4F9F"
        }
    }
}


Well, i need to extract from this string only AJ4F9F.

How can i do this?
thanks!

[guardiano78]

I tried with this code:

Code Select Expand


$stringa = '{
    "1": {
        "2": {
            "comment": "AJ4F9F"
        }
    }
}';

preg_match_all('/".*"/', $stringa, $ris);
$a= $ris[0][2];
$data = explode(':', $a);
echo str_replace('"','',$data[1]);

But i don't know if this is the right solution.
Can anyone help me?

Thank you!

[Ghost]

That's probably JSON data. Use json_decode to turn it into object or array.

This works if you just need to echo the comment once:

Code Select Expand

echo json_decode($stringa,true)[1][2]['comment'];

[guardiano78]

Thank you for suggestion.
Now i used this code:

Code Select Expand


$data_attribute = json_decode($product_attribute, true);
$code = $data_attribute ['1']['2']['comment'];

and seem it works.

Thank you so much!