Writing a Form-Based Search Application

In this section, we’ll develop res_search.pl, the initial version of an application designed for searching residential real estate listings. The section describes how to set up the underlying tables, generate the search form, interpret parameters when users submit searches so that we can construct appropriate queries, and display the results.

The application relies heavily on functions in the WebDB and WebDB::TableInfo modules that were written in Chapter 6, “Automating the Form-Handling Process,” so you probably will need to take a look at that chapter if you haven’t already read it. Specifically, we’re going to construct a number of search form elements by asking MySQL to provide information about the ...

Get MySQL and Perl for the Web now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.