How to read data

display data from a database based on a user-submitted parameter.

Overview

The issue is not knowing how to configure a CF form to query and show database records after a user enters a search term.
Use the Conditions box in the db read action to map the form field to a database field, then use the on found event with an action like Display message to show the results.

Yu Yudhizth 28 Oct, 2014

How to read data when we type parameter?
For example, I have form that only contain textbox and button. When I type registration id, and click submit button. There will displaying data depends on registration id .
Thanks

Max_admin 28 Oct, 2014

Answer

You can use the "Conditions" box in the "db read" action:


<?php
return array("db_field_name" => $form->data("form_field_name"));

Regards,
Max

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

Yu Yudhizth 29 Oct, 2014

Thanks Max,
And how to display the result?
Is we have to configure on found and on not_found event?

Max_admin 29 Oct, 2014

Yes, you probably want to use the "on found" event, and you can pick any action based on what you want to do with the result.

You can try the "Display message" action and use:

Test text {field_name}

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

Yu Yudhizth 29 Oct, 2014

Oke, I'll try it.
maybe you can check my post. https://www.chronoengine.com/forums/posts/f2/t97888/cannot-save-into-double-table.html

This topic is locked and no more replies can be posted.