News Feed
Sections




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

PHPFreaks.com:
Simple SQL Search
May 08, 2009 @ 09:30:06

In a new article on PHPFreaks.com Brad Jacobs takes a look at creating a simple search of the information in your database. Their example will search a table containing article information (title, story content, etc).

The aim of this tutorial is to provide users with a basic layout and the logic behind creating a multiple field search in MySQL. As often time users tend to over do the search and add a lot of unnecessary code. By following and understanding this tutorial you should be able to implement this search into your own site and provide a nice and simple SQL Search of your own database. So roll up your sleeves and be prepared to get dirty.

Everything's provided for you - the SQL to build and fill the tables and the code to perform the search. They opted to go with LIKE statements in the where clause instead of using something like full-text searching. The former works for a lot of situations, but can get slower and slower the more rows there are in the table.

0 comments voice your opinion now!
simple tutorial sql search mysql fulltext article content title


blog comments powered by Disqus

Similar Posts

Jose de Silva's Blog: Speeding up your application with Cache_Lite

Jonathan Street's Blog: When scraping content from the web don't make it obvious

WeberDev.com: PHP 101 (part 14): Going To The Polls

Rob Allen: Using Doctrine Migrations as a standalone tool

Zend Developer Zone: Book Review: Professional Search Engine Optimization with PHP


Community Events

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


extension introduction community release series threedevsandamaybe laravel framework voicesoftheelephpant interview library wordpress development unittest laravel5 podcast api feature language opinion

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