From 56822af37887807c64091ed63018e0c0e1e11785 Mon Sep 17 00:00:00 2001 From: Chuck Scott Date: Mon, 20 Jun 2016 12:33:57 -0400 Subject: [PATCH] Fixed problem searching members with "'" in them. --- models/front/members/list.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/models/front/members/list.php b/models/front/members/list.php index b66a346e..1fb156bd 100644 --- a/models/front/members/list.php +++ b/models/front/members/list.php @@ -221,7 +221,7 @@ class GlmMembersFront_members_list extends GlmDataMemberInfo // Apply any provided text search to name, description, short description, and street address if (isset($_REQUEST['textSearch']) && $_REQUEST['textSearch'] != '') { - $textSearch = filter_input(INPUT_POST, 'textSearch', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES); + $textSearch = addslashes(filter_input(INPUT_POST, 'textSearch', FILTER_SANITIZE_STRING, FILTER_FLAG_NO_ENCODE_QUOTES)); $where .= $whereSep." ( ( SELECT true @@ -235,6 +235,7 @@ class GlmMembersFront_members_list extends GlmDataMemberInfo T.addr2 LIKE '%$textSearch%' )"; $whereSep = ' AND '; + $textSearch = stripslashes($textSearch); } // Get category data for search pick list and shortcode selection -- 2.17.1