simple search highlite

php Add comments

<?
$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";
?>

Leave a Reply

WP Theme & Icons by N.Design Studio
Entries RSS Comments RSS Log in