Simple PHP search engine for my site

[vsd32]

I finished a website without a search engine facility for it (signature for details).

I want to develop that facility.
I have all my pages STATIC on the server, and using php i would like to build a simple search for my site.

I made something but the respons time is not so good using the database (huge databse), so that's why i would like to use my static pages.

Any help is appreciate.

[spikeZ]

You have STATIC pages and the info in a batabase?!

Ok well that confuses me slightly.
Do you mean you have something like: http://www.lyricsrec.com/lyrics/cassie-steele/index.php and on that page a query to pull the records out?
or that each page has the lyrics hardcoded onto them?

You mention that you wrote something already, can you post it?

[vsd32]

I have the lyrics in database and also on static pages.

I have this code now

$resulttsearch22=mysql("db_name","select ID,Text from lyrics");
$num_cautari2=mysql_num_rows($resulttsearch22);
for ($c=0;$c<$num_cautari2;$c++)
{
$relevancy=0;
$row=mysql_fetch_object($resulttsearch22);
$mypage=$row->ID;
$mycontent=strtolower(strip_tags($row->Text)); 
for ($d=0; $d<$q_num; $d++)
{$liungimeasasa=strlen($q_array[$d]);
if ($liungimeasasa>2) 
{
$mycontent=substr($mycontent, 0,1000);
$relevancy+=substr_count($mycontent, strtolower($q_array[$d]));
}
}//end of for
if ($relevancy>0)
$res["$mypage"]=$relevancy; 
if (count($res)>0)
arsort ($res);

}

[vsd32]

So nobody can go on from there?

[Cups]

>I made something but the respons time is not so good using the database (huge databse), so that's why i would like to use my static pages.

I'd do yourself a favour and take a look at how mysql's FULLTEXT search works before damning your database as slow.

[earl-grey]

If MySQL's built-in full-text search doesn't work well in your case, you might want to have a look at: mnoGoSearch and Sphinx.