0

Hello everyone,
Does anyone knows any query expansion techniques that can be implemented using php other than hierarchical technique. i.e: facet , analysis, thesaurus.
By implementing query expansion, the users are not only presented with the keyword they inserted, but some related words to the keyword.

Thank you

2
Contributors
3
Replies
5
Views
7 Years
Discussion Span
Last Post by tulipputih
0

Hello everyone,
Does anyone knows any query expansion techniques that can be implemented using php other than hierarchical technique. i.e: facet , analysis, thesaurus.
By implementing query expansion, the users are not only presented with the keyword they inserted, but some related words to the keyword.

Thank you

If you're implementing a search engine purely in PHP you're doing something wrong. Take a look at Apache Lucene or alternatives along those lines. PHP can but shouldn't.

0

Hello,
I have tried to do this bacic MySQl query expansion but there is an error..Could anyone who know how to correct it tell me. thank you

$myquery = "SELECT learningArea,subject,ability FROM lesson WHERE MATCH (learningArea,subject,ability) AGAINST ('".$_POST['q']."'  WITH QUERY EXPANSION);";

the error is like this
Query: SELECT learningArea,subject,ability FROM lesson WHERE MATCH (learningArea,subject,ability) AGAINST ('' WITH QUERY EXPANSION); Error: Can't find FULLTEXT index matching the column list.

I have this sybtax as well

$myquery =("SELECT * MATCH(learningArea,subject,ability) AGAINST ('$q' WITH QUERY EXPANSION) 
// AS score FROM lessonplan WHERE MATCH(learningArea,subject,ability) AGAINST ('$q' WITH QUERY EXPANSION) ORDER BY score DESC");

this error is shown.
Query: SELECT * MATCH(learningArea,subject,ability) AGAINST ('' WITH QUERY EXPANSION) AS score FROM lessonplan WHERE MATCH(learningArea,subject,ability) AGAINST ('' WITH QUERY EXPANSION) ORDER BY score DESC Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MATCH(learningArea,subject,ability) AGAINST ('' WITH QUERY EXPANSION) AS scor' at line 1

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.