PHP搜索多个字段问题

Question

我正在在线学习本教程:http://goo.gl/qnk6U

数据库表:ajax_search

Firstname | Lastname | Age | Hometown | Job-------------------------------------------Joe       | Smith    | 35  | Boulder  | CIA   Steve     | Apple    | 36  | Denver   | FBI

(Types are all varchar except age is an int.)

My question. Is the sql select statement below written correctly to query "Joe 35"? For some reason, I can only query "Joe" and it works, but not combining search terms.

$sql = "select * from ajax_search where FirstName like '%$rec%' or LastName like '%$rec%' or Age like '%$rec%' or Hometown like '%$rec%'";

Answer 1

假设您的查询是“Joe 35”，那么不是。您的查询匹配四个字段中的任何一个包含“Joe 35”(在单个字段中)的任何行。要查询姓名为 Joe 且年龄为 35 岁的用户，您需要拆分搜索查询并执行如下操作:

WHERE Firstname LIKE "$firstname" AND Age LIKE "$age"