PHP Search

[scrubbicus]

Hey, I'm trying to find a decent script that I can take a look at and find out how I might go about coding one of these. Is there a way to make a search script purely out of PHP; or maybe out of purely some other language? This search would only search the website for any relevant queries.

[WolfRage]

There are tons of them just google "php search site" . Then start checking over your options add Open Source if you want to see the code.

[The Little Guy]

I do it like this:

 

$trimmed = trim($_GET['q']);
$query = "SELECT *,code,name,
MATCH(code) AGAINST ('$trimmed' IN BOOLEAN mode) AS score1,
MATCH(name) AGAINST ('$trimmed' IN BOOLEAN mode) AS score2
FROM snippets 
WHERE  
MATCH(code,name) AGAINST ('$trimmed' IN BOOLEAN mode) ORDER BY score1 DESC, score2 DESC";