Search engine

[Anon]

I am making a search engine that looking in a flat-text database. I know how to do the seach engine if I have an exact match, but I want to also have partial matches. Anyway to do this? Any help would be great!

[Anon]

Your SQL should look like:

$sql = "SELECT * FROM mytable WHERE myfield LIKE '%bus%'";

This will find bus, business and omnibus.

Best wishes,

James

[Anon]

Its a flat text database 😉

[Anon]

What's your existing code like then? I take it we want to modify that?

James

[Anon]

Here is the basic code:
for($num = 0; $num < count($afile); $num++)
{
$bfile = explode("|",$afile[$num]);
if($bfile[0] == $searchstring) {
print("<tr><td width=\"200\" height=\"14\" valign=\"middle\" bgcolor=\"#4A6E95\"><font color=\"#ffffff\">$bfile[0] ($openedgame)</font></td>\n");
print("<td width=\"90\" valign=\"middle\" align=\"center\" bgcolor=\"#223859\"><a href=\"javascript:link('http://www.3dstream.net/jukebox2/player.php?game=$game&midiname=$bfile[2]&midi=$bfile[1]')\" class=\"white\">Play (JS)</a></td>\n");
print("<td width=\"90\" valign=\"middle\" align=\"center\" bgcolor=\"#223859\"><a href=\"http://www.3dstream.net/jukebox2/player.php?game=$openedgame&midiname=$bfile[2]&midi=$bfile[1]\" class=\"white\">Play</a></td>\n");
print("<td width=\"90\" valign=\"middle\" align=\"center\" bgcolor=\"#223859\"><a href=\"http://www.3dstream.net/jukebox2/midis/$game/$bfile[1]\" class=\"white\"><font color=\"#ffffff\">Download</font></a></td></tr>\n\n");
}
}

[Anon]

Thats a bit messy..ekk...
here, its a little nicer:

This is what I am using for the exact search:

if($openfile[0] == $searchstring) {
print("Search result $openfile[0]");
}

This works great.. I just need a partial match way now..

[Anon]

This would work (yes, the double equal "!==" is real).

if(strpos($openfile[0],$searchstring) !== false)
{
&nbsp;&nbsp;&nbsp;print("Search result $openfile[0]");
}

That would work, or the slower method would be with a regex. i.e.

if(ereg($searchstring,$openfile[0]))
{
&nbsp;&nbsp;&nbsp;print("Search result $openfile[0]");
}

G'luck,
Jack

[Anon]

I get a parse error when I do that...

[Anon]

the ereg thing works, but it does not like two string matchs... Like:

My Theme #results in nothing

Theme #Tons of matchs

[Anon]

My Bad, it works! (the second problem, not the parse error)