Save data from a form

we

webcrea 06 Apr, 2017

hi,

If i understand, there is a project demo, where is it please?

I try to save data from a form :
- Create fn save data but i don't no for provider data, for the moment i put {var:form-edit} where form-edit is the name of the form
- update conditions : id={var:form-edit.id}

reult

Unknown column 'id={var' in 'where clause' SQL=UPDATE `#__mesData` AS `maData` SET `nom` = '', `valeur` = '', `information` = '' WHERE `id={var` = 'form-edit.id}';

😉

thanks

Max_admin 06 Apr, 2017

Hi Chris,

The demo projects are under "custom project", or when you click "new" (new versions).

If you want to save the form data then you will need to call a "Save data" function in the event where the form submits, the update conditions can be left empty if you don't need to update.

If you want to supply update condition then this is the correct syntax:

id:{some_var}

Best regards,
Max

Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?

we

webcrea 06 Apr, 2017

Thanks Max,

I did it in event and the save process reaveals an error mysql

for WHERE `id={var` = 'form-edit.id}'; ok id:{some_var}

bur you see the fields to be update are empty SET `nom` = '', `valeur` = '', `information` = ''

I forgot something...?

best regards

Max_admin 06 Apr, 2017

Answer

Hi Chris,

Yes, that var is wrong, in normal cases, you should NOT have an "update condition", the data provider should be set to {data:}

BUT, if you want to capture the form data and the form fields names have a model, e.g: Model[nom], then you need to use {data:Model} instead.

Please try that and let me know.

Best regards,
Max

Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?

we

webcrea 06 Apr, 2017

1 Likes

All right,
Only {data:} for provider and nothing in the other fields and that works fine
It's too simple😉
Thanks Max

Forums

Save data from a form