Changeset 4426

Timestamp:

10/27/2006 03:47:43 AM (18 years ago)

Author:

markjaquith

Message:

Allow "quoted strings" to be used in searches. mega free-beer-when-I-finally-meet-you-in-person props to ringmaster. fixes #3177

File:

• trunk/wp-includes/query.php (modified) (1 diff)

trunk/wp-includes/query.php

@@ -744 +744 @@
         // If a search pattern is specified, load the posts that match
         if (!empty($q['s'])) {
-            $q['s'] = addslashes_gpc($q['s']);
-            $search = ' AND (';
-            $q['s'] = preg_replace('/, +/', ' ', $q['s']);
-            $q['s'] = str_replace(',', ' ', $q['s']);
-            $q['s'] = str_replace('"', ' ', $q['s']);
-            $q['s'] = trim($q['s']);
-            if ($q['exact']) {
-                $n = '';
-            } else {
-                $n = '%';
-            }
-            if (!$q['sentence']) {
-                $s_array = explode(' ',$q['s']);
-                $q['search_terms'] = $s_array;
-                $search .= '((post_title LIKE \''.$n.$s_array[0].$n.'\') OR (post_content LIKE \''.$n.$s_array[0].$n.'\'))';
-                for ( $i = 1; $i < count($s_array); $i = $i + 1) {
-                    $search .= ' AND ((post_title LIKE \''.$n.$s_array[$i].$n.'\') OR (post_content LIKE \''.$n.$s_array[$i].$n.'\'))';
-                }
-                $search .= ' OR (post_title LIKE \''.$n.$q['s'].$n.'\') OR (post_content LIKE \''.$n.$q['s'].$n.'\')';
-                $search .= ')';
-            } else {
-                $search = ' AND ((post_title LIKE \''.$n.$q['s'].$n.'\') OR (post_content LIKE \''.$n.$q['s'].$n.'\'))';
-            }
+            // added slashes screw with quote grouping when done early, so done later
+            $q['s'] = stripslashes($q['s']);
+            if ($q['sentence']) {
+                $q['search_terms'] = array($q['s']);
+            }
+            else {
+                preg_match_all('/".*?("|$)|((?<=[\\s",+])|^)[^\\s",+]+/', $q[s], $matches);
+                $q['search_terms'] = array_map(create_function('$a', 'return trim($a, "\\"\'\\n\\r ");'), $matches[0]);
+            }
+            $n = ($q['exact']) ? '' : '%';
+            $searchand = '';
+            foreach((array)$q['search_terms'] as $term) {
+                $term = addslashes_gpc($term);
+                $search .= "{$searchand}((post_title LIKE '{$n}{$term}{$n}') OR (post_content LIKE '{$n}{$term}{$n}'))";
+                $searchand = ' AND ';
+            }
+            $term = addslashes_gpc($q['s']); 
+            if (!$q['sentence'] && count($q['search_terms']) > 1 && $q['search_terms'][0] != $q['s'] ) $search .= " OR (post_title LIKE '{$n}{$term}{$n}') OR (post_content LIKE '{$n}{$term}{$n}')";
+            
+            $search = " AND ({$search}) ";
         }