News Feed

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

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

Geeks Not Nerds Blog: Rolling your own Blog Backend from Scratch Part 1

Chris Hartjes' Blog: Building a Gimmebar Sidebar

SitePoint PHP Blog: The Joy of Regular Expressions [4]

DevShed: Polishing the Visual Presentation of a Blogger with the Code Igniter PHP Framework XML and PHP Simplified

Community Events

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

community introduction opinion laravel wordpress voicesoftheelephpant release version extension example php7 series framework unittest interview podcast language laravel5 library api

All content copyright, 2015 :: - Powered by the Solar PHP Framework