Skip to content

Instantly share code, notes, and snippets.

@nishinoshake

nishinoshake/readme.md

Last active May 29, 2016 04:20
Show Gist options
  • Save nishinoshake/42c1ffdb762bd1465c23 to your computer and use it in GitHub Desktop.
Save nishinoshake/42c1ffdb762bd1465c23 to your computer and use it in GitHub Desktop.
Download ZIP
WP_Queryの引数まとめ
Raw
readme.md
Raw
wp_query_arg.php
<?php
/**
* WordPress Query Comprehensive Reference
* Compiled by luetkemj - luetkemj.com
*
* CODEX: http://codex.wordpress.org/Class_Reference/WP_Query#Parameters
* Source: https://core.trac.wordpress.org/browser/tags/3.9/src/wp-includes/query.php
*/
$args = array(
//////Author Parameters - Show posts associated with certain author.
//http://codex.wordpress.org/Class_Reference/WP_Query#Author_Parameters
'author' => '1,2,3,', //(int) - use author id [use minus (-) to exclude authors by ID ex. 'author' => '-1,-2,-3,']
'author_name' => 'luetkemj', //(string) - use 'user_nicename' (NOT name)
'author__in' => array( 2, 6 ), //(array) - use author id (available with Version 3.7).
'author__not_in' => array( 2, 6 ), //(array)' - use author id (available with Version 3.7).
//////Category Parameters - Show posts associated with certain categories.
//http://codex.wordpress.org/Class_Reference/WP_Query#Category_Parameters
'cat' => 5,//(int) - use category id.
'category_name' => 'staff, news', //(string) - Display posts that have these categories, using category slug.
'category_name' => 'staff+news', //(string) - Display posts that have "all" of these categories, using category slug.
'category__and' => array( 2, 6 ), //(array) - use category id.
'category__in' => array( 2, 6 ), //(array) - use category id.
'category__not_in' => array( 2, 6 ), //(array) - use category id.
//////Tag Parameters - Show posts associated with certain tags.
//http://codex.wordpress.org/Class_Reference/WP_Query#Tag_Parameters
'tag' => 'cooking', //(string) - use tag slug.
'tag_id' => 5, //(int) - use tag id.
'tag__and' => array( 2, 6), //(array) - use tag ids.
'tag__in' => array( 2, 6), //(array) - use tag ids.
'tag__not_in' => array( 2, 6), //(array) - use tag ids.
'tag_slug__and' => array( 'red', 'blue'), //(array) - use tag slugs.
'tag_slug__in' => array( 'red', 'blue'), //(array) - use tag slugs.
//////Taxonomy Parameters - Show posts associated with certain taxonomy.
//http://codex.wordpress.org/Class_Reference/WP_Query#Taxonomy_Parameters
//Important Note: tax_query takes an array of tax query arguments arrays (it takes an array of arrays)
//This construct allows you to query multiple taxonomies by using the relation parameter in the first (outer) array to describe the boolean relationship between the taxonomy queries.
'tax_query' => array( //(array) - use taxonomy parameters (available with Version 3.1).
'relation' => 'AND', //(string) - Possible values are 'AND' or 'OR' and is the equivalent of running a JOIN for each taxonomy
array(
'taxonomy' => 'color', //(string) - Taxonomy.
'field' => 'slug', //(string) - Select taxonomy term by ('id' or 'slug')
'terms' => array( 'red', 'blue' ), //(int/string/array) - Taxonomy term(s).
'include_children' => true, //(bool) - Whether or not to include children for hierarchical taxonomies. Defaults to true.
'operator' => 'IN' //(string) - Operator to test. Possible values are 'IN', 'NOT IN', 'AND'.
),
array(
'taxonomy' => 'actor',
'field' => 'id',
'terms' => array( 103, 115, 206 ),
'include_children' => false,
'operator' => 'NOT IN'
)
),
//////Post & Page Parameters - Display content based on post and page parameters.
//http://codex.wordpress.org/Class_Reference/WP_Query#Post_.26_Page_Parameters
'p' => 1, //(int) - use post id.
'name' => 'hello-world', //(string) - use post slug.
'page_id' => 1, //(int) - use page id.
'pagename' => 'sample-page', //(string) - use page slug.
'pagename' => 'contact_us/canada', //(string) - Display child page using the slug of the parent and the child page, separated ba slash
'post_parent' => 1, //(int) - use page id. Return just the child Pages. (Only works with heirachical post types.)
'post_parent__in' => array(1,2,3) //(array) - use post ids. Specify posts whose parent is in an array. NOTE: Introduced in 3.6
'post_parent__not_in' => array(1,2,3), //(array) - use post ids. Specify posts whose parent is not in an array.
'post__in' => array(1,2,3), //(array) - use post ids. Specify posts to retrieve. ATTENTION If you use sticky posts, they will be included (prepended!) in the posts you retrieve whether you want it or not. To suppress this behaviour use ignore_sticky_posts
'post__not_in' => array(1,2,3), //(array) - use post ids. Specify post NOT to retrieve.
//NOTE: you cannot combine 'post__in' and 'post__not_in' in the same query
//////Password Parameters - Show content based on post and page parameters. Remember that default post_type is only set to display posts but not pages.
//http://codex.wordpress.org/Class_Reference/WP_Query#Password_Parameters
'has_password' => true, //(bool) - available with Version 3.9
//true for posts with passwords;
//false for posts without passwords;
//null for all posts with and without passwords
'post_password' => 'multi-pass', //(string) - show posts with a particular password (available with Version 3.9)
//////Type & Status Parameters - Show posts associated with certain type or status.
//http://codex.wordpress.org/Class_Reference/WP_Query#Type_Parameters
'post_type' => array( //(string / array) - use post types. Retrieves posts by Post Types, default value is 'post';
'post', // - a post.
'page', // - a page.
'revision', // - a revision.
'attachment', // - an attachment. The default WP_Query sets 'post_status'=>'published', but atchments default to 'post_status'=>'inherit' so you'll need to set the status to 'inherit' or 'any'.
'my-post-type', // - Custom Post Types (e.g. movies)
),
//NOTE: The 'any' keyword available to both post_type and post_status queries cannot be used within an array.
'post_type' => 'any', // - retrieves any type except revisions and types with 'exclude_from_search' set to true.
//////Type & Status Parameters - Show posts associated with certain type or status.
//http://codex.wordpress.org/Class_Reference/WP_Query#Status_Parameters
'post_status' => array( //(string / array) - use post status. Retrieves posts by Post Status, default value i'publish'.
'publish', // - a published post or page.
'pending', // - post is pending review.
'draft', // - a post in draft status.
'auto-draft', // - a newly created post, with no content.
'future', // - a post to publish in the future.
'private', // - not visible to users who are not logged in.
'inherit', // - a revision. see get_children.
'trash' // - post is in trashbin (available with Version 2.9).
),
//NOTE: The 'any' keyword available to both post_type and post_status queries cannot be used within an array.
'post_status' => 'any', // - retrieves any status except those from post types with 'exclude_from_search' set to true.
//////Pagination Parameters
//http://codex.wordpress.org/Class_Reference/WP_Query#Pagination_Parameters
'posts_per_page' => 10, //(int) - number of post to show per page (available with Version 2.1). Use 'posts_per_page' => -1 to show all posts.
//Note: if the query is in a feed, wordpress overwrites this parameter with the stored 'posts_per_rss' option. Treimpose the limit, try using the 'post_limits' filter, or filter 'pre_option_posts_per_rss' and return -1
'posts_per_archive_page' => 10, //(int) - number of posts to show per page - on archive pages only. Over-rides showposts anposts_per_page on pages where is_archive() or is_search() would be true
'nopaging' => false, //(bool) - show all posts or use pagination. Default value is 'false', use paging.
'paged' => get_query_var('paged'), //(int) - number of page. Show the posts that would normally show up just on page X when usinthe "Older Entries" link.
//NOTE: Use get_query_var('page'); if you want your query to work in a Page template that you've set as your static front page. The query variable 'page' holds the pagenumber for a single paginated Post or Page that includes the <!--nextpage--> Quicktag in the post content.
'nopaging' => false, // (boolean) - show all posts or use pagination. Default value is 'false', use paging.
'posts_per_archive_page' => 10, // (int) - number of posts to show per page - on archive pages only. Over-rides posts_per_page and showposts on pages where is_archive() or is_search() would be true.
'offset' => 3, // (int) - number of post to displace or pass over.
// Warning: Setting the offset parameter overrides/ignores the paged parameter and breaks pagination. for a workaround see: http://codex.wordpress.org/Making_Custom_Queries_using_Offset_and_Pagination
// The 'offset' parameter is ignored when 'posts_per_page'=>-1 (show all posts) is used.
'paged' => get_query_var('paged'), //(int) - number of page. Show the posts that would normally show up just on page X when usinthe "Older Entries" link.
//NOTE: This whole paging thing gets tricky. Some links to help you out:
// http://codex.wordpress.org/Function_Reference/next_posts_link#Usage_when_querying_the_loop_with_WP_Query
// http://codex.wordpress.org/Pagination#Troubleshooting_Broken_Pagination
'page' => get_query_var('page'), // (int) - number of page for a static front page. Show the posts that would normally show up just on page X of a Static Front Page.
//NOTE: The query variable 'page' holds the pagenumber for a single paginated Post or Page that includes the <!--nextpage--> Quicktag in the post content.
'ignore_sticky_posts' => false, // (boolean) - ignore sticky posts or not (available with Version 3.1, replaced caller_get_posts parameter). Default value is 0 - don't ignore sticky posts. Note: ignore/exclude sticky posts being included at the beginning of posts returned, but the sticky post will still be returned in the natural order of that list of posts returned.
//////Order & Orderby Parameters - Sort retrieved posts.
//http://codex.wordpress.org/Class_Reference/WP_Query#Order_.26_Orderby_Parameters
'order' => 'DESC', //(string) - Designates the ascending or descending order of the 'orderby' parameter. Default to 'DESC'.
//Possible Values:
//'ASC' - ascending order from lowest to highest values (1, 2, 3; a, b, c).
//'DESC' - descending order from highest to lowest values (3, 2, 1; c, b, a).
'orderby' => 'date', //(string) - Sort retrieved posts by parameter. Defaults to 'date'. One or more options can be passed. EX: 'orderby' => 'menu_order title'
//Possible Values:
//'none' - No order (available with Version 2.8).
//'ID' - Order by post id. Note the captialization.
//'author' - Order by author.
//'title' - Order by title.
//'name' - Order by post name (post slug).
//'date' - Order by date.
//'modified' - Order by last modified date.
//'parent' - Order by post/page parent id.
//'rand' - Random order.
//'comment_count' - Order by number of comments (available with Version 2.9).
//'menu_order' - Order by Page Order. Used most often for Pages (Order field in the EdiPage Attributes box) and for Attachments (the integer fields in the Insert / Upload MediGallery dialog), but could be used for any post type with distinct 'menu_order' values (theall default to 0).
//'meta_value' - Note that a 'meta_key=keyname' must also be present in the query. Note alsthat the sorting will be alphabetical which is fine for strings (i.e. words), but can bunexpected for numbers (e.g. 1, 3, 34, 4, 56, 6, etc, rather than 1, 3, 4, 6, 34, 56 as yomight naturally expect).
//'meta_value_num' - Order by numeric meta value (available with Version 2.8). Also notthat a 'meta_key=keyname' must also be present in the query. This value allows for numericasorting as noted above in 'meta_value'.
//'title menu_order' - Order by both menu_order AND title at the same time. For more info see: http://wordpress.stackexchange.com/questions/2969/order-by-menu-order-and-title
//'post__in' - Preserve post ID order given in the post__in array (available with Version 3.5).
//////Date Parameters - Show posts associated with a certain time and date period.
//http://codex.wordpress.org/Class_Reference/WP_Query#Date_Parameters
'year' => 2014, //(int) - 4 digit year (e.g. 2011).
'monthnum' => 4, //(int) - Month number (from 1 to 12).
'w' => 25, //(int) - Week of the year (from 0 to 53). Uses the MySQL WEEK command. The mode is dependenon the "start_of_week" option.
'day' => 17, //(int) - Day of the month (from 1 to 31).
'hour' => 13, //(int) - Hour (from 0 to 23).
'minute' => 19, //(int) - Minute (from 0 to 60).
'second' => 30, //(int) - Second (0 to 60).
'm' => 201404, //(int) - YearMonth (For e.g.: 201307).
'date_query' => array( //(array) - Date parameters (available with Version 3.7).
//these are super powerful. check out the codex for more comprehensive code examples http://codex.wordpress.org/Class_Reference/WP_Query#Date_Parameters
array(
'year' => 2014, //(int) - 4 digit year (e.g. 2011).
'month' => 4 //(int) - Month number (from 1 to 12).
'week' => 31 //(int) - Week of the year (from 0 to 53).
'day' => 5 //(int) - Day of the month (from 1 to 31).
'hour' => 2 //(int) - Hour (from 0 to 23).
'minute' => 3 //(int) - Minute (from 0 to 59).
'second' => 36 //(int) - Second (0 to 59).
'after' => 'January 1st, 2013', //(string/array) - Date to retrieve posts after. Accepts strtotime()-compatible string, or array of 'year', 'month', 'day'
'before' => array( //(string/array) - Date to retrieve posts after. Accepts strtotime()-compatible string, or array of 'year', 'month', 'day'
'year' => 2013, //(string) Accepts any four-digit year. Default is empty.
'month' => 2, //(string) The month of the year. Accepts numbers 1-12. Default: 12.
'day' => 28, //(string) The day of the month. Accepts numbers 1-31. Default: last day of month.
),
'inclusive' => true, //(boolean) - For after/before, whether exact value should be matched or not'.
'compare' => '=', //(string) - Possible values are '=', '!=', '>', '>=', '<', '<=', 'LIKE', 'NOT LIKE', 'IN', 'NOT IN', 'BETWEEN', 'NOT BETWEEN', 'EXISTS' (only in WP >= 3.5), and 'NOT EXISTS' (also only in WP >= 3.5). Default value is '='
'column' => 'post_date', //(string) - Column to query against. Default: 'post_date'.
'relation' => 'AND', //(string) - OR or AND, how the sub-arrays should be compared. Default: AND.
),
),
//////Custom Field Parameters - Show posts associated with a certain custom field.
//http://codex.wordpress.org/Class_Reference/WP_Query#Custom_Field_Parameters
'meta_key' => 'key', //(string) - Custom field key.
'meta_value' => 'value', //(string) - Custom field value.
'meta_value_num' => 10, //(number) - Custom field value.
'meta_compare' => '=', //(string) - Operator to test the 'meta_value'. Possible values are '!=', '>', '>=', '<', or ='. Default value is '='.
'meta_query' => array( //(array) - Custom field parameters (available with Version 3.1).
'relation' => 'AND', //(string) - Possible values are 'AND', 'OR'. The logical relationship between each inner meta_query array when there is more than one. Do not use with a single inner meta_query array.
array(
'key' => 'color', //(string) - Custom field key.
'value' => 'blue' //(string/array) - Custom field value (Note: Array support is limited to a compare value of 'IN', 'NOT IN', 'BETWEEN', or 'NOT BETWEEN') Using WP < 3.9? Check out this page for details: http://codex.wordpress.org/Class_Reference/WP_Query#Custom_Field_Parameters
'type' => 'CHAR', //(string) - Custom field type. Possible values are 'NUMERIC', 'BINARY', 'CHAR', 'DATE', 'DATETIME', 'DECIMAL', 'SIGNED', 'TIME', 'UNSIGNED'. Default value is 'CHAR'. The 'type' DATE works with the 'compare' value BETWEEN only if the date is stored at the format YYYYMMDD and tested with this format.
//NOTE: The 'type' DATE works with the 'compare' value BETWEEN only if the date is stored at the format YYYYMMDD and tested with this format.
'compare' => '=' //(string) - Operator to test. Possible values are '=', '!=', '>', '>=', '<', '<=', 'LIKE', 'NOT LIKE', 'IN', 'NOT IN', 'BETWEEN', 'NOT BETWEEN', 'EXISTS' (only in WP >= 3.5), and 'NOT EXISTS' (also only in WP >= 3.5). Default value is '='.
),
array(
'key' => 'price',
'value' => array( 1,200 ),
'compare' => 'NOT LIKE'
)
),
//////Permission Parameters - Display published posts, as well as private posts, if the user has the appropriate capability:
//http://codex.wordpress.org/Class_Reference/WP_Query#Permission_Parameters
'perm' => 'readable' //(string) Possible values are 'readable', 'editable'
//////Caching Parameters
//http://codex.wordpress.org/Class_Reference/WP_Query#Caching_Parameters
//NOTE Caching is a good thing. Setting these to false is generally not advised.
'cache_results' => true, //(bool) Default is true - Post information cache.
'update_post_term_cache' => true, //(bool) Default is true - Post meta information cache.
'update_post_meta_cache' => true, //(bool) Default is true - Post term information cache.
'no_found_rows' => false, //(bool) Default is false. WordPress uses SQL_CALC_FOUND_ROWS in most queries in order to implement pagination. Even when you don’t need pagination at all. By Setting this parameter to true you are telling wordPress not to count the total rows and reducing load on the DB. Pagination will NOT WORK when this parameter is set to true. For more information see: http://flavio.tordini.org/speed-up-wordpress-get_posts-and-query_posts-functions
//////Search Parameter
//http://codex.wordpress.org/Class_Reference/WP_Query#Search_Parameter
's' => $s, //(string) - Passes along the query string variable from a search. For example usage see: http://www.wprecipes.com/how-to-display-the-number-of-results-in-wordpress-search
'exact' => true, //(bool) - flag to make it only match whole titles/posts - Default value is false. For more information see: https://gist.github.com/2023628#gistcomment-285118
'sentence' => true, //(bool) - flag to make it do a phrase search - Default value is false. For more information see: https://gist.github.com/2023628#gistcomment-285118
//////Post Field Parameters
//For more info see: http://codex.wordpress.org/Class_Reference/WP_Query#Return_Fields_Parameter
//also https://gist.github.com/luetkemj/2023628/#comment-1003542
'fields' => 'ids' //(string) - Which fields to return. All fields are returned by default.
//Possible values:
//'ids' - Return an array of post IDs.
//'id=>parent' - Return an associative array [ parent => ID, … ].
//Passing anything else will return all fields (default) - an array of post objects.
//////Filters
//For more information on available Filters see: http://codex.wordpress.org/Class_Reference/WP_Query#Filters
);
$the_query = new WP_Query( $args );
// The Loop
if ( $the_query->have_posts() ) :
while ( $the_query->have_posts() ) : $the_query->the_post();
// Do Stuff
endwhile;
endif;
// Reset Post Data
wp_reset_postdata();
?>
@luetkemj
Owner
luetkemj commented on 13 Mar 2012
Of course you would never use a query like this. It's just a comprehensive grouping for quick reference.
Also formatting in the github and raw view sucks. best to copy the raw and past in a code editor. I wrote this in SublimeText if that helps.
EDIT: Fixed formatting issues
@ryanduff
ryanduff commented on 13 Mar 2012
You're missing the undocumented no_found_rows parameter. It takes a boolean value so I usually use true instead of 1 in this example: http://flavio.tordini.org/speed-up-wordpress-get_posts-and-query_posts-functions
@luetkemj
Owner
luetkemj commented on 13 Mar 2012
Thanks Ryan, I added no_found_rows into the caching section at the bottom. If you think it belongs somewhere else I'm open to suggestions. Regarding using true/false vs 1/0 for booleans, is that just a preference or is there a best practice or other reason in there to choose one over the other?
@ryanduff
ryanduff commented on 14 Mar 2012
Mark,
I'd agree caching is probably an appropriate place for it.
As far as the booleans, I think it's best practice. 0/1 works in most applications, but it's expecting a truth value AKA TRUE/FALSE. PHP will translate 0 to false and 1 to true, but it's seen as a string so you can run in to problems. For example 0.00 will return true instead of false because it's seen as a string and it doesn't explicitly match "0". For that reason, I've always specified TRUE/FALSE when a boolean is expected because it makes sense and is easier to think about in the literal sense rather than 0/1. More on PHP's handling of booleans here: http://php.net/manual/en/language.types.boolean.php
@luetkemj
Owner
luetkemj commented on 14 Mar 2012
Thanks Ryan, good call on writing out the keywords True/False. Makes a lot of sense. Will be updating the code shortly.
@HoundstoothSTL
HoundstoothSTL commented on 15 Mar 2012
This is solid, thanks for posting!
@PotterSys
PotterSys commented on 15 Mar 2012
It seems a the closing parenthesis for the whole array is missing on the 'tax_query' array
@luetkemj
Owner
luetkemj commented on 15 Mar 2012
Thanks PotterSys, fixing now.
EDIT: Closed tax query array properly per PotterSys comment ^
@Japh
Japh commented on 15 Mar 2012
Great reference, thanks! :)
@fjarrett
fjarrett commented on 16 Mar 2012
Thanks for sharing!
@rabinbiswas
rabinbiswas commented on 18 Mar 2012
First of all You did a great job compiling this in one file, congrats and thanks for it.
I have posted your work on my site http://updateox.com/wordpress/wp-query-quick-reference-with-all-its-parameters/ with all of your reference of course. I hope you won't mind it.
@luetkemj
Owner
luetkemj commented on 19 Mar 2012
@rabinbiswas Thanks! Don't mind at all, nice to see others find it useful.
@littlefyr
littlefyr commented on 21 Mar 2012
@luetkemj -- there is nothing better, IMHO, than a pathological example to know what's going on. The next thing would be comprehensive examples, but that would be a whole lot more work.
I did notice small error. Well, its theoretically correct, but probably isn't given what preceeds. In tag_slug__and and tag_slug__in have arrays of ints for their values but I think you want an array of strings.
@luetkemj
Owner
luetkemj commented on 21 Mar 2012
@adsmart, that is def an error, thanks for the catch!
@r-a-y
r-a-y commented on 28 Mar 2012
Nice! Just wanted to note that you're missing the 's' parameter for searching the post title and content.
@ryanduff
ryanduff commented on 28 Mar 2012
More or less passing along the search from the query string ($s) into the query...
new WP_Query("s=$s&showposts=-1");
@luetkemj
Owner
luetkemj commented on 28 Mar 2012
I didn't know about that one! Very interesting, will add it tomorrow.
@luetkemj
Owner
luetkemj commented on 28 Mar 2012
Added "Search Parameter " section based on r-a-y and ryanduff's suggestions.
@ihorvorotnov
ihorvorotnov commented on 1 Apr 2012
Great job, thanks for sharing!
@eoinkelly
eoinkelly commented on 14 Apr 2012
Very handy reference. Good job.
@eoinkelly
eoinkelly commented on 16 Apr 2012
I just noticed that WordPress treats the 'any' value for 'post_type' differently to other values. It is treated as a special "keyword" and it cannot be in an array e.g.
$my_query = new WP_Query(array('post_type' => array('post'))); // Works
$my_query = new WP_Query(array('post_type' => array('post','page'))); // Works
$my_query = new WP_Query(array('post_type' => array('any'))); // Does not work
$my_query = new WP_Query(array('post_type' => 'any')); // Works
I think it would be worth updating this gist to reflect that.
cheers
/Eoin/
@luetkemj
Owner
luetkemj commented on 16 Apr 2012
@eoinkelly
Very interesting, thanks for the catch, Gist has been updated.
@andredublin
andredublin commented on 25 Apr 2012
thank you for this
@saas786
saas786 commented on 28 Apr 2012
Thanks.
@saas786
saas786 commented on 28 Apr 2012
I would like you to add this if you don't mind.
with :]-> 's' => $s
compare is very useful
[{ compare (string) - Operator to test. Possible values are '=', '!=', '>', '>=', '<', '<=', 'LIKE', 'NOT LIKE', 'IN', 'NOT IN', 'BETWEEN', 'NOT BETWEEN'. Default value is '='.}]
And also sentence is very useful if we want users to search for exact words (like "why search for exact words") if we use sentence = true then wordpress will search the whole sentence & depending upon the compare parameter. But if we don't use sentence parameter wordpress will split each word and search for each word in database depending upon the compare.
I hope my comment makes sense to you. I am not good with words though ;)
@luetkemj
Owner
luetkemj commented on 28 Apr 2012
@saas786
Thanks for these! Will take a closer look on monday and add them.
@luetkemj
Owner
luetkemj commented on 30 Apr 2012
@saas786
I added the additions you mentioned. Please review and let me know if they are accurate. From some research I found an old post that mentions an "exact" flag as well: http://wordpress.org/support/topic/how-to-search-phrases
I didn't add this as it seems that you could do the same thing with the compare parameters. Have you used "exact" before? Currently I'm leaning towards not including it here.
@saas786
saas786 commented on 1 May 2012
@luetkemj
Thanks for adding it. Yes "exact" flag / parameter is correct. @Otto is an experienced guy, so his comments are valid. I further explored it and found that compare has no impact on search query instead exact is used for comparison.
//////Search Parameter
's' => $s,
'exact' => true // if set to true then search will be like "LIKE 'search_term')" if set to false then it will be like "LIKE '%ssearch_term%s')"
'sentance' => true
you can remove the compare parameter from the list and I found no impact on query (I thought it was the compare parameter that made impact on my search query, but instead it was "exact" flag / parameter.
Thanks.
@luetkemj
Owner
luetkemj commented on 1 May 2012
@saas786
Thanks for checking up on that, I didn't have time this morning to do an actual test. I have used a mix of the verbiage from you, myself, and Otto as well a link to the comments here for more info.
@cam5
cam5 commented on 28 Jun 2012
You are a good man, luetkemj.
@luetkemj
Owner
luetkemj commented on 28 Jun 2012
Thanks @cam5 :)
@sanchothefat
sanchothefat commented on 26 Jul 2012
Epic
@charlietriplett
charlietriplett commented on 27 Jul 2012
Something I had to do today - Mix/Match Orderby:
Sort a custom post type (people) by last name (by default) or by menu_order (when the posts have a menu order entered).
The title field is always lastnamef, which made me think I could do this:
'orderby' => 'menu_order title',
It doesn't seem to work consistently for my custom post type.
But from this post:
http://wordpress.org/support/topic/order-by-slug-not-work
And from this post:
http://wordpress.stackexchange.com/questions/2969/order-by-menu-order-and-title
I deduced this - which does work:
'orderby' => 'menu_order name',
Might be worth adding.
@luetkemj
Owner
luetkemj commented on 27 Jul 2012
@charlietriplett, This is really interesting! Do you know if it works to just mix and match any of the orderby options?
This should definitely be added but I want to play around with it first to get a good idea on how to document it.
Thanks!
@charlietriplett
charlietriplett commented on 27 Jul 2012
I don't — and I don't understand why 'menu_order title' isn't just as consistent. Hrmm … But a very useful tool for sorting posts/pages. I'll be incorporating it into some automated child-nav features as well where some degree of custom ordering is desirable.
@keesiemeijer
keesiemeijer commented on 17 Sep 2012
//NOTE: You should set get_query_var( 'page' ); if you want your query to work with pagination. Since Wordpress 3.0.2, you dget_query_var( 'page' ) instead of get_query_var( 'paged' ). The pagination parameter 'paged' for WP_Query() remains the same.
This is only true for a paginated single post/page and for static front page pagination. I've updated the codex with this information here:
http://codex.wordpress.org/Function_Reference/WP_Query#Pagination_Parameters
Was the codex wrong or did something change recently?
@luetkemj
Owner
luetkemj commented on 18 Sep 2012
Thanks @keesiemeijer, I've actually been having issues pagination myself lately so this may be the problem. Gist has been updated.
@subharanjanm
subharanjanm commented on 4 Oct 2012
Is there any way to sort by meta_key where the meta_value contains date string in the format mm-dd-yyyy.
@wpsmith
wpsmith commented on 7 Dec 2012
@luetkemj 'author' => 1,2,3, should be 'author' => '1,2,3',
@wpsmith
wpsmith commented on 12 Dec 2012
'orderby' can now take 'post__in'.
@Krucamper
Krucamper commented on 19 Dec 2012
Thank you very much for all your help and useful
@fris
fris commented on 19 Feb 2013
great post ;)
@mi-ca
mi-ca commented on 7 Mar 2013
You make my day.
And not only this one..
This gist is very helpful.
Thanks a lot @luetkemj
@stvwlf
stvwlf commented on 9 Mar 2013
Just used 'post_parent' for the first time, to return child pages. It turns out you must also set 'post_type" => 'page' before it works. That is not well documented. It would be helpful to add that to the 'post_parent' comments.
@seamusO
seamusO commented on 16 Mar 2013
Is there a typo on line 168 - should "sentance" be "sentence"?
Thanks for the guide - it's exactly what I've being looking for.
@luetkemj
Owner
luetkemj commented on 22 Mar 2013
Gist updated.
Thanks to @charlietriplett, @wpsmith, and @stvwlf for keeping an eye on this thing.
If anyone notices anything I've missed or things that have been added since 3.5 let me know so I can keep this up to date!
@manifestcreative
manifestcreative commented on 27 Jul 2013
Perhaps I'm overlooking it, but the meta_query array accepts a 'relation' key which can have a value of either 'AND' or 'OR'.
@abhjiitpingale
abhjiitpingale commented on 1 Nov 2013
I want make relation between post query and meta query "OR". like post_type = "post" OR (meta_key = "key" AND meta_value = "value") so how can I do that please help me out
@michael-cannon
michael-cannon commented on 19 Nov 2013
@manifestcreative You're correct. In class WP_Meta_Query::__construct, a check for $meta_query['relation'] is made. AND is the default if none is set. The options are AND and OR.
@AkaHappyRoadGirl
AkaHappyRoadGirl commented on 23 Dec 2013
@luetkemj, I must say I'm your number one fan, this page is one of my most consulted. Thanks a lot!!!
@Dimasmagadan
Dimasmagadan commented on 12 Feb 2014
this link (line 173)
//Not sure what these do. For more info see: http://codex.wordpress.org/Class_Reference/WP_Query#Post_Field_Parameters
should be changed to this
http://codex.wordpress.org/Class_Reference/WP_Query#Return_Fields_Parameter
What it does is it changes the format of returned result. Say, you can pass 'fields' => 'ids' and it will return just IDs of matching posts.
@luetkemj
Owner
luetkemj commented on 17 Apr 2014
Bunch of updates per @manifestcreative and @Dimasmagadan comments. Thanks!
@luetkemj
Owner
luetkemj commented on 17 Apr 2014
Tons of new updates. Bringing the query up to date with things added in 3.5, 3.7, and 3.9.
Holy wow, I was slacking... sorry about that.
@sephelps
sephelps commented on 10 May 2014
the line 'category_name' => 'staff', 'news', is invalid. Should just be one of those or an array, right?
@luetkemj
Owner
luetkemj commented on 18 Jun 2014
@sephelps - yep! that was busted. But it is supposed to be a string. You can display posts that have any of the named categories if you wrap the whole thing in a string, commas and all.
Alternately you can display posts that have "all" of the categories if you use a "+" instead of a ","
'staff,news' or 'staff+news',
Gist has been updated.
See this page for more details on the above:
http://codex.wordpress.org/Class_Reference/WP_Query#Category_Parameters
@shokry055
shokry055 commented on 22 Nov 2014
thanks so much
@dgamboaestrada
dgamboaestrada commented on 3 Jun 2015
Thank you very much
@jgacuca567
jgacuca567 commented on 12 Jun 2015
Please add a comma at the end of line 14,
@luetkemj
Owner
luetkemj commented on 12 Jun 2015
@jgacuca567 - done - thanks for the catch
@brubrant
brubrant commented on 21 Jul 2015
@luetkemj thanks for this awesome Gist. I come here very often!
Just want to say that some pagination parameters are repeated...
@pageii
pageii commented on 14 Oct 2015
@luetkemj Just want to say thanks for posting. It's very comprehensive and saved me tons.
@s3rgiosan
s3rgiosan commented on 16 Oct 2015
Hi @luetkemj, first of all thanks for this comprehensive list.
Param posts_per_page is duplicated and the first reference has a typo.
It should be Use 'posts_per_page'=-1 to show all posts..
The second reference is correct.
@luetkemj
Owner
luetkemj commented on 16 Nov 2015
Thanks for the catch @brubrant and @s3rgiosan!
@pradeeprath22
pradeeprath22 commented on 23 Dec 2015
Usage Standard Loop
<?php
// The Query
$the_query = new WP_Query( $args );
// The Loop
if ( $the_query->have_posts() ) {
echo '<ul>';
while ( $the_query->have_posts() ) {
$the_query->the_post();
echo '<li>' . get_the_title() . '</li>';
}
echo '</ul>';
} else {
// no posts found
}
/* Restore original Post Data */
wp_reset_postdata();
Note: If you use the_post() with your query, you need to run wp_reset_postdata() afterwards to have Template Tags use the main query's current post again.
http://goatripsindia.com/
@noplan1989
Write Preview
Leave a comment
Attach files by dragging & dropping, ファイル選択 selecting them, or pasting from the clipboard.
Styling with Markdown is supported
Comment
Status API Training Shop Blog About Pricing
© 2016 GitHub, Inc. Terms Privacy Security Contact Help
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment