我正在尝试在Wordpress中扩展自定义用户搜索;即,我想按城市、州和国家搜索用户,但这些数据是序列化的。我的例子
元密钥:pie_address_3
元值:a:6:{s:7:"address";s:18:"New York Street, 4";s:8:"address2";s:0:"";s:4:"city";s:5:"Venice";s:5:"state";s:7:"Vicenza";s:3:"zip";s:5:"36015";s:7:"country";s:5:"Italy";}
以下是我要做的:
$my_users = new WP_User_Query(
array(
'role' => $role,
'search' => '*' . $search . '*',
'search_columns' => array(
'user_login',
'user_nicename',
'user_email',
'user_url',
'display_name'
),
'meta_query' => array(
'key' => 'pie_address_3',
'value' => $search,
'compare' => 'LIKE'
)
));
但是,当我键入某个国家或城市(我知道它与某个用户相关)时,搜索结果不会返回任何结果。我该如何处理?谢谢
更新
我更新了WP_User_Query
,如下所示:
$args = array(
'meta_key' => 'pie_address_3'
);
$query = new WP_User_Query($args);
$authors = $query->get_results();
foreach ($authors as $author){
$c = get_user_meta($author->id,'pie_address_3',true);
if(isset($c)){
if(empty(get_user_meta($author->id,'address',true))){
add_user_meta($author->ID,'address',$c['address']);
}
if(empty(get_user_meta($author->id,'address2',true))){
add_user_meta($author->ID,'address2',$c['address2']);
}
if(empty(get_user_meta($author->id,'city',true))){
add_user_meta($author->ID,'city',$c['city']);
}
if(empty(get_user_meta($author->id,'state',true))){
add_user_meta($author->ID,'state',$c['state']);
}
if(empty(get_user_meta($author->id,'zip',true))){
add_user_meta($author->ID,'zip',$c['zip']);
}
if(empty(get_user_meta($author->id,'country',true))){
add_user_meta($author->ID,'country',$c['country']);
};
//delete_user_meta($author->ID,'pie_address_3',$c);
}
}
$my_users = new WP_User_Query(
array(
'role' => $role,
'search' => '*' . $search . '*',
'search_columns' => array(
'user_login',
'user_nicename',
'user_email',
'user_url',
'display_name'
),
'meta_query' => array(
'relation' => 'OR',
array(
'key' => 'address',
'value' => $search,
'compare' => 'LIKE'
),
array(
'key' => 'address2',
'value' => $search,
'compare' => 'LIKE'
),
array(
'key' => 'city',
'value' => $search,
'compare' => 'LIKE'
),
array(
'key' => 'state',
'value' => $search,
'compare' => 'LIKE'
),
array(
'key' => 'zip',
'value' => $search,
'compare' => 'LIKE'
),
array(
'key' => 'country',
'value' => $search,
'compare' => 'LIKE'
)
)
)
);
但是,它仍然不起作用。我哪里做错了?
更新的答案
我意识到您需要在pie_address_3
字段中查找包含字符串$search
的用户OR,至少在其他列中查找一个。
不幸的是,WP_User_Query
似乎不允许列和元字段之间存在OR关系。事实上,结果查询的"条件"部分是这样的:
WHERE (
user_login LIKE '%$search%' OR
user_nicename LIKE '%$search%' OR
user_email LIKE '%$search%' OR
user_url LIKE '%$search%'
) AND (
wp_usermeta.meta_key = 'pie_address_3' AND
CAST(wp_usermeta.meta_value AS CHAR) LIKE '%$search%'
)
请注意,AND位于两部分之间。
有一个钩子pre_user_query
,它在解析WP_User_Query
之后和执行查询之前激发,通过引用传递当前WP_User_Query
实例。因此,我们可以截取and并将其更改为OR,方法是将此代码包含在我们的functions.php
文件中:
add_action('pre_user_query', 'my_custom_users_search');
function my_custom_users_search( $args ) {
$args->query_where = str_replace(') AND (', ') OR (', $args->query_where);
}
这将使以下查询工作:
$my_users = new WP_User_Query(
array(
'role' => $role,
'search' => '*' . $search . '*',
'search_columns' => array(
'user_login',
'user_nicename',
'user_email',
'user_url',
'display_name'
),
'meta_key' => 'pie_address_3',
'meta_value' => $search,
'meta_compare' => 'LIKE'
)
);
警告:前面的操作函数可能会影响每个WP_User_Query
调用!
为了防止这种情况,我们可以向WP_User_Query
函数传递一个伪参数,并且只有在传递了该参数的情况下,才能更改OR中的and。这是一个带有and2or
伪参数的查询:
$my_users = new WP_User_Query(
array(
'and2or' => 1,
'role' => $role,
'search' => '*' . $search . '*',
'search_columns' => array(
'user_login',
'user_nicename',
'user_email',
'user_url',
'display_name'
),
'meta_key' => 'pie_address_3',
'meta_value' => $search,
'meta_compare' => 'LIKE'
)
);
这就是作用函数:
add_action('pre_user_query', 'my_custom_users_search');
function my_custom_users_search( $args ) {
if( isset( $args->query_vars['and2or'] ) )
$args->query_where = str_replace(') AND (', ') OR (', $args->query_where);
}
老答案
这是搜索序列化元字段的查询(没有必要像更新时那样对其进行拆分):
$my_users = new WP_User_Query(
array(
'role' => $role,
'meta_key' => 'pie_address_3',
'meta_value' => $search,
'meta_compare' => 'LIKE'
)
);
在查询中,您甚至在search_columns
参数中指定的字段上搜索$search
。
试试这个
$user_query = new WP_User_Query( array( 'meta_key' => 'pie_address_3', 'meta_value' => $keyword, 'meta_compare' => 'LIKE' ) );
compare (string) - Operator to test. Possible values are '=', '!=', '>', '>=', '<', '<=', 'LIKE', 'NOT LIKE', 'IN', 'NOT IN', 'BETWEEN', 'NOT BETWEEN', 'EXISTS', and 'NOT EXISTS'. Default value is '='.