Just a quick announcement that I’ve updated my search script for Boolean matching in MySQL. The latest version is available for download on the PHP/MYSQL Search Engine script page.
The changes to this version include:
- Fixed: various minor bugs
- Fixed: multipage results not available with quoted strings
- Fixed: full-text query problem
- Fixed: some compatibility issues with different PHP/MySQL configurations.
- Added: sortable results
- Added: configurable field label names
- Added: sample results page
- Added: test mode for troubleshooting.
It’s not a massive update; but the script should be easier to use and more reliable.
Nice job Joe. I do want to note one thing: The
ereg()/eregi()functions will no longer be supported with PHP6 so you might want to replace that withpreg_match()in the next build.Comment by Mike Cherim (101 comments.) — October 23, 2007 @ 8:25 am
Certainly worth noting. I can’t honestly say that PHP 6 is at the front of my thoughts right now — - given how long it takes for these things to move into production environments. However, since
pregfunctions are available now, I might as well make the switch!Thanks -
Comment by Joe Dolson (377 comments.) — October 23, 2007 @ 9:40 am
Thanks for this lovely site and this utility. I wonder, is there a reason why it searches for whole words only? We have a small database but there are some technical terms which are difficult to spell. Is it possible for users to add an * or something if they want a truncated value?
Comment by Susan — June 19, 2008 @ 8:52 am
In fact, it does support the “*” wildcard operator. It’s only available as a final wildcard, but you can enter “cur*” to perform a search for terms beginning with “cur.” (Curtain, curtail, current, etc.)
I think that this is documented in the script somewhere, although I’ll be honest that I don’t recall the details right now…
I appreciate the comment, however, and I’ll make a point of adding that to the documentation as soon as possible!
Comment by Joe Dolson (377 comments.) — June 19, 2008 @ 12:18 pm