多關(guān)鍵模糊查詢,只需要改兩處
多關(guān)鍵模糊查詢,只需要改兩處:
$val='username?like?"%'.str_replace('?','%"??or?username?like?"%',$keywords).'%"';
$sql="select?*?from?fuzzyuser?where??{$val}";
高亮 寫的比較麻煩,希望有好答案:(這里大小寫都可以高亮)
if(!empty($keywords)){ while($row=mysql_fetch_assoc($rs)){ //對用戶名進行關(guān)鍵詞高亮 $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