Getting information from a DB table to include in your form
ChonoForms' DB Connection provides a useful tool for saving to the database but is more limited when it comes to getting data back again and using it to control forms or to display for editing. The Profile plug-in lets you recover a single record, and ChronoForms' sister product, ChronoConnectivity, is intended to help you display longer lists of results.
In this recipe, we'll look at getting information from one or more database tables for use in our Form HTML. Very similar code can be used to get information for use in other parts of a ChronoForms form, for example into an e-mail template.
Getting ready
There isn't any obvious preparation for this recipe. What we'll do is look at each of the common types of form input in turn and see how to display the extracted information in the Form HTML.
How to do it...
1. Getting the information from the database
We've seen several examples of this in this book already, most recently in the drop...
