Revize a55d3368
Přidáno uživatelem Petr Lukašík před více než 5 roky(ů)
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
Vyhledávání ve slovnících funguje na bázi "LIKE" místo "="