使用PHP进行产品搜索

Question

I'm looking for a product search function for an onlineshop. The shop has 3500 items. The items can be found in a mysql database or in a file. I want to get the products which match the search term best. The search term should be compared with the productname.

Because a search function is one of the most important parts of an onlineshop i'm looking for a very efficent solution. Does someone know a solution which is easy to implement? It's doen't need to be for free.

UPDATE:

What i tryed until now is to compare the term with the productname. First i'm looking if the term could be found 1on1. After that i take the single words in the term and check if they could be found in productnames. This works, but it's not accurate enough.

Answer 1

If you are atleast familiar with php and know how to query database, i suggest you to use this documentation, eventually you will know what to do with it.

http://dev.mysql.com/doc/refman/5.7/en/string-comparison-functions.html

In short, LIKE is something like comparasion operator, just match by pattern. In your example lets say productname LIKE "%searchterm%".

I hope this can help you. Regards