Home arrow PHP arrow Creating a Searchable Inventory System: Retrieving and Managing Search Results (continued)

Creating a Searchable Inventory System: Retrieving and Managing Search Results (continued)

In this article, we will set up an automatic search listener to execute the code for our searchable inventory system. With this final piece, we will assemble all of the parts of our application into a working search tool. It will allow us to search for records using any combination of the search forms, as well as sort those records by almost any of the resulting column headers.

TABLE OF CONTENTS:
  1. Creating a Searchable Inventory System: Retrieving and Managing Search Results (continued)
  2. Automatic Search Listener
  3. Explaining the Function
  4. Displaying Search Results
By: Brian Vaughn
Rating: starstarstarstarstar / 4
November 29, 2005

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

In the previous article, we introduced some important concepts, the most important of which was the “get_search_results” function. This function pieces together all of the static elements of our SQL query (located within the “inc.conf.php” file), and appends all of the dynamic, user-driven portions as well into a complete SELECT statement that allows us to retrieve an organized set of results and return them in the form of an array. This array can then be displayed in any manner we see fit within our “index.php” file.

All of the logic is now in place to run our search, but we have not yet set up a search listener to execute the code. Let’s take a look at that now.



 
 
>>> More PHP Articles          >>> More By Brian Vaughn
 

blog comments powered by Disqus
   

PHP ARTICLES

- PHP Closures as View Helpers: Lazy-Loading F...
- Using PHP Closures as View Helpers
- PHP File and Operating System Program Execut...
- PHP: Effects of Wrapping Code in Class Const...
- PHP: Building Concrete Validators
- Sanitizing Input with PHP
- Executing Shell Commands with PHP
- Handling File Data with PHP
- File Security and Resources with PHP
- ArrayObject PHP Class Examples
- ArrayObject PHP Class: An Introduction
- Getting File System Data with PHP
- PHP Tools for Working with the File and Oper...
- Working with the File and Operating System w...
- PHP Proxy Patterns: Completing a Blog


© 2003-2012 by Developer Shed. All rights reserved. DS Cluster 1 - Follow our Sitemap

Dev Shed Tutorial Topics: