Wordpress meta_query key array

Question

I am using the: http://www.farinspace.com/how-to-create-custom-wordpress-meta-box/ function to create some custom meta boxes.

My WP_Query looks like this:

            $args = array(
                'post_type' => 'testimonials',
                'post_status' => 'publish',
                'orderby' => checked((bool) $instance['testimonials_random'], true, false) ? 'rand' : 'id',
                'posts_per_page' => $testimonials_number,
                'paged' => get_query_var('page'),
                'meta_query' => array(
                    array(
                        'key' => '_my_meta["addtosidebar"]',
                        'value' => 'on',
                        'compare' => 'LIKE'
                    )
                )
            );
            $query = new WP_Query($args);

The input checkbox addtosidebar looks like this: <input type="checkbox" name="_my_meta[addtosidebar]" <?php checked((bool) $meta['addtosidebar'], true); ?> class="checkbox" />

Do you have any idea how can I access the key in the meta_query?

Thanks, Cip

Richard M · Accepted Answer · 2012-12-19 10:01:06Z

5

I don't think you can do that as in the tutorial you linked to the meta values are stored in an array, which is then serialised into a single database field. So you end up with something like this in the database: a:4:{s:12:"addtosidebar";s:2:"on";s:3:"foo";s:3:"bar";}.

The following meta query might work, but it would be better to use a separate custom field.

'meta_query' => array(
  array(
    'key' => '_my_meta',
    'value' => 's:12:"addtosidebar";s:2:"on";',
    'compare' => 'LIKE'
  )
)

edited Dec 19, 2012 at 10:01

answered May 13, 2011 at 17:39

Richard M

14.6k6 gold badges56 silver badges50 bronze badges

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

1 Comment

Ciprian Tepes Over a year ago

it was like this:

'meta_query' => array(                         array(                             'key' => '_my_meta',                             'value' => 'addtosidebar',                             'compare' => 'LIKE'                         )                     )

Mighty Mess · Accepted Answer · 2013-04-14 13:07:40Z

it was like this: 'meta_query' => array( array( 'key' => '_my_meta', 'value' => 'addtosidebar', 'compare' => 'LIKE' ) ) – CIPPO Design

This worked for me, I think that should be added as an answer. One thing, like Richard pointed out the entry in the database is serialized. So 'LIKE' will basically just look for the 'value' 'addtosidebar' in that string.

For example if I have a meta array like this:

Post 1:

$myMeta = array('medium' => 'video', 'sometext' => 'a beautiful video')

Post 2:

$myMeta = array ('medium' => 'image', 'sometext' => 'a beautiful image of a video button')

That means that using the compare 'LIKE' on 'video' will return both as video is also found in the 'sometext' value of the second post. To stop that I had to add the quote marks to restrict it:

$query->set( 'meta_query' , array(
                              array(
                                'key' => 'blogInfo',
                                'value' => '"video"',
                                'compare' => 'LIKE'
                            )
                            ));

Hope that will help someone and that I manage to make sense.

ps: Sorry I'm not hi-profile enough to just comment.

Collectives™ on Stack Overflow

Wordpress meta_query key array

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related