WordPress 4.1的查询改进

早上好,送你清新的问候,温馨的祝福,清晨,美好的开始,祝你今天精神棒棒,活力多多,心情好好,一切都好!
本文是《掌握 WP_Query》专题的第 18 篇,共 19 篇:
  • WP_Query 参数:自定义字段(Custom Fields)
  • WP_Query 参数:分类法(Taxonomies)
  • 掌握 WP_Query : 入门介绍
  • 掌握 WP_Query:教你使用Loop循环
  • 掌握 WP_Query:相关的函数
  • 掌握 WP_Query:行动器和过滤器
  • 掌握 WP_Query:WP_Query类的属性和方法
  • WP_Query 参数:文章、页面和文章类型
  • WP_Query 参数:分类和标签
  • WP_Query 参数:日期
  • WP_Query 参数:状态、排序和分页
  • WP_Query 参数:作者、搜索、密码、权限、缓存和返回字段
  • 掌握 WP_Query:10个有用的例子
  • 结合 WP_Query 与主查询(the Main Query)
  • 掌握 WP_User_Query
  • 掌握 WP_Comment_Query
  • 掌握 WP_Meta_Query 和 WP_Date_Query
  • WordPress 4.1的查询改进
  • 掌握 WP_Query:结尾

在过去的一年里,很多人都写到 WordPress 改进了用户界面:最受关注的变化是提高写作经验。但如果你是开发者,你可能更想知道 WordPress 底层有哪些改进。在这里,我将演示对开发者最有趣的变化之一:改进某些类型的查询。

注:由于时间精力有限,本好代码教程没办法翻译分享,希望朋友们可以加入我们,帮助我们进行翻译,有小酬谢,有意者请联系倡萌QQ 745722006(注明:好代码教程翻译)。

以下为原文:http://code.tutsplus.com/tutorials/query-improvements-in-the-latest-versions-of-wordpress--cms-23016

Within the last year, much has been written about the improvements to the WordPress user interface: the most talked about change has been the improved writing experience.

But if you're a developer you'll be wanting to know less about that and more about what's changed under the hood. Here I'll demonstrate one of the most interesting changes for developers: improvements to certain types of queries.

The main changes are as follows:

  • Support for nested queries has been added for queries on post metadata, dates, and taxonomy terms.
  • Extra parameters have been added for querying comments.
  • And some bugs have been fixed too!

Let's have a look at the changes.

Nested Queries

In previous versions of WordPress, you could use an AND or OR statement to define queries for taxonomy terms, dates, and metadata. So for example, the following arguments will be used in a query on a recipe site which outputs quick breakfast recipes:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
<?php

$args = array(
    'post_type' => 'post',
    'tax_query' => array(
        'relation' => 'AND',
        array(
            'taxonomy' => 'speed',
            'field' => 'slug',
            'terms' => array( 'quick' )
        ),
        array(
            'taxonomy' => 'meal',
            'field' => 'slug',
            'terms' => array( 'breakfast' )
        )
    )
);

$query = new WP_Query( $args );

?>

<?php $args = array( 'post_type' => 'post', 'tax_query' => array( 'relation' => 'AND', array( 'taxonomy' => 'speed', 'field' => 'slug', 'terms' => array( 'quick' ) ), array( 'taxonomy' => 'meal', 'field' => 'slug', 'terms' => array( 'breakfast' ) ) ) ); $query = new WP_Query( $args ); ?>

This looks for the 'speed' and 'meal' taxonomies and outputs posts with the 'quick' and 'breakfast' terms respectively.

But what if you wanted to write a more complex query? Let's say you wanted quick recipes for breakfast and slow recipes for lunch (maybe for someone who wants to get breakfast done quickly so they have more time to cook lunch!). You don't want to use a simple AND statement to join all the elements of your query, since then you would get slow recipes for breakfast and lunch, for example. And you don't want to use an OR statement linking all the terms, as you'll get all manner of recipes which only have one of the queried terms along with other ones you want to filter out.

The good news is that now you can do this. To query quick recipes for breakfast and slow recipes for lunch, you'd use the following:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
<?php

$query = new WP_Query(
    array(
        'tax_query' => array(
            'relation' => 'OR',
            array(
                'relation' => 'AND',
                array(
                    'taxonomy' => 'meal',
                    'field' => 'slug',
                    'terms' => array( 'breakfast' )
                ),
                array(
                    'taxonomy' => 'speed',
                    'field' => 'slug',
                    'terms' => array( 'quick' )
                )
            ),
            array(
                'relation' => 'AND',
                array(
                    'taxonomy' => 'meal',
                    'field' => 'slug',
                    'terms' => array( 'lunch' )
                ),
                array(
                    'taxonomy' => 'speed',
                    'field' => 'slug',
                    'terms' => array( 'slow' )

                )
            )
        )
    )
);

$query = new WP_Query( $args );

?>

<?php $query = new WP_Query( array( 'tax_query' => array( 'relation' => 'OR', array( 'relation' => 'AND', array( 'taxonomy' => 'meal', 'field' => 'slug', 'terms' => array( 'breakfast' ) ), array( 'taxonomy' => 'speed', 'field' => 'slug', 'terms' => array( 'quick' ) ) ), array( 'relation' => 'AND', array( 'taxonomy' => 'meal', 'field' => 'slug', 'terms' => array( 'lunch' ) ), array( 'taxonomy' => 'speed', 'field' => 'slug', 'terms' => array( 'slow' ) ) ) ) ) ); $query = new WP_Query( $args ); ?>

Here I've used two nested arrays:

  • The outer array uses OR, because we're looking for posts which are either quick breakfast recipes or slow lunch recipes.
  • The first nested array looks for posts which are quick breakfast recipes, using AND because you want the post to have both terms.
  • The second nested array looks for slow lunch recipes, again using AND.

Of course you could vary your queries to include multiple taxonomy terms and values, and get as complex as you need.

Applying Nested Queries: Taxonomy Terms, Metadata, and Dates

The example I've given above uses taxonomy terms, but this feature has also been added to date and metadata queries. Metadata is potentially where things could get interesting, as you have the scope for so many values.

The syntax works in exactly the same way for date and metadata queries. For meta queries you replacetax_query with meta_query and use 'key' and 'value' as the parameters. For date queries you replacetax_query with date_query and use the date parameters provided in the WordPress Codex.

Comment Parameters

To query comments, you use the WP_Comment_Query class in place of the more commonly used WP_Query class. This class has had eight new parameters added to it:

  • 'author__in': identify comment author (or an array of authors)
  • 'author__not_in': identify comments not by a certain author (or array of authors)
  • 'post_author__in': identify author (or array of authors) of the post the comment was made on
  • 'post_author__not_in': exclude comments made on posts written by particular author or array of authors
  • 'comment__in': comments with a certain ID or array of IDs
  • 'comment__not_in': exclude comments with a certain ID or array of IDs
  • 'post__in': comments made on a post or array of posts (using the post ID)
  • 'post__not_in': exclude comments made on a post or array of posts (using the post ID)

The values used for these are the author ID, comment ID or post ID as appropriate.

Note that the WP_Comment_Query class now supports nested queries as well.

Bug Fixes

There have also been a couple of bug fixes which you might find helpful:

  • A bug that caused queries to fail when a date_query was used along with a tax_query or meta_query has been fixed.
  • When ‘orderby' => 'meta_value’ was used when passing a 'meta_query' with the OR relation in WP_Query, this used to break the query. This has been fixed.

If you want the lowdown on all the details, you can find it on the make WordPress core site.

Summary

These improvements to queries take WordPress a step further to full CMS capability. The ability to use nested queries means that you can output content in much more flexible and complex ways. It will be interesting to see how people use them!

本文WordPress 4.1的查询改进到此结束。不问收获,但问耕耘!天道酬勤。小编再次感谢大家对我们的支持!

您可能有感兴趣的文章
WordPress站点Gravatar头像前后台不显示的如何解决办法

WordPress主题需要支持https吗?WordPress站点如何如何实现https?

WordPress站点的页面/标签/分类URL地址如何添加.html?

WordPress站点更换了域名后数据库应该如何操作替换新旧域名?

WordPress安装在主机空间的什么目录里面?根目录在哪里?