query post, meta value in_array(meta_key) WordPress

Dbranes answers:

You should in general use an array:


'value' => array( 'value3' )


when the compare method is "IN".

Did you try that?

<strong>Update:</strong>

You can try the following:


$args = array(
'posts_per_page' => -1,
'post_type' => 'professeur',
'meta_key' => 'automobiles',
);

$new_query = new WP_Query( $args );

if( $new_query->have_posts() ):
while($new_query->have_posts()) : $new_query->the_post();

the_title();

$meta = get_post_meta( get_the_ID(), 'automobiles', true );
foreach( $meta as $k => $v ):
if( isset( $v['select'] ) && 'value3' === $v['select'] ):
echo '<br /> Meta: yes this post contains a "select" with "value3"';
endif;
endforeach;

echo '<hr />';

endwhile;
endif;


<strong>Another idea:</strong>

You modify the <em>save_post </em> hook of the github snippet to save the select values (or others) into a single custom fields, that can be filtered via <em>meta_query</em> of<em> WP_Query()</em>.

You can for example collect the <em>name</em>, <em>select</em> or <em>url</em> of the repeatable fields, so we can introduce new (multiple) custom fields:

automobiles_name,
automobiles_select,
automobiles_url


Let's collect for example the <em>automobiles_select</em> values, modified by the user.

We then have to modify the <em>save_post</em> action callback, with a single <em>delete_post_meta()</em> before the for loop and place the <em>add_post_meta()</em> inside the for loop:



...cut...

//---------------------------------------------------------------
// Delete our new (multiple) custom field for the 'select' part
//
delete_post_meta( $post_id, 'automobiles_select' );
//---------------------------------------------------------------

for ( $i = 0; $i < $count; $i++ ) {
if ( $names[$i] != '' ) :
$new[$i]['name'] = stripslashes( strip_tags( $names[$i] ) );

if ( in_array( $selects[$i], $options ) )
$new[$i]['select'] = $selects[$i];
else
$new[$i]['select'] = '';

if ( $urls[$i] == 'http://' )
$new[$i]['url'] = '';
else
$new[$i]['url'] = stripslashes( $urls[$i] ); // and however you want to sanitize

//---------------------------------------------------------------
// Add our new (multiple) custom field for the 'select' part
//
add_post_meta( $post_id, 'automobiles_select', $new[$i]['select'] );
//---------------------------------------------------------------

endif;

}

...cut...



Then you can filter the <em>automobiles_select</em> values with <em>WP_Query( $args )</em>, where:


$args = array(
'posts_per_page' => -1,
'post_type' => 'professeur',
'meta_query' => array (
array (
'key' => 'automobiles_select',
'value' => array( 'value1','value2' ),
'compare' => 'IN',
),
),
);


ps: Just let me know if we need to adjust it more.

---

---

---

---

---

---

---

---

---

---

---

---

---