Advice on searching with PHP and MySQL -


Actually, I have a problem similar to this guy but I also need relevance:

But , I can not use sphinx or lucin (shared hosting) ...

I can like but it does not have relevance, so anyone knows a good PHP class that creates relevance is?

  • The matching part of the result, i.e. "choice% searchterm%"
  • multiple search database columns
  • things like sphinx or lucene Can not use, my shared hosting is not supported ...

    • I am using CakePh framework.

    You may be interested in my presentation

    I have demonstrated many solutions Compare:

    • Preferences
    • MyISAM FULLTEXT index
    • Spinks search
    • Lucene (or Solar)
    • Google Custom Search Engine
    • Inverted Index

    If you have a dedicated search engine There is no chance, so I recommend using the fulltighter or Google CSE.

    Using preference predicates is the most obviously the worst option.

    I've tried Zend_Search_Lucene, Apache Lucene's pure-PHP clone, but the PHP version is very slow on indexing. See my answer

    Zend_Search_Lucene has not maintained compatibility with new versions of the Apache Lucene Index file format.


    Comments

    Post a Comment