php 多词搜索,PHP / MySQL中的多词搜索

我正在努力创建一个搜索多个单词的搜索。我的第一次尝试没有任何结果，结果如下：

require_once('database_conn.php');

if($_POST){

$explodedSearch = explode (" ", $_POST['quickSearch']);

foreach($explodedSearch as $search){

$query = "SELECT *

FROM jobseeker

WHERE forename like '%$search%' or surname like '%$search%'

ORDER BY userID

LIMIT 5";

$result = mysql_query($query);

}

while($userData=mysql_fetch_array($result)){

$forename=$userData['forename'];

$surname=$userData['surname'];

$profPic=$userData['profilePicture'];

$location=$userData['location'];

echo "

" . $forename . " " . $surname . "

" . $location . "

";

}

}

我还尝试了以下方法，这些方法产生了结果，但是正如您可以想象的那样，我输入的每个单词都得到了重复的结果：

if($_POST){

$explodedSearch = explode (" ", $_POST['quickSearch']);

foreach($explodedSearch as $search){

$query = "SELECT *

FROM jobseeker

WHERE forename like '%$search%' or surname like '%$search%'

ORDER BY userID

LIMIT 5";

$result .= mysql_query($query);

while($userData=mysql_fetch_array($result)){

$forename=$userData['forename'];

$surname=$userData['surname'];

$profPic=$userData['profilePicture'];

$location=$userData['location'];

echo "

" . $forename . " " . $surname . "

" . $location . "

";

}

}

}

我对如何进行此操作非常迷惑，不胜感激。

编辑：

if($_POST){

$quickSearch = $_POST['quickSearch'];

$explodedSearch = explode (" ", trim($quickSearch));

$queryArray = array();

foreach($explodedSearch as $search){

$term = mysql_real_escape_string($search);

$queryArray[] = "forename like '%" . $term . "%' surname like '%" . $term . "%'";

}

$implodedSearch = implode(' or ', $queryArray);

$query="SELECT *

FROM jobseeker

WHERE ($implodedSearch)

ORDER BY userID

LIMIT 5";

$result = mysql_query($query);

while($userData=mysql_fetch_array($result, MYSQL_ASSOC)){

$forename=$userData['forename'];

$surname=$userData['surname'];

$profPic=$userData['profilePicture'];

$location=$userData['location'];

echo "

" . $forename . " " . $surname . "

" . $location . "

";

}

}