BadDog's mySQL Boolean Search Script

[BadDog]

Here is a experimental release for anyone looking for a better search for mySQL. I wrote it this way so it will be compatable with mySQL 3.x. By default it searches for all of the words entered, will search by phrase using quotes. Will also accept NOT to exclude a word. Example: tony blair NOT bush will return all records with tony blair but not bush. I also have this search creating pagination with crude PREV <--> NEXT links.



Back up your current search.php and just replace it with this script and cross your fingers it works for you like it works for me under Windows and Linux.

[FI-DD]

Wow, I'm really impressed. That's fantastic.



It finds everything as promised.



A few bugs and suggestions:

1. I think you don't have to connect to the database in search.php. It's been already done in head.php.



2. It doesn't search in title of the news, I think.



3. You have to add the type-variable to the pagination link: &type=$_GET[type]

Otherwise the pagination breaks.



4. It took me a while to find out that it only works with "and, or, not" instead of "AND, OR, NOT" in contrast to your descriptions.



5. The result link doesn't work properly.

change this:

echo "<a href=\"?id=". $id . "\"><b>$sTitle</b></a><br>". $desc. "<p>\n";



to this:

echo "<a href=\"$config_http_home_url?id=". $id . "\"><b>$sTitle</b></a><br>". $desc. "<p>\n";

[PJR]

It works.. But I'd welcome to use the Search template...

[BadDog]

Yikes, found two more bugs that did not belong. OK, this second one looks stable and does the job. Plenty of framework for you all to improve on till my next work break were I can get time to fool with it some more to add things.

[Syrion]

How can I use this script to show the output in another page? (searchresults.php for example?)

[scottdallas]

How can I use this script to show the output in another page? (searchresults.php for example?)

Let me take a look real quick. I know I've got it to work like that before.



Change:

Code: Select all

<form method="get" action="<?=$_SERVER['PHP_SELF']; ?>" align="center">

To:

Code: Select all

<form method="get" action="searchresults.php" align="center">

Or:

Code: Select all

<form method="get" action="../searchresults.php" align="center">

Depending on where you put searchresults.php.. Usually I have 'searchresults.php' in ../



By the way, I didn't test it and I can't remember... you might have to put searchresults.php? with the question mark on the end.. so try with searchresults.php and if that doesn't work, add a ?

[rats]

could this plugin be a little bit modified? you know... merge it with rufus and the quick tags?



my search results look pretty naaasteeeaaah!

[asson]

Thanks for this great plugin.

Where does it get the template from after klicking the news?

When i Search and results are shown, after klicking on them it shows the news with a template that does not look like any template i'm using!



Regards

[asson]

I fixed it, thanks anyway.

[scottdallas]

What template does it use? This has been baffling me

[Disharmony]

How do I get the links to show up in RUFU?

[flyboy17]

Nice job
It only search in the title en short story? Is there a way to search in the whole story also?
Thanks

[FI-DD]

Try this:
http://forums.cutenewsru.com/search-for ... -t456.html

[flyboy17]

Works fine, thanks

[Disharmony]

I replaced it with that one but when I punched in a keyword on the search box it just forwards me to my results page with the search form there and no results.