Question

I have a PHP search script and I want to highlight the keywords that the user has searched with tags. How can I do this?

My code is:

if(!empty($_GET[ q ])){
$keywords=explode(   ,$_GET[ q ]);
foreach($keywords as $query){
$query=mysql_real_escape_string($query);
$likes[]="keywords LIKE  %{$query}% ";
}

$searchResult=mysql_query("select * from questions where ".implode( or  ,$likes)."limit 1");
while($row=mysql_fetch_assoc($searchResult)){
    $results="<div class= webresult >{$row[ result ]}</div>";
}
}

Answer 1

If $row[ result ] does not contain html, you can do a string replace: replace all keywords in the result with <span class="highlight">keyword</span>

简单的例子:

...
while($row=mysql_fetch_assoc($searchResult)) {
  $res = $row[ result ];
  foreach($keywords as $kw) {
    $res = str_replace($kw,  <span class="highlight">  . htmlspecialchars($kw) .  </span> , $res);
  }
  $results="<div class= webresult >{$res}</div>";
}
...

Answer 2

两种解决办法,取决于结果是否含有超文本。

如果结果可能含有超文本,则使用前言。参看查询中的多重关键词
If it can contain HTML, then you will need to use a DOM parser to separate text from HTML. Example parsers include Simple HTML Dom and DOMDocument.

友情链接