如何使用PHP和SQL在一个文本框中搜索特定项？ [英] How do I search a particular item in one textbox using PHP and SQL?

问题描述

我有2个表，TABLE1表示零件，TABLE2表示车辆应用。

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

然后我想在1个文本框中搜索：

OIL FILTER HONDA CIVIC 1978
或CIVIC HONDA 1978油过滤器

或1978年本田公民油过滤器



然后它会显示以下结果：

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

我的尝试：



我不知道要解决这个问题。我只是在寻求帮助。谢谢你

What I have tried:

I don't have any idea to start this problem. I'm just looking for help. Thank you

推荐答案

如果你想加入这两个表那么你可以使用外键，主键等键

if you want to join these two table then you can you the keys like foreign key, primary key, etc

这篇关于如何使用PHP和SQL在一个文本框中搜索特定项？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！