# Search Database - New

#### **Purpose**

The **Any Page Text u**tility is used to enter unique text items for identified site pages. On any webpage there are various elements that are used to display 'static' text. Elements such as the page heading and text boxes used to describe something about the company or staff. Most often these are 'hard coded' into the HTML for the page. Given the nature of this GenWeb site it is better to have a mechanism where the *County Coordinator* can make changes to any page text without needing to change the basic HTML code. Thus, this module.

#### **Utility Form**

The general structure of a website page consist of a *page heading*, *page introduction text*, *table introduction text*, *table*, and *image*.

[![utility_search_form.png](https://wiki.txfannin.org/uploads/images/gallery/2024-09/scaled-1680-/utility-search-form.png)](https://wiki.txfannin.org/uploads/images/gallery/2024-09/utility-search-form.png)

#### **Sample Output**

Three columns of information are provided as seen in the sample output below. The output is the result of a search for Smith. The Search module searches all table in the database, with the exception of the *transaction* table. See the next two Utility page for a further discussion of the *transaction* table.

1. **Table Name** - This column identifies the database **table** where a search parameter was located.
2. **Rec Id #** - This column identifies the **record** number within the table where a search parameter was located.
3. **Column Name** - This column identifies the **column** name where a search parameter was located.

[![utility_search_output.png](https://wiki.txfannin.org/uploads/images/gallery/2024-09/scaled-1680-/utility-search-output.png)](https://wiki.txfannin.org/uploads/images/gallery/2024-09/utility-search-output.png)