Parsing serialized data in mysql while loop

Question

I'm trying to parse the WordPress meta_value column in the wp_postmeta table.

meta_value row contents are in a serialized format like so:

a:1:{i:0;O:8:"stdClass":2:{s:5:"notes";s:0:"";s:12:"applications";a:5:
{s:4:"Year";O:8:"stdClass":2:
{s:4:"name";s:4:"Year";s:5:"value";s:4:"2006";}s:4:"Make";O:8:"stdClass":2:
{s:4:"name";s:4:"Make";s:5:"value";s:5:"Isuzu";}s:5:"Model";O:8:"stdClass":2:
{s:4:"name";s:5:"Model";s:5:"value";s:5:"i-280";}s:4:"Trim";O:8:"stdClass":2:
{s:4:"name";s:4:"Trim";s:5:"value";s:31:"Base Extended Cab Pickup 2-Door";}s:6:"Engine";O:8:"stdClass":2:
{s:4:"name";s:6:"Engine";s:5:"value";s:54:"2.8L 2770CC 169Cu. In. l4 GAS DOHC Naturally Aspirated";}}}}

I was able to use a while loop to unserialize the data

$results = $mysqli->query("SELECT meta_value
           FROM wp_postmeta
           WHERE meta_key = '_ebay_item_compatibility_list';");

while($row = $results->fetch_array()) {
echo '<pre>';
print_r(unserialize($row['meta_value']));
echo '</pre>';
                                      }

This gives me an output like

What I am trying to do is access all the value elements.

Meaning something like $year = ['Year']['value']; , $make = ['Make']['value']; etc.

How do I access these value elements while in my while loop?

Vody · Accepted Answer · 2017-05-03 19:50:31Z

1

You have a combination of stdClass objects and arrays so for array you normally use [] and for object's properties ->

Example:

while($row = $results->fetch_array()) {
    $foo = unserialize($row['meta_value']);
    $foo[0]->applications['Make']->value;

}

EDIT: you can use foreach if there are more array elements in a row

while($row = $results->fetch_array()) {
        $foo = unserialize($row['meta_value']);
        foreach ( $foo as $f) {
            foreach ( $f->applications as $application) {
                echo $application->value;
            }
        }
}

edited May 3, 2017 at 19:50

answered May 3, 2017 at 19:33

Vody

787 bronze badges

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

3 Comments

Brian Bruman Over a year ago

Thanks! The [0] is a bit confusing, but it is returning all the results.

Brian Bruman Over a year ago

Love it, thanks. Much easier to understand and get a grasp around.

Vody Over a year ago

you can also use foreach for applications array

Collectives™ on Stack Overflow

Parsing serialized data in mysql while loop

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related