From ba96b9ad1734f95562bc4de3f45eb38a0a73d5d7 Mon Sep 17 00:00:00 2001
From: wainstead <wainstead@96ab9672-09ca-45d6-a79d-3d69d39ca109>
Date: Fri, 23 Jun 2000 01:40:01 +0000
Subject: [PATCH] Fixed searches so they are case insensitive.

git-svn-id: svn://svn.code.sf.net/p/phpwiki/code/trunk@92 96ab9672-09ca-45d6-a79d-3d69d39ca109
---
 wiki_pgsql.php3 | 8 +++++---
 1 file changed, 5 insertions(+), 3 deletions(-)

diff --git a/wiki_pgsql.php3 b/wiki_pgsql.php3
index f9d61337e..cc41c2d99 100644
--- a/wiki_pgsql.php3
+++ b/wiki_pgsql.php3
@@ -1,4 +1,4 @@
-<!-- $Id: wiki_pgsql.php3,v 1.8 2000-06-23 01:01:24 wainstead Exp $ -->
+<!-- $Id: wiki_pgsql.php3,v 1.9 2000-06-23 01:40:01 wainstead Exp $ -->
 <?
 
    /*
@@ -144,8 +144,9 @@
       global $search_counter;
       $search_counter = 0;
 
+      $search = strtolower($search);
       $search = addslashes($search);
-      $query = "select pagename from $dbi[table] where pagename " .
+      $query = "select pagename from $dbi[table] where lower(pagename) " .
                "like '%$search%' order by pagename";
 //      echo "search query: $query<br>\n";
       $res = pg_exec($dbi["dbc"], $query);
@@ -171,8 +172,9 @@
       global $search_counter;
       $search_counter = 0;
       $search = addslashes($search);
+      $search = addslashes($search);
       $query = "select pagename,content from $dbi[table] " .
-               "where content like '%$search%'";
+               "where lower(content) like '%$search%'";
 
       $res = pg_exec($dbi["dbc"], $query);
 
-- 
2.45.0