News Feed
Sections




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

WebReference.com:
How to Create a Search Feature with PHP and MySQL
August 07, 2008 @ 07:53:10

On WebReference.com today Ryan Butler has written up a tutorial of a simple search feature that can be integrated into any site (with their content in a MySQL database).

In this article, you'll learn how to create a searchable form feature that will query a database table and display current staff member information. During the analysis you'll learn how to do the following: create a database table that will hold current staff listings, create a search form and use PHP, in coordination with Structured Query Language (SQL) to capture information entered by the visitor and append the information to display the results we want to show.

They give you the files for the project and work through each, showing how to make the database, put information in and connect to the database to run the query. He opts for the LIKE functionality in the WHERE clause to find the term as a wildcard in the FirstName field. It's not the most efficient, but it can be useful.

0 comments voice your opinion now!
mysql search engine like wildcard tutorial


blog comments powered by Disqus

Similar Posts

ITNewb.com: PHP Encryption / Decryption Using the MCrypt Library (libmcrypt)

Chance Garcia's Blog: MAMP PRO, PECL, SSH2, and OSX CLI (AKA acronym madness)

PHPMaster.com: Understanding Streams in PHP

The Bakery: 13 New Tutorials and Articles Posted

Robert Basic's Blog: A Zend_Captcha example


Community Events





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


interview laravel artisanfiles podcast version security release library tool conference opinion framework list series language community introduction voicesoftheelephpant composer symfony

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