试试这个:
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;}
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)