php mysql相似度,mysql php选择一条与另一个相似的记录

I know this may seem like a duplicated, out of stackoverflow, etc question but here we go.

I'm trying to make an SQL sentence that can find a coincidence between two strings

function getProductos($keyWords){

$keyWords = addslashes(strtolower($keyWords));

$keyWordsExploded = explode(" ",$keyWords);

$sql = "SELECT * FROM PRODUCTOS WHERE HOMBRE_MUJER LIKE :keyWords OR CATEGORIA LIKE :keyWords" OR NOMBRE LIKE :keyWords;

$query = self::$conn->prepare($sql);

$query->execute(array(":keyWords"=> "%" . $keyWords . "%"));

return $query;

}

In other part of the page I have this code:

if(isset($_GET['buscar'])){

require(PAGES_DIR . "queries_products.php");

$consultaProducts = new QueryProductos();

$productos = $consultaProducts->getProductos($_GET['buscar']);

if($productos->rowCount()!=0){

$arrayProductos = $productos->fetchAll(PDO::FETCH_ASSOC);

echo "

Productos encontrados

";

foreach($arrayProductos as $fila){

echo $fila['NOMBRE'] . " " . $fila['HOMBRE_MUJER'] . "
";

}

}else{

echo "

No results found " . $_GET['buscar'] . "";

}

}

?>

Everything works fine, In my database I store only 2 values in CATEGORIA which are: "hombres" and "mujeres", if i search for hombres I get all records which have a CATEGORIA of hombres but when i search for hombres y mujeres I get no results, I have tried using different sentences that i read but I haven't had any luck, I hope you can greatly save me by helping me solve this problem.

解决方案

try this:

function getProductos($keyWords) {

$keyWordsExploded = explode(" ",$keyWords);

$sql = "SELECT * FROM PRODUCTOS WHERE ";

$likes = array("HOMBRE_MUJER", "CATEGORIA", "NOMBRE"); // build up our columns which will be used in our condition in sql statment

$params = array();

// building up our sql statment and collecting our params

foreach($likes as $like) {

foreach($keyWordsExploded as $kw) {

$sql .="$like like ? or ";

$params[] = "%".$kw."%";

}

}

$sql = rtrim($sql, "or "); // trim the last "or" condition in sql statment

$query = self::$conn->prepare($sql);

$query->execute($params);

return $query;

}