Sometimes it is nice to have a way to quickly search for users\/customers without having to use the WordPress default user search.\u00a0 Especially when your user base is large, this can be a very slow process.\u00a0 This code adds a quick search feature to the top admin bar, as well as submenu item that appears in the Users menu in the left navigation.<\/p>\n
The following code is intended to be added to a plugin — presumably a custom plugin.<\/p>\n
<?php\r\nclass MyPrefix_User_By_Email {\r\n var $settings;\r\n \r\n function __construct() {\r\n \/\/ vars\r\n $this->settings = array();\r\n $this->plugin_path = dirname(__FILE__); \/\/ Change this if this file is not in the root of the plugin.\r\n $this->js_uri = plugin_dir_url(__FILE__) . 'assets\/js\/';\r\n $this->img_uri = plugin_dir_url(__FILE__) . 'assets\/images\/';\r\n $this->page_name = 'myprefix_user_by_email';\r\n $this->page_url = 'admin.php?page='.$this->page_name;\r\n \r\n add_action('init', array($this, 'init'), 99); \/\/ this needs to fire after post types have been declared for the printing to work correctly\r\n add_action('wp_before_admin_bar_render', array($this, 'admin_bar_search_menu'), 800 );\r\n }\r\n \r\n function init() {\r\n \/\/ admin only\r\n if( is_admin() ) {\r\n add_action('admin_menu', array($this, 'admin_menu'), 30);\r\n }\r\n }\r\n \r\n function admin_menu() \t{\r\n \/* Add custom pages. If first argument is null then it won't add a submenu item. Otherwise use 'edit.php?post_type=<post_type>'. *\/\r\n add_submenu_page('users.php', 'Search By Email', 'Search By Email', 'list_users', $this->page_name, array($this, 'search_by_email'));\r\n }\r\n \r\n function admin_bar_search_menu($wp_admin_bar) {\r\n global $wp_admin_bar;\r\n \r\n if ( !myprefix_is_admin() )\r\n return;\r\n\r\n $form = '<form action=\"' . admin_url($this->page_url) . '\" id=\"adminbar-user-search-form\" method=\"post\">';\r\n $form .= '<input class=\"adminbar-input\" name=\"user_email\" id=\"adminbar-user-search\" type=\"text\" value=\"\" placeholder=\"User email address\" maxlength=\"150\" \/>';\r\n $form .= '<input type=\"submit\" class=\"adminbar-button\" value=\"' . __('Search') . '\"\/>';\r\n $form .= '<\/form>';\r\n \r\n $wp_admin_bar->add_menu( array(\r\n 'parent' => false,\r\n 'id' => 'user-email-search',\r\n 'title' => $form,\r\n 'meta' => array(\r\n 'class' => 'admin-bar-user-search',\r\n 'tabindex' => -1,\r\n )\r\n ) );\r\n }\r\n\r\n function search_by_email() {\r\n global $wpdb;\r\n ?>\r\n <h1>Search By Email Address<\/h1>\r\n \r\n <?php\r\n $this->print_form();\r\n }\r\n \r\n function print_form() {\r\n global $wpdb;\r\n \r\n $found_users = false;\r\n if (isset($_POST['user_email'])) {\r\n $sql = $wpdb->prepare(\"SELECT U.ID, U.user_email,\r\n UM1.meta_value as 'first_name',\r\n UM2.meta_value as 'last_name'\r\n FROM wp_users U\r\n LEFT OUTER JOIN wp_usermeta UM1 ON UM1.user_id = U.ID AND UM1.meta_key = 'first_name'\r\n LEFT OUTER JOIN wp_usermeta UM2 ON UM2.user_id = U.ID AND UM2.meta_key = 'last_name'\r\n WHERE user_email = %s\", $_POST['user_email']);\r\n $found_users = $wpdb->get_results($sql);\r\n if (count($found_users) == 1) {\r\n wp_redirect('\/wp-admin\/user-edit.php?user_id=' . $found_users[0]->ID);\r\n exit();\r\n }\r\n }\r\n \r\n include($this->plugin_path . '\/templates\/user_by_email.php');\r\n }\r\n}\r\n\r\nfunction myprefix_init_user_by_email() {\r\n global $MyPrefix_User_By_Email;\r\n if( !isset($MyPrefix_User_By_Email) ) {\r\n $MyPrefix_User_By_Email = new MyPrefix_User_By_Email();\r\n }\r\n\r\n return $MyPrefix_User_By_Email;\r\n}\r\n\r\n\r\n\/\/ initialize\r\nmyprefix_init_user_by_email();\r\n?><\/pre>\nHere is the template file, named user_by_email.php<\/em>, that is references in the print_form() function above.\u00a0 In this example, it is located in the templates<\/em> subdirectory.<\/p>\n<p>Search for an EXACT email address.<\/p>\r\n<form method=\"post\" action=\"\">\r\n<table class=\"data-list\" style=\"width:auto;\">\r\n <tr>\r\n <th>Email Address<\/th>\r\n <td><input type=\"text\" name=\"user_email\" value=\"<?php echo isset($_POST['user_email']) ? esc_attr($_POST['user_email']) : ''; ?>\" style=\"width:400px;\"><\/td>\r\n <\/tr>\r\n<\/table>\r\n<input type=\"submit\" name=\"btnSave\" value=\"Search\">\r\n<\/form>\r\n\r\n<?php\r\nif ($found_users) {\r\n echo '<h3>Results<\/h3>';\r\n foreach ($found_users as $user) {\r\n ?>\r\n <div><strong><a href=\"\/wp-admin\/user-edit.php?user_id=<?php echo $user->ID; ?>\"><?php echo $user->first_name . ' ' . $user->last_name; ?><\/a><\/strong><\/div>\r\n <div>User ID: <?php echo $user->ID; ?><\/div>\r\n <?php\r\n }\r\n}\r\n?><\/pre>\n <\/p>\n","protected":false},"excerpt":{"rendered":"