Book Image

ChronoForms 3.1 for Joomla! site Cookbook

By : Bob Janes
Book Image

ChronoForms 3.1 for Joomla! site Cookbook

By: Bob Janes

Overview of this book

Joomla! is a fantastic way to create a dynamic CMS. Now you want to go to the next step and interact with your users. Forms are the way you ask questions and get replies. ChronoForms is the extension that lets you do that and this book tells you how. From building your first form to creating rich form based applications we will cover the features that ChronoForms offers you in a clear hands-on way. Drawing on three years daily experience using ChronoForms and supporting users there is valuable help for new users and experienced developers alike. We will take you through form development step by step: from creating your first form using ChronoForms’ built-in drag-and-drop tool; validating user input; emailing the results; saving data in the database, showing the form in your Joomla! site and much more.Each chapter addresses a topic like ‘validation’ or ‘email’ and the recipes in the chapter each address a different user question from the beginners’ question ‘How do I set up an email?’ through to more advanced questions like using some PHP to create a custom email Subject line.Over eight chapters and eighty recipes we cover all of the ‘Frequently Asked Questions’ that new users and developers have about using ChronoForms. The recipe structure allows you to pick and choose just the solution that you need.
Table of Contents (17 chapters)
ChronoForms 3.1 for Joomla! Site Cookbook
Credits
About the Author
About the Reviewer
Preface

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. 1. Getting the information from the database

    We've seen several examples of this in this book already, most recently in the drop...