如何使用PHP和SQL在一个文本框中搜索特定项？

Question

I have 2 tables, TABLE1 for parts and TABLE2 for vehicle application.

TABLE1

part_no | description | brand | price             
1234_AB | OIL SEAL | BRANDx | 97.50              
5678_CD | AIRCON FILTER | BRANDy | 400.00

TABLE2

part_no | make_name | name | year_model     
1234_AB | HONDA | LEGEND | 1991             
5678_CD | HONDA | PRELUDE | 1982       
1234_AB | HONDA | CIVIC | 1978          
5678_CD | HONDA | ACCORD | 1979     

then I want to search this in 1 textbox:
OIL FILTER HONDA CIVIC 1978
or CIVIC HONDA 1978 OIL FILTER
or 1978 HONDA CIVIC OIL FILTER

then it will show this result:

part_no | description | brand | price     
1234_AB | OIL SEAL | BRANDx | 97.50

Answer 1

Take the input from the textbox, split this with the " " (space) character and push to an array.

You should have created table entities so just loop through a comparison of each string value in the array to the entity properties.