From ceee971af7ce16f9fc86db2e0f1d2c2ae0af9ac5 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Mon, 9 Sep 2019 08:58:49 -0400 Subject: [PATCH] Updating ajax file for searching by term Need to search by the term given in $_REQUEST --- models/admin/ajax/memberNameJson.php | 9 +++++++++ 1 file changed, 9 insertions(+) diff --git a/models/admin/ajax/memberNameJson.php b/models/admin/ajax/memberNameJson.php index 5948582f..10482eb3 100644 --- a/models/admin/ajax/memberNameJson.php +++ b/models/admin/ajax/memberNameJson.php @@ -75,6 +75,15 @@ class GlmMembersAdmin_ajax_memberNameJson ) AND T.status = " . $this->config['status_numb']['Active']; + if ( isset( $_REQUEST['term'] ) && !empty( $_REQUEST['term'] ) ) { + $textSearch = addslashes(filter_var($_REQUEST['term'], FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES)); + $whereParts[] = " T.member in ( + SELECT DISTINCT(id) + FROM ".GLM_MEMBERS_PLUGIN_DB_PREFIX."members + WHERE name like '%$textSearch%' + )"; + } + $where = implode( ' AND ', $whereParts ); $members = $this->wpdb->get_results( -- 2.17.1