News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

DevShed:
Performing Full-text and Boolean Searches with MySQL
June 06, 2007 @ 14:06:00

DevShed has started a new MySQL-centric series today with this new tutorial, an initial look at working with MySQL and PHP to perform full-text and boolean searches on your data.

In this series of articles I'm going to show you how to work with full-text and Boolean searches using MySQL and PHP 5, but the entirety of the code samples that will be developed here can be easily modified to work with a different database server.

They start with the creation of a "common approach" for making the requests and fetching the results (in classes so that any other database could be substituted). With the class structure in place, they move on to the full-text searches, showing how to format database tables by creating them with a fulltext index on which ever fields you want.

0 comments voice your opinion now!
mysql boolean search fulltext table database tutorial mysql boolean search fulltext table database tutorial


blog comments powered by Disqus

Similar Posts

PHPMaster.com: Building Your Own URL Shortener

Zend Developer Zone: Work with XML Data in the Zend Framework

Sanisoft Blog: Using CakePHP without a database

DevShed: Using Timers to Benchmark PHP Applications

Juan Treminio: Unit Testing Tutorial Part V: Mock Methods and Overriding Constructors


Community Events





Don't see your event here?
Let us know!


bugfix interview code tips community symfony laravel zendserver threedevsandamaybe development release list framework language deployment introduction series podcast api voicesoftheelephpant

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework