$sql="select Page_Title,Page_Body,PlainOrHTML,Page_Num from the_database";
$results = mysql_query($sql);
$i=0;
$hits=array();
$searchterms = explode (" ", $searchterm);
while ($result = mysql_fetch_array($results)){ =
$i++;
$title = $result["Page_Title"];
$content = $result["Page_Body"];
$advanced = $result["PlainOrHTML"];
$hits[$i]["page"] = $result["Page_Num"];
$hits[$i]["title"] = $title;
$hits[$i]["score"] = 0;
$content = str_replace("[","< ,$content);br>
$content = str_replace("]",">",$content);
$hits[$i]["summary"] = substr(strip_tags($content),0,100)."...";
$content = str_replace("< , ,$content);br>
$content = str_replace(">"," ",$content);
$content = str_replace(","," ",$content);
$SearchWords = explode (" ", $content);
for ($k=0;$k
if ($title!="" && $searchterms[$k]!=""){
if (stristr($title,$searchterms[$k])){
$hits[$i]["score"]++;
}
}
}
for ($j=0;$j
for ($k=0;$k
if (strtoupper($SearchWords[$j])==strtoupper($searchterms[$k])){
$hits[$i]["score"]++;
}
}
}
}
usort($hits,"score_sort");
//build short array
$hits2=array();
for ($j=0;$j
if ($hits[$j]["score"]) {
$hits2[$j]["score"] = $hits[$j]["score"];
$hits2[$j]["page"] = $hits[$j]["page"];
$hits2[$j]["title"] = $hits[$j]["title"];
$hits2[$j]["summary"] $hits[$j]["summary"];
}
}
>>
Then I have a page that displays the results...
posted by tomierna at 1:12 PM on March 16, 2006