php - Wordpress meta_query LIKE 比较数组中的值

Question

我有一个看起来像这样的脚本:

  foreach($target_zips as $zipcode) {

      $query_adresses = array (
        'order'     => 'ASC',
        'cat'       => $_GET["cat"],
        'post_type'=> 'adressen',
        'posts_per_page'   => '-1',
        'meta_query' => array(
            array(
                'key'     => 'postcode',
                'value'   => $zipcode,
                'compare' => 'LIKE',
            )
        )
      );

      $results = get_posts( $query_adresses );

      $matched_adresses[] = $results;

  }

一个脚本遍历一组值，然后查询大量帖子以查看是否有与 meta_query 匹配的帖子。这太慢了。是否可以在这个 meta_query 中放入一组值，而不是一遍又一遍地查询 $target_zips 中的每个值？

Answer 1

您可以只运行一个将返回所有结果的 get_posts() 查询。预先构建元查询。

$meta_query = [];


/**
 * This will return all posts that contain at least one meta_query from the loop
 */
$meta_query['relation'] = 'OR';


foreach ( $target_zips as $zipcode ) {
    $meta_query[] = [
        'key'     => 'postcode',
        'value'   => $zipcode,
        'compare' => 'LIKE',
    ];
}


$query_adresses   = [
    'order'          => 'ASC',
    'cat'            => $_GET["cat"],
    'post_type'      => 'adressen',
    'posts_per_page' => '-1',
    'meta_query'     => $meta_query
];
$matched_adresses = get_posts( $query_adresses );

有关更多详细信息，请参阅:https://codex.wordpress.org/Class_Reference/WP_Meta_Query