Articles Tricks And Hacks
Tricks And Hacks
Slapping together a search engine - Page 4
by: Clay Johnson
|
July 30, 2000
Set that query to
$search, and print out the results like so:
<?php
$getresults = mysql_query($search);
$resultsnumber = mysql_numrows($getresults);
IF ($resultsnumber == 0) {
PRINT "Your search returned no results. Try other keyword(s).";
} ELSEIF ($resultsnumber > 0) {
PRINT "Your search returned $resultsnumber results<BR>Listing
them in order of relevance<BR><BR>";
for($count = 0; $count < $resultsnumber; $count++) {
$body = mysql_result($getresults,$count,"blob");
$qid = mysql_result($getresults,$count,"qid");
//tighten up the results
$body2print = substr($body, 0, 100);
$cnote = $count+1;
PRINT "$cnote. <a href=yourcontent.php3?qid=$qid>
<i>$body2print...</i></a><BR>";
}
}
?>
Presto, you've got keyword searching for your database, complete with
relevancy ranking. It may not be Google
or altavista.
It may not support all those fancy boolean operators, or excite's (*cough*)
conceptual mapping technology. But
it works, its quick
and enough to handle your user's demand.
PHPBuilder
Policies
PHP Developer
Topics
PHP Developer
Resources
PHP Developer
References
