Forums

Save Intermediate Datas into the db

rashgang 27 Aug, 2011
Hi

I am having two steps of registration using chronoforms. I need to save the data inbetween these steps into jos_users table. how to submit the data in onsubmit event chronoforms. In the last step i have joomla registration field and first step of the form i having email address. i need to save these datas in the joomla registration table. Please help me 😢

first form is
Mother form which is emtpy

second form
extra fields
third form
joomla user registrations fields

i have searched in forums but i didnt get the correct way. Please help how to store data in joomla user registration fields
GreyHead 27 Aug, 2011
Hi rashgang,

Which version of ChronoForms are you using? You can find the version from Site Admin | Extensions | Install/Uninstall | Components in Joomla! 1.5 or Site Admin | Extensions | Extension Manager | Manage in Joomla! 1.6.

Bob
rashgang 28 Aug, 2011
hi bob,
Thanks for your answer. I have followed your tutorial which you have given in your forums. i installed lastest version of chronoforms(ChronoForms_V3.2.0.zip) in joomla 1.5.23. If i created singale form using joomla registration plugin the datas are saving in the database. I just need to know that php code given in those forms. Like you said in your forums sessions must be used to insert the datas into db.

tutorial followed:
http://www.chronoengine.com/forums.html?cont=posts&f=9&t=14744

In the last step of the form i have joomla regisgtration form. if i am using this
<?php
$MyForm =& CFChronoForm::getInstance();
$data = $MyForm->tablerow['jos_users'];
?>
<input type='hidden' name='cf_id' value='<?php echo $data->cf_id; ?>' />

i am getting error eval code. i didn't enabled database connection for mother forms enabled in child forms

first form is
Mother form which is emtpy(enabled email templates for this) and multi page plugin enabled

second form
extra fields
third form
joomla user registrations fields(enabled joomla registraion field)


Please help me
GreyHead 28 Aug, 2011
Hi rashgang,

Please don't save any data directly into the jos_users table. Doing this may break your site. Only save data to jos_users through the Joomla! User Object and methods. Best to use the ChronoForms Joomla! Registration Plug-in to do this for you.

The multi-page plug-in will save data between steps in the user session and recover it into the next step in the $posted array so that you can use it. This will work fine if the steps are all completed one after another in the same session.

You can save data to the database if you thank that there may be delays between completing the steps. In this case use a separate table - not jos_users - and add a database query to re-load the data before the registration step.

Bob
rashgang 28 Aug, 2011
Hi Bob,

when to use joomla registration plugin inbetween these steps.

I am using joomla registration plugin in the last forms that is second form

1)mother form(empty html)used multipage plugin
2)first form(email field and other fields)

3)registration form(used joomla registration plugin)

please take a look
http://6facesinc.com/Client/uaamusic/uaa_joomla/index.php?option=com_chronocontact&Itemid=79

if i use separate table other than jos_usres tables how to send user activation mail and other things

could you please tell me how to get the posted arrays and save into the jos_users table in the last step of the form and also i need to save email in the first form. i need to save the user entered name,username,email,password in jos_user table same to send activation mail which is used in the normal joomla registration field
GreyHead 29 Aug, 2011
Hi rashgang,

i need to save the user entered name,username,email,password in jos_user table same to send activation mail which is used in the normal joomla registration field

The ChronoForms Joomla! Registration Plug-in will handle this for you. You need to make sure that you have the data in the right format and configure the plug-in correctly.

For the rest of your data you need a separate table and a DB Connection set up, probably on the Mother form.

Bob
rashgang 29 Aug, 2011
HI bob

i have enabled joomal registratio nplugin for the last form which i need . no db connection only i have enabled plugin. I have one doubt regarding the field orders. should it be in order like normal joomla registration form. please check with the attached pictures
rashgang 29 Aug, 2011
Hi Bob,

Now it is working but i have one doubt. my email field is in the first form that is with the extra field. and other field like (name,username,password,confirm password) is in the last form. how to handle that email field with jos_user tables. how to handle the email field that is in the first form. please post the code to insert that email field alone in jos_users table
rashgang 29 Aug, 2011
hi bob
🙂

Really thankful for your answers. There is no doubt in saving joomla user regisration. All fixed. Finally i have one doubt

1) mother form(empty html)

2) child form1(how to store these datas in new table) whether i need to get the posted values and store it in new table or it will save automatically. if these fields need to be store in new table how to post. Please show me example code

3) child form 2
GreyHead 31 Aug, 2011
Hi rashgang,

I'm not quite sure what the problem is.

If the new data is just on Child Form 1 then you can use the Db Connection there.

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