Combining data from database with form controls

m.vinod 05 Nov, 2008
Hi,
I am designing a web page that initially displays a set of items with a radio button attached to each of the item retrieved from the DB.
The form should also have a submit button.
Can someone help me with doing this.
Cheers,
Vinod
GreyHead 05 Nov, 2008
Hi m.vinod,

You mean something like this?

[attachment=0]mockup.png[/attachment]

Use the ChronoForms wizard and you can drag and drop the items on to you form.

Bob
m.vinod 05 Nov, 2008
i would like this to be dynamically generated based on the data in the DB. can i do it without using scripting.
Max_admin 05 Nov, 2008
Hi, you will need HTML knowledge and to combine Chronoforms and ChronoConnectivity, you will need to understand the theory behind connectivity very well and to use the chronoforms mambot, or just do it with Chronoforms and some PHP to load the database records and run over them!

Cheers
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
m.vinod 06 Nov, 2008
Max,

I have fetched data from the database using PHP scripts and added controls accordingly onto a form. Now the problem is when i choose
the appropriate options and click on submit I need to save the values and then display it in the next screen.

Can I put the code to save the values in the section "On Submit code - before sending email" under the form code tab in chronoforms.

My other question is once I have fetched the values based on the users selection, how will i display it in the page which I specify in the "Redirect URL" section in the Form URL's tab.
Max_admin 06 Nov, 2008
Hi vinod, you can save the values yes through the onsubmit code if you have this code to do the save, to show the data again, put some echos at the onsubmit too, or simply put field name inside 2 curly brackets in the onsubmit after email to get it shown {field_name}, and remove your redirect URL!

Cheers
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.