WEB PHP/MySQL Search Alogorithm?

Discussion in 'OT Technology' started by fishbulb, Dec 12, 2008.

  1. fishbulb

    fishbulb Active Member

    Joined:
    Oct 29, 2001
    Messages:
    6,848
    Likes Received:
    4
    Location:
    md
    For effectively searching through a database of products, does anyone have any tips besides a simple MySQL query like ... where field1 LIKE '%$search_term$' etc?

    I remember reading about an open source php project to better tackle this but I forgot to bookmark it at the time. Thanks.
     
  2. whup

    whup I wish you had children and.. so that I could step

    Joined:
    Feb 12, 2007
    Messages:
    1,603
    Likes Received:
    0
    Use Lucene. There's a port of it in the Zend Framework.
     
  3. fishbulb

    fishbulb Active Member

    Joined:
    Oct 29, 2001
    Messages:
    6,848
    Likes Received:
    4
    Location:
    md
    Thank you, that's what I was trying to remember.
     
  4. whup

    whup I wish you had children and.. so that I could step

    Joined:
    Feb 12, 2007
    Messages:
    1,603
    Likes Received:
    0
    Ummm, Lucene doesn't rely on Apache. It's an Apache Org project, and you're thinking that Apache = just Apache Httpd.

    Lucene is what is used for Wikipedia and a host of other websites.

    You can get versions for Java, PHP and .NET, all of which use the same format, so you can read and write the same indexes using different clients.

    It's really quite brilliant and I'd recommend it over database full text searching any day.

    It's built specifically for doing powerful full-text search on a document index that can be built up from many many sources (not just database, e.g. word documents, PDFs, XML etc). It's also platform and database agnostic.
     
  5. Yahdude

    Yahdude New Member

    Joined:
    Jun 21, 2006
    Messages:
    1,211
    Likes Received:
    0
    Location:
    PC, UT
    I'm sold.
     

Share This Page