$highlite = array();
$search = explode(" ",$search);
foreach($search as $value) {
$query .= "(TITLE LIKE '%$value%' OR CONTENT LIKE '%$value%') AND ";
$highlite[count($highlite)] = $value;
}
$query = substr($query,0,-4);
$SQL = "SELECT ID, TITLE, CONTENT FROM TABLE WHERE $query";
$result = mysql_query($SQL);
while ($item = mysql_fetch_object($result)) {
foreach($highlite as $val) {
if(strlen($val)>3) {
$item->TITLE = eregi_replace($val,"<span style=\"background-color: #C0C0C0\">\\0</span>",$item->TITLE);
$hurl.="$val+";
}
}
echo "<li><a href=\"readmore.php?id=$item->ID&highlite=$hurl\">$item->TITLE</a></li>";
unset($hurl);
}
$SQL = "SELECT ID, TITLE, CONTENT FROM TABLE WHERE id=$id LIMIT 1";
$result = mysql_query($SQL);
$item = mysql_fetch_object($result);
$highlite1 = array();
$highlite1 = explode(" ",$highlite);
foreach($highlite1 as $value) {
if(strlen($value)>3) {
$item->TITLE = eregi_replace($value,"<span style=\"background-color: #C0C0C0\">\\0</span>",$item->TITLE);
$item->CONTENT = eregi_replace($value,"<span style=\"background-color: #C0C0C0\">\\0</span>",$item->CONTENT);
//$item->TITLE = preg_replace('/(?<=>)([^<]+)?('.$value.')/i','$1<span style="background-color: #C0C0C0">$2</span>',$item->TITLE);
}
}
echo "$item->TITLE<br>$item->CONTENT";
?>
Recent Comments