Changeset 12235

Timestamp:

11/10/2022 09:02:49 PM (2 years ago)

Author:

coffee2code

Message:

Photo Directory, Search: Limit partial matching of search terms to at least being at the start of a matching term.

Fixes #6569.

File:

• sites/trunk/wordpress.org/public_html/wp-content/plugins/photo-directory/inc/search.php (modified) (2 diffs)

sites/trunk/wordpress.org/public_html/wp-content/plugins/photo-directory/inc/search.php

@@ -16 +16 @@
         add_action( 'pre_get_posts',        [ __CLASS__, 'default_search_to_only_photos' ] );
         add_filter( 'posts_join',           [ __CLASS__, 'tag_join_for_search' ], 10, 2 );
+        add_filter( 'posts_search',         [ __CLASS__, 'limit_partial_matching' ], 9, 2 );
         add_filter( 'posts_search',         [ __CLASS__, 'tag_where_for_search' ], 10, 2 );
         add_filter( 'posts_groupby',        [ __CLASS__, 'tag_groupby_for_search' ], 10, 2 );
@@ -93 +94 @@
 
     /**
+     * Limits partial matching of search terms to at least being at the start of
+     * a matching term.
+     *
+     * @param string   $where Search SQL for WHERE clause.
+     * @param WP_Query $query The current WP_Query object.
+     * @return string
+     */
+    public static function limit_partial_matching( $where, $query ) {
+        global $wpdb;
+
+        if ( ! is_admin() && $query->is_search() && $query->is_main_query() ) {
+            $where = preg_replace(
+                "/LIKE '(\{\w+\})([^\{]+)(\{\w+\})'/",
+                "LIKE '$2$1'",
+                $where
+            );
+        }
+
+        return $where;
+    }
+
+    /**
      * Customizes the WHERE clause for frontend searches.
      *