Projekt

Obecné

Profil

« Předchozí | Další » 

Revize a55d3368

Přidáno uživatelem Petr Lukašík před více než 5 roky(ů)

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

Zobrazit rozdíly:

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

  
780 780
                $dotaz = "SELECT * FROM dict 
781 781
        		WHERE language = $language 
782
        		  AND lower(english) = '$word' 
782
        		  AND lower(english) LIKE '%$word%' 
783 783
        		  ORDER BY english LIMIT 30";
784 784
                break;
785 785
            case("he"):
......
791 791
                $dotaz = "SELECT * FROM dict
792 792
            WHERE language = $language AND
793 793
                  (
794
                   (past    = ('$word_token')) 
794
                   (past    LIKE ('%$word_token%')) 
795 795
                   OR
796
                   (nonvocalized = ('$word_token'))
796
                   (nonvocalized LIKE ('%$word_token%'))
797 797
		   OR
798
                   (nonvocalized_female = ('$word_token'))
798
                   (nonvocalized_female LIKE ('%$word_token%'))
799 799
		   OR
800
                   (single_female = ('$word_token'))
800
                   (single_female LIKE ('%$word_token%'))
801 801
		   OR
802
                   (nonvocalized_alternative = ('$word_token'))
802
                   (nonvocalized_alternative LIKE ('%$word_token%'))
803 803
		   OR
804
                   (vocalized_alternative = ('$word_token'))
804
                   (vocalized_alternative LIKE ('%$word_token%'))
805 805
                  ) 
806 806
		  AND 
807 807
                  (
......
841 841
                //pr($word);
842 842
                $dotaz = "SELECT * FROM dict
843 843
            WHERE language = $language AND
844
                  ((present = '$word') OR
845
                   (past    = '$word') OR
846
                   (valence = '$word') OR
847
                   (root    = '$word')) 
844
                  ((present LIKE '%$word%') OR
845
                   (past    LIKE '%$word%') OR
846
                   (valence LIKE '%$word%') OR
847
                   (root    LIKE '%$word%')) 
848 848
              ORDER BY english LIMIT 30";
849 849
                //pr($dotaz);
850 850
                break;
......
852 852
                $word = mb_strtolower($word, "UTF-8");
853 853
                $dotaz = "SELECT * FROM dict 
854 854
                 WHERE language = $language 
855
                   AND lower(czech) = '$word' 
855
                   AND lower(czech) LIKE '%$word%' 
856 856
                   ORDER BY english LIMIT 30";
857 857
        }
858 858
        //$dotaz .= " ORDER BY context DESC, word_voice";

Také k dispozici: Unified diff