search - Query first and last name from custom post type

admin管理员组

文章数量:1417555

I want to query first and last name using custom post type metaboxes.

Code i am using:

$name = 'John Doe';

$args = array( 
    'post_type'     => 'customers',
    'post_status'   => array( 'publish', 'pending', 'draft' ),
    'numberposts'   => -1,
    'order'         => 'ASC',
    'orderby'       => 'meta_value',
    'meta_key'      => 'customer_first_name'
    'meta_query'    => array(
        'relation'      => 'OR',
        array(
            'key'           => 'customer_first_name',
            'value'         => $name,
            'compare'       => 'LIKE',
        ),
        array(
            'key'           => 'customer_last_name',
            'value'         => $name,
            'compare'       => 'LIKE',
        ),      
    ),  
);  

$customers = get_posts($args);

$num = count( $customers );

If i search only "John" results are showing up. If i search full name "John Doe" there are no results. Why is that?

I want to query first and last name using custom post type metaboxes.

Code i am using:

$name = 'John Doe';

$args = array( 
    'post_type'     => 'customers',
    'post_status'   => array( 'publish', 'pending', 'draft' ),
    'numberposts'   => -1,
    'order'         => 'ASC',
    'orderby'       => 'meta_value',
    'meta_key'      => 'customer_first_name'
    'meta_query'    => array(
        'relation'      => 'OR',
        array(
            'key'           => 'customer_first_name',
            'value'         => $name,
            'compare'       => 'LIKE',
        ),
        array(
            'key'           => 'customer_last_name',
            'value'         => $name,
            'compare'       => 'LIKE',
        ),      
    ),  
);  

$customers = get_posts($args);

$num = count( $customers );

If i search only "John" results are showing up. If i search full name "John Doe" there are no results. Why is that?

• custom-post-types
• search

Share Improve this question edited Aug 4, 2019 at 16:47 fuxia♦ 107k3939 gold badges255255 silver badges459459 bronze badges asked Aug 4, 2019 at 15:56 JosephMurphyJosephMurphy 311 bronze badge 1

• You're doing a LIKE comparison, which means that both the first and last names need to match `%John Doe%, which isn't going to work because neither field has both names. – Jacob Peattie Commented Aug 5, 2019 at 3:15

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

$name = 'John Doe';

// Split $name
$name = preg_split( '/\s+/', trim( $name ) );

// Set first name
$first_name = $name[0];

// Last name was provided?
$last_name = isset( $name[1] ) ? $name[1] : null;

// Define meta query args array
$meta_query_args = array();

// Set "first name" meta query or "first name" + "last name" if both exist
if ( is_null( $last_name ) ) {
    $meta_query_args[] = array(
        'key'     => 'customer_first_name',
        'value'   => $first_name,
        'compare' => 'LIKE',
    );
} else {
    $meta_query_args[] = array(
        'relation' => 'AND', // This is default, just trying to be descriptive
        array(
            'key'     => 'customer_first_name',
            'value'   => $first_name,
            'compare' => 'LIKE'
        ),
        array(
            'key'     => 'customer_last_name',
            'value'   => $last_name,
            'compare' => 'LIKE'
        )
    );
}

// Set 'meta_query' in your $args variable
$args['meta_query'] = $meta_query_args;

Note that you'll have to add extra code to support "last name" + "first name" besides of "first name" + "last name" (order matters).

本文标签： searchQuery first and last name from custom post type