Changeset 33706

Timestamp:

08/22/2015 04:58:21 PM (10 years ago)

Author:

wonderboymusic

Message:

Query:

Add a query var, title, that allows you to query posts by post_title. To accomplish this now, you have to do something like:

$tacos = get_posts( [
  'post_type' => 'taco',
  's' => $name,
  'exact' => true,
  'sentence' => true,
  'post_status' => 'publish',
  'fields' => 'ids',
  'posts_per_page' => 1
] );

Adds unit tests.

Fixes #33074.

Location:

trunk

Files:

• src/wp-includes/class-wp.php (modified) (1 diff)
• src/wp-includes/query.php (modified) (4 diffs)
• tests/phpunit/tests/query/results.php (modified) (1 diff)

trunk/src/wp-includes/class-wp.php

@@ -16 +16 @@
      * @var array
      */
-    public $public_query_vars = array('m', 'p', 'posts', 'w', 'cat', 'withcomments', 'withoutcomments', 's', 'search', 'exact', 'sentence', 'calendar', 'page', 'paged', 'more', 'tb', 'pb', 'author', 'order', 'orderby', 'year', 'monthnum', 'day', 'hour', 'minute', 'second', 'name', 'category_name', 'tag', 'feed', 'author_name', 'static', 'pagename', 'page_id', 'error', 'comments_popup', 'attachment', 'attachment_id', 'subpost', 'subpost_id', 'preview', 'robots', 'taxonomy', 'term', 'cpage', 'post_type');
+    public $public_query_vars = array('m', 'p', 'posts', 'w', 'cat', 'withcomments', 'withoutcomments', 's', 'search', 'exact', 'sentence', 'calendar', 'page', 'paged', 'more', 'tb', 'pb', 'author', 'order', 'orderby', 'year', 'monthnum', 'day', 'hour', 'minute', 'second', 'name', 'category_name', 'tag', 'feed', 'author_name', 'static', 'pagename', 'page_id', 'error', 'comments_popup', 'attachment', 'attachment_id', 'subpost', 'subpost_id', 'preview', 'robots', 'taxonomy', 'term', 'cpage', 'post_type', 'title');
 
     /**

trunk/src/wp-includes/query.php

@@ -1426 +1426 @@
             , 's'
             , 'sentence'
+            , 'title'
             , 'fields'
             , 'menu_order'
@@ -1545 +1546 @@
      *     @type array        $tax_query               An associative array of WP_Tax_Query arguments.
      *                                                 {@see WP_Tax_Query->queries}
+     *     @type string       $title                   Post title.
      *     @type bool         $update_post_meta_cache  Whether to update the post meta cache. Default true.
      *     @type bool         $update_post_term_cache  Whether to update the post term cache. Default true.
@@ -1578 +1580 @@
         $qv['pagename'] = trim( $qv['pagename'] );
         $qv['name'] = trim( $qv['name'] );
+        $qv['title'] = trim( $qv['title'] );
         if ( '' !== $qv['hour'] ) $qv['hour'] = absint($qv['hour']);
         if ( '' !== $qv['minute'] ) $qv['minute'] = absint($qv['minute']);
@@ -2606 +2609 @@
         }
 
+        if ( '' !== $q['title'] ) {
+            $where .= $wpdb->prepare( " AND $wpdb->posts.post_title = %s", stripslashes( $q['title'] ) );
+        }
+
         // Parameters related to 'post_name'.
         if ( '' != $q['name'] ) {

trunk/tests/phpunit/tests/query/results.php

@@ -704 +704 @@
     }
 
+    function test_title() {
+        $title = 'Tacos are Cool';
+        $post_id = $this->factory->post->create( array(
+            'post_title' => $title,
+            'post_type' => 'post',
+            'post_status' => 'publish'
+        ) );
+
+        $result1 = $this->q->query( array( 'title' => $title, 'fields' => 'ids' ) );
+        $this->assertCount( 1, $result1 );
+        $this->assertContains( $post_id, $result1 );
+
+        $result2 = $this->q->query( array( 'title' => 'Tacos', 'fields' => 'ids' ) );
+        $this->assertCount( 0, $result2 );
+    }
 }