wp query - search blog posts by author first name and or last name

admin管理员组

文章数量:1291309

I am trying to create and endpoint where blog posts can be searched by author first name and/or last name. I was trying to do this with WP_Query but it uses the user nice name for the search which is not working. Is there a way to do this using a built in query or do I need to do a custom SQL query?

add_action( 'rest_api_init', function () {
  register_rest_route( 'blog-posts/v1', 'blog-by-author', array(
    'methods' => 'POST',
    'callback' => 'get_posts_by_author',
    'permission_callback' => '__return_true',
  ) );
} );

function get_posts_by_author(WP_REST_Request $request) {
    $data = $request->get_params();
    $author_name = $data['author_name'];
    
   // this uses nice name, not first/last name
    $query = new WP_Query( array( 'author_name' => $author_name ) );
    
    return print_r($query);
}

I am trying to create and endpoint where blog posts can be searched by author first name and/or last name. I was trying to do this with WP_Query but it uses the user nice name for the search which is not working. Is there a way to do this using a built in query or do I need to do a custom SQL query?

add_action( 'rest_api_init', function () {
  register_rest_route( 'blog-posts/v1', 'blog-by-author', array(
    'methods' => 'POST',
    'callback' => 'get_posts_by_author',
    'permission_callback' => '__return_true',
  ) );
} );

function get_posts_by_author(WP_REST_Request $request) {
    $data = $request->get_params();
    $author_name = $data['author_name'];
    
   // this uses nice name, not first/last name
    $query = new WP_Query( array( 'author_name' => $author_name ) );
    
    return print_r($query);
}

• posts
• wp-query
• rest-api

Share Improve this question asked May 31, 2021 at 6:34 user8463989user8463989 59311 gold badge88 silver badges2424 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 1

Actually, when you set author_name, WP_Query will use get_user_by( 'slug', <author name> ) to find a user with the specified "nice name" (user_nicename) value, and if found, then WP_Query sets the author arg to the found user's ID.

Therefore you can follow the same approach, but you would use get_users() to find users having the specified first and/or last name and use the author (or author__in) arg with WP_Query. E.g.

$users = get_users( array(
    'meta_query'  => array(
        'relation' => 'OR',
        array(
            'key'     => 'first_name',
            'value'   => $request['author_name'],
            'compare' => 'LIKE',
        ),
        array(
            'key'     => 'last_name',
            'value'   => $request['author_name'],
            'compare' => 'LIKE',
        ),
    ),
    'fields'      => 'ID',
) );

if ( ! empty( $users ) ) {
    $query = new WP_Query( array( 'author' => $users[0] ) );
    // or to include all found users..
//  $query = new WP_Query( array( 'author__in' => $users ) );

    // ... your code.
}

Additional Notes

• You don't have to do the $data = $request->get_params(); because you could just access parameters via direct array access on the WP_REST_Request object, e.g. $request['author_name'] like in my example above.

• You should register author_name using args in the third parameter for register_rest_route(), or at least, check that it's not empty before calling get_users().

• I know the print_r() in your code is just for testing, but the function will actually echo the output unless if the second parameter is set to true..

本文标签： wp querysearch blog posts by author first name and or last name