Search data based upon keyword or tags entered by USER

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • SwapnilD
    New Member
    • Jan 2010
    • 41

    Search data based upon keyword or tags entered by USER

    I am developing a website for local business classified.

    Where Service Provider / Traders will post advertisement of their business / shop etc.

    and end user will search for their needs and locate all the adv. based upon their search.

    Basically this will be SIMILAR to JUSTDIAL.COM

    While posting and adv. I have provided input field to enter KEYWORDS/TAGS to locate their adv. successfully.

    e.g. If someone is posting adv. for their Education Institute then they will enter most relevant keywords, which will help their adv. to be found easily by customers.

    So, they will enter tags like "Education, Institute, courses, teachers, tutor, Programming, computer courses" etc

    AND When user enters either of the keyword their Adv. would be located.

    I know this has been already developed by so many sites so far.
    I would like to know, what would be the correct way to do it.

    Any help would be greatly appreciated.

    Thanks and regards,

    SD
  • hosting charges
    New Member
    • Aug 2013
    • 10

    #2
    You need to come up with database design first, what all field the table will contain, how will you search and return best match.

    Comment

    • SwapnilD
      New Member
      • Jan 2010
      • 41

      #3
      Okay, I am using Full Text Search feature for implementing search. But I am having a problem with it.

      FOR EXAMPLE...

      Their are three rows of data and their TAG column contains below data respectively...

      1. Computer
      2. Class
      3. Computer Class

      Whenever user search for "Computer Class" my query returns records in below order

      1. COMPUTER
      2. Class
      3. Computer Class

      But, I would like to get most relevant result at the top. So, result would be in below order.

      1. Computer Class
      2. Computer
      3. Class

      Please help, how could achieve this?

      Comment

      Working...