多關鍵模糊查詢,只需要改兩處
多關鍵模糊查詢,只需要改兩處:
$val='username?like?"%'.str_replace('?','%"??or?username?like?"%',$keywords).'%"';$sql="select?*?from?fuzzyuser?where??{$val}";高亮 寫的比較麻煩,希望有好答案:(這里大小寫都可以高亮)
if(!empty($keywords)){
while($row=mysql_fetch_assoc($rs)){
//對用戶名進行關鍵詞高亮
$text=$row['username'];
$text_row="";
$flag=false;
for($i=0;$i<strlen($text);$i++){
$flag=false;
for($j=0;$j<strlen($keywords);$j++){
if(strtolower($text[$i])==strtolower($keywords[$j])){
$text_row.='<font?color="red">'.$text[$i].'</font>';
$flag=true;
}
}
if($j==strlen($keywords)?&&?!$flag){
$text_row.=$text[$i];
}
}
//$row['username']=str_replace($keywords,'<font?color="red">'.$keywords.'</font>',$row['username']);
//$users[]=$row;
$row['username']=$text_row;
$users[]=$row;
}
}
2016-04-30
$row['username']=str_replace($keywords,'<font?color="red">'.$keywords.'</font>',$row['username']);
2016-04-30
$row["username"]=str-replace("$keywords","<font style="color:red">$keywords</font>","$row["username"]");
2015-06-26
mark