实施高级搜索的最佳方式是什么，例如“{{Entity1}} {{Action}} {{Entity2}}”

Question

I've a site with following features group, events, pages and users.

Currently normal search on group name, event name, page name and user name are working even works on their description and posts.

But I want to implement some smart search like if someone searches :

"Robert from New York" - it will return all users from new york whose name is robert

"Artist from London" - it will return all users who writes artists in their profession and city is London

"Developer in Google" - it will return all users who works puts writes developer in their profession and google in comapny

"Groups for Entertainment" - it will return all groups which is under Entertainment category

I've sep. table for categories, cities, companies, groups, events, users, pages and actions.

I want best and fastest way to do something like this just suggest me some way which is good in performance and also extendable for example if any action increase in future then can be implemented easily without breaking previous.

Many thanks in advance :)

I've also planned to put 1 more table before search for this with fields : Name and Type, Name can be anything and Type will be something like : User, Skill, Designation, Company, city, Group

Answer 1

You can do this by search string.

1. Search for " in "," from " and " for " first in string.(Need to have space so that, names do not conflict)
2. Based on result of step 1, split your string to two part. For example, "Robert from New York" will be array("Robert","New York")
3. Based on your step 1 and 2 look for respective tables for example, step 2 can have 1st value to be searched in designation(Artist) or Name(Robert) and second value will be in location.
4. You will need to follow same for other scenarios.
5. Build array of all possible outcomes in single array along with it's url like group will have group url and person will have profile url and on front-end simply loop your output.