$str = str_replace(' ','%',$str); select * from product where name like '$str';
$arrSearch = explode(" ", $_POST['search']); foreach($arrSearch as $value) { $strSearch .= sprintf(" AND name LIKE '%s%' ", $value); } $sql = sprintf("select * from product where %s", ltrim($strSearch, "AND"));
不怎么理想 如果 客户输入好几个空格 就是这个样子了 AND name LIKE '%%' AND name LIKE '%%' AND name LIKE '%山东%' AND name LIKE '%%' AND name LIKE '%%' AND name LIKE '%滨州%' AND name LIKE '%移动%'
$arrSearch = explode(" ", $_POST['search']); foreach($arrSearch as $value) { if($value!='') { $strSearch .= "AND name LIKE '%".$value."%' "; }else{ $strSearch =$strSearch; } } $sql = sprintf("select * from product where %s",ltrim($strSearch,"AND"));这样就可以了哈哈,谢谢各位
$str = str_replace(' ','%',$str);
select * from product where name like '$str';
foreach($arrSearch as $value)
{
$strSearch .= sprintf(" AND name LIKE '%s%' ", $value);
}
$sql = sprintf("select * from product where %s", ltrim($strSearch, "AND"));
就是这个样子了
AND name LIKE '%%' AND name LIKE '%%' AND name LIKE '%山东%' AND name LIKE '%%' AND name LIKE '%%' AND name LIKE '%滨州%' AND name LIKE '%移动%'
$arrSearch = explode(" ", $_POST['search']);
foreach($arrSearch as $value)
{
if($value!='')
{
$strSearch .= "AND name LIKE '%".$value."%' ";
}else{
$strSearch =$strSearch;
}
} $sql = sprintf("select * from product where %s",ltrim($strSearch,"AND"));这样就可以了哈哈,谢谢各位