mysql实现关键词乱序查询,mysql以任意顺序搜索多个关键字

I have a simple MySQL database keyword search that is functional. However results for the search are not being returned if the keywords are not in the same order as entered in the database. For example searching for "dog cat lion" will return a result, but searching for "dog lion cat" will return no results.

Any help on how to fix this issue would be greatly appreciated. Here is my code.

Part Search

$username = "xxxx";

$password = "xxxx";

$hostname = "localhost";

//connection to the database

mysql_connect($hostname, $username, $password);

mysql_select_db("wesco");

$search = mysql_real_escape_string(trim($_POST['searchterm']));

$find_parts = mysql_query("SELECT * FROM `parts` WHERE `keywords` LIKE '%$search%'");

while($row = mysql_fetch_assoc($find_parts))

{

$name = $row['name'];

echo "$name
";

}

?>

解决方案

You could use something like this

$searchArray = explode(" ", $_POST['searchterm']);

$query = "";

foreach($searchArray as $val) {

$search = mysql_real_escape_string(trim($val));

if (!empty($query)) {

$query = $query . " OR "; // or AND, depends on what you want

}

$query = $query . "`keywords` LIKE '%$search%'";

}

if (!empty($query)) {

$find_parts = mysql_query("SELECT * FROM `parts` WHERE $query");

}

Also, you should stop using the mysql_* functions and start using the object oriented implementation of mysqli.