Revize a55d3368

Vyhledávání ve slovnících funguje na bázi "LIKE" místo "="

old/html/multidic/app/webroot/functions/dictionary.php

@@ -779 +779 @@
 
                 $dotaz = "SELECT * FROM dict 
         		WHERE language = $language 
-        		  AND lower(english) = '$word' 
+        		  AND lower(english) LIKE '%$word%' 
         		  ORDER BY english LIMIT 30";
                 break;
             case("he"):
@@ -791 +791 @@
                 $dotaz = "SELECT * FROM dict
             WHERE language = $language AND
                   (
-                   (past    = ('$word_token')) 
+                   (past    LIKE ('%$word_token%')) 
                    OR
-                   (nonvocalized = ('$word_token'))
+                   (nonvocalized LIKE ('%$word_token%'))
 		   OR
-                   (nonvocalized_female = ('$word_token'))
+                   (nonvocalized_female LIKE ('%$word_token%'))
 		   OR
-                   (single_female = ('$word_token'))
+                   (single_female LIKE ('%$word_token%'))
 		   OR
-                   (nonvocalized_alternative = ('$word_token'))
+                   (nonvocalized_alternative LIKE ('%$word_token%'))
 		   OR
-                   (vocalized_alternative = ('$word_token'))
+                   (vocalized_alternative LIKE ('%$word_token%'))
                   ) 
 		  AND 
                   (
@@ -841 +841 @@
                 //pr($word);
                 $dotaz = "SELECT * FROM dict
             WHERE language = $language AND
-                  ((present = '$word') OR
-                   (past    = '$word') OR
-                   (valence = '$word') OR
-                   (root    = '$word')) 
+                  ((present LIKE '%$word%') OR
+                   (past    LIKE '%$word%') OR
+                   (valence LIKE '%$word%') OR
+                   (root    LIKE '%$word%')) 
               ORDER BY english LIMIT 30";
                 //pr($dotaz);
                 break;
@@ -852 +852 @@
                 $word = mb_strtolower($word, "UTF-8");
                 $dotaz = "SELECT * FROM dict 
                  WHERE language = $language 
-                   AND lower(czech) = '$word' 
+                   AND lower(czech) LIKE '%$word%' 
                    ORDER BY english LIMIT 30";
         }
         //$dotaz .= " ORDER BY context DESC, word_voice";