CGI Programming 201: Chapter 10: Searching the Forums

Name Description

search.txt Search Form (source code)

search2.txt Search CGI (source code)

Errata

Modified search2.cgi to use this line instead:

push(@searchary, qq(message RLIKE '\[\[:<:\]\]$1\[\[:>:\]\]'));



This pattern matches the given word on a word boundary, so if you
enter a search phrase of "foo" it doesn't match things like "fooblies".
See the MySQL Manual: Regular Expressions for a more in-depth look at special regexp patterns.



Additional Resources

MySQL String Comparison Functions (LIKEi and RLIKE)
MySQL Pattern Matching
MySQL Regular Expressions


All text and scripts are excerpted from CGI Programming 201, and are copyright © 2002 by Jacqueline D. Hamilton. Unauthorized reproduction of this material is prohibited.





Table of Contents |
Order the Book |
CGI101 Home

	`Name`	`Description`
	`search.txt`	Search Form (source code)
	`search2.txt`	Search CGI (source code)