Creating a Code Search Engine with PHP and MySQL
Apr 13, 2007, 06:00 (1 Talkback[s])
(Other stories by Jason Gilmore)
"I'm just a few days away from launching a comprehensive support
website for my book, 'Beginning PHP and MySQL 5, Second Edition,'
and among other features, have built a search engine for sifting
through the more than 500 code snippets found throughout the book.
This was an interesting exercise because it involves a number of
storing a fairly significant amount of text within a MySQL
database, using MySQL's full-text search facility, and devising an
effective way to extract and display the code in the browser.
"In this article I'll offer a simplified version of this search
engine, introducing you to some compelling PHP and MySQL features
along the way. You might adopt what you learn towards building your
own search engine, or towards other applications..."