php 如何查找人名,让WordPress后台用户列表可以搜索名字、姓氏和公开显示名

/*

* 让WordPress后台用户列表可以搜索名字、姓氏和公开显示名

* From https://www.wpdaxue.com/wordpress-user-search.html

*/

//让函数只应用于WordPress后台

if (is_admin()) {

//通过钩子挂载函数

add_action('pre_user_query', 'wpdaxue_pre_user_query');

}

function wpdaxue_pre_user_query($user_search) {

global $wpdb;

$vars = $user_search->query_vars;

if (!is_null($vars['search'])) {

// 出于某种原因，搜索词被星号包括，删除它们

$search = preg_replace('/^\*/', '', $vars['search']);

$search = preg_replace('/\*$/', '', $search);

//搜索公开显示名

if(!empty($search)){

$user_search->query_where = substr(trim($user_search->query_where), 0, -1) . " OR display_name LIKE '%". $search . "%')";

}

//搜索名字和姓氏

$user_search->query_from .= " INNER JOIN {$wpdb->usermeta} m1 ON " .

"{$wpdb->users}.ID=m1.user_id AND (m1.meta_key='first_name')";

$user_search->query_from .= " INNER JOIN {$wpdb->usermeta} m2 ON " .

"{$wpdb->users}.ID=m2.user_id AND (m2.meta_key='last_name')";

$names_where = $wpdb->prepare("m1.meta_value LIKE '%s' OR m2.meta_value LIKE '%s'", "%{$search}%", "%$search%");

$user_search->query_where = str_replace('WHERE 1=1 AND (', "WHERE 1=1 AND ({$names_where} OR ", $user_search->query_where);

}

return $user_search;

}

/*

* 让WordPress后台用户列表可以搜索名字、姓氏和公开显示名

* From https://www.wpdaxue.com/wordpress-user-search.html

*/

//让函数只应用于WordPress后台

if (is_admin()) {

//通过钩子挂载函数

add_action('pre_user_query', 'wpdaxue_pre_user_query');

}

function wpdaxue_pre_user_query($user_search) {

global $wpdb;

$vars = $user_search->query_vars;

if (!is_null($vars['search'])) {

// 出于某种原因，搜索词被星号包括，删除它们

$search = preg_replace('/^\*/', '', $vars['search']);

$search = preg_replace('/\*$/', '', $search);

//搜索公开显示名

if(!empty($search)){

$user_search->query_where = substr(trim($user_search->query_where), 0, -1) . " OR display_name LIKE '%". $search . "%')";

}

//搜索名字和姓氏

$user_search->query_from .= " INNER JOIN {$wpdb->usermeta} m1 ON " .

"{$wpdb->users}.ID=m1.user_id AND (m1.meta_key='first_name')";

$user_search->query_from .= " INNER JOIN {$wpdb->usermeta} m2 ON " .

"{$wpdb->users}.ID=m2.user_id AND (m2.meta_key='last_name')";

$names_where = $wpdb->prepare("m1.meta_value LIKE '%s' OR m2.meta_value LIKE '%s'", "%{$search}%", "%$search%");

$user_search->query_where = str_replace('WHERE 1=1 AND (', "WHERE 1=1 AND ({$names_where} OR ", $user_search->query_where);

}

return $user_search;

}