Get content from pages with same meta_key from Database

Question

I need help!

I'm doing this template page and I want to get content from pages with the same meta_key. I want to display all pages thumbnails that has the value "red" in the meta_key.

The problem is that the meta_key value in the db is a string... I get nothing with this:

$Red = 'a:1:{i:0;s:9:"Red";}';
$Red = unserialize($Red);

$pages = get_pages(array('meta_key' => 'color', 'meta_value' => $red[0]));
 foreach ($pages as $page):

    <?php echo get_the_post_thumbnail($page->ID, 'thumbnail'); ?>
    <?php echo $page->post_title; ?>

    <?php echo $page->post_content; ?>
    <?php endforeach; ?>

What am i doing wrong?

Answer 1

Your code snippet is full of errors.

• The serialized string is invalid, it's only 3 chars instead of 9, unserialization will not work, it will trigger an error.
• Variables are case sensitive, $red doesn't exist, it's $Red, this will trigger an error too.
• The <?php ?> tags are redundant and invalid since there already must be an opening PHP tag, ofcourse this will also trigger an error.

Also I don't understand why the meta value being a string should be a problem?

Works fine:

$red = 'a:1:{i:0;s:3:"Red";}';
$red = unserialize($red);

$pages = get_pages(array('meta_key' => 'color', 'meta_value' => $red[0]));
foreach($pages as $page)
{
    echo get_the_post_thumbnail($page->ID, 'thumbnail');
    echo $page->post_title;
    echo $page->post_content;
}