'Encore Member Search',
'post_name' => 'encoreusers',
'post_content' => '[encore_member_search]',
'post_status' => 'publish',
'post_type' => 'page',
'comment_status' => 'closed',
'ping_status' => 'closed',
]);
}
}
public function ajax_search() {
$search = isset($_POST['search']) ? sanitize_text_field($_POST['search']) : '';
if (strlen($search) < 2) {
wp_send_json_success(['results' => [], 'message' => '']);
}
global $wpdb;
// Split search into words for multi-word matching (e.g., "Rhonda Manning")
$search_terms = preg_split('/\s+/', $search);
if (count($search_terms) > 1) {
// Multi-word search: each term must match somewhere in the user's data
$where_clauses = [];
$params = [];
foreach ($search_terms as $term) {
$like = '%' . $wpdb->esc_like($term) . '%';
$where_clauses[] = "(u.user_email LIKE %s OR u.display_name LIKE %s OR fn.meta_value LIKE %s OR ln.meta_value LIKE %s)";
$params[] = $like;
$params[] = $like;
$params[] = $like;
$params[] = $like;
}
$where_sql = implode(' AND ', $where_clauses);
$query = $wpdb->prepare("
SELECT DISTINCT u.ID, u.user_email, u.display_name,
fn.meta_value as first_name,
ln.meta_value as last_name
FROM {$wpdb->users} u
LEFT JOIN {$wpdb->usermeta} fn ON u.ID = fn.user_id AND fn.meta_key = 'first_name'
LEFT JOIN {$wpdb->usermeta} ln ON u.ID = ln.user_id AND ln.meta_key = 'last_name'
WHERE $where_sql
ORDER BY ln.meta_value, fn.meta_value
LIMIT 15
", ...$params);
} else {
// Single word search with priority ordering
$like = '%' . $wpdb->esc_like($search) . '%';
$query = $wpdb->prepare("
SELECT DISTINCT u.ID, u.user_email, u.display_name,
fn.meta_value as first_name,
ln.meta_value as last_name,
CASE
WHEN fn.meta_value LIKE %s THEN 1
WHEN ln.meta_value LIKE %s THEN 1
WHEN u.display_name LIKE %s THEN 2
ELSE 3
END as match_priority
FROM {$wpdb->users} u
LEFT JOIN {$wpdb->usermeta} fn ON u.ID = fn.user_id AND fn.meta_key = 'first_name'
LEFT JOIN {$wpdb->usermeta} ln ON u.ID = ln.user_id AND ln.meta_key = 'last_name'
WHERE u.user_email LIKE %s
OR u.display_name LIKE %s
OR u.user_login LIKE %s
OR fn.meta_value LIKE %s
OR ln.meta_value LIKE %s
ORDER BY match_priority, ln.meta_value, fn.meta_value
LIMIT 15
", $like, $like, $like, $like, $like, $like, $like, $like);
}
$users = $wpdb->get_results($query);
$results = [];
foreach ($users as $user) {
$first = $user->first_name ?: '';
$last = $user->last_name ?: '';
$name = trim("$first $last");
if (empty($name)) {
$name = $user->display_name;
}
$results[] = [
'name' => $name,
'email' => $user->user_email,
];
}
wp_send_json_success(['results' => $results]);
}
public function render_shortcode($atts) {
ob_start();
?>