MySQL Building User Interfaces

Utility Functions of the Application

In this section, you will construct the functions that will do the majority of the work for your application. You will construct these functions to make them as independent of any user interface as possible. This not only makes them easier to test during bug-tracking activities (“What is causing the bug: MySQL, the text box, or something else?”), but it forces a clarity of thought on the functions by forcing you to ask “What is this function really trying to do, what minimal inputs are needed, and what minimal outputs are required?” For example, when you’re selecting a value (a customer number in this case), the input is the customer number, and for the output you would prefer to have a “record” rather than ...