Changeset 1015 for trunk/include

Timestamp:

Jan 27, 2006, 11:40:51 PM (19 years ago)

Author:

plg

Message:

Search engine redesign, second part :

improvement: in category.php, an icon opening a popup display the list of
search rules.

modification: function get_search_array is responsible of search rules
retrieving from database. This function is called from get_sql_search_clause
and from search_rules.php

modification: ability to search multiple authors. Warning: this version of
search tool can't search author names including any blank space.

File:

• trunk/include/functions.inc.php (modified) (2 diffs)

trunk/include/functions.inc.php

@@ -774 +774 @@
 
 /**
- * returns the SQL clause from a search identifier
- *
- * Search rules are stored in search table as a serialized array. This array
- * need to be transformed into an SQL clause to be used in queries.
+ * returns search rules stored into a serialized array in "search"
+ * table. Each search rules set is numericaly identified.
  *
  * @param int search_id
- * @return string
- */
-function get_sql_search_clause($search_id)
+ * @return array
+ */
+function get_search_array($search_id)
 {
   if (!is_numeric($search_id))
@@ -792 +790 @@
 SELECT rules
   FROM '.SEARCH_TABLE.'
-  WHERE id = '.$_GET['search'].'
+  WHERE id = '.$search_id.'
 ;';
   list($serialized_rules) = mysql_fetch_row(pwg_query($query));
   
-  $search = unserialize($serialized_rules);
-
-//   echo '<pre>';
-//   print_r($search);
-//   echo '</pre>';
-
+  return unserialize($serialized_rules);
+}
+
+/**
+ * returns the SQL clause from a search identifier
+ *
+ * Search rules are stored in search table as a serialized array. This array
+ * need to be transformed into an SQL clause to be used in queries.
+ *
+ * @param int search_id
+ * @return string
+ */
+function get_sql_search_clause($search_id)
+{
+  $search = get_search_array($search_id);
+  
   // SQL where clauses are stored in $clauses array during query
   // construction