I'm looking at Chronoforms as a possible solution to a problem that I have. I have the form all set up, and now, I am wondering if it's possible to store the information locally in a chronoform table, and then pass the information along to an external database for the actual processing. Can this be accomplished with php code in the on submit box? I have it set up now to where the external site does all of the processing, including sending the validation emails etc. I would like to keep a local copy of the submissions so that I can verify everything with the external database. Any help would be much appreciated.
Hi insurance,
Yes you can do that, you'll need to create a second Joomla database connection then you can use standarad Joomla db code to write to any accesible database.
Bob
Yes you can do that, you'll need to create a second Joomla database connection then you can use standarad Joomla db code to write to any accesible database.
Bob
Thank you for the prompt response Bob. I'm not a technical person, but while researching this further and searching the forums for other references to a second database connection, I'm going to try this:
I've basically taken the "autogenerated" code from one of the pages, and inserted it into On Submit-Before Box. While I am testing, I am assuming that this will cause the entries to be duplicated in the table. At that point, I will add a submit URL to Form URL tab, which will process it both forms. Am I on the right track?
I've basically taken the "autogenerated" code from one of the pages, and inserted it into On Submit-Before Box. While I am testing, I am assuming that this will cause the entries to be duplicated in the table. At that point, I will add a submit URL to Form URL tab, which will process it both forms. Am I on the right track?
Hi insurance,
The code for a second db connection is here.
Copying the Autogenerated code using the second connection will probably work if the field and table names match up correctly. It might be simpler to wrote the MySQL query from scratch though as the AutoGnereated code uses some internal Joomla classes that work well but make the process less visible and harder to debug.
Don't use an OnSubmit URL, leave that field blank if you want ChronoForms to process the results.
Bob
The code for a second db connection is here.
Copying the Autogenerated code using the second connection will probably work if the field and table names match up correctly. It might be simpler to wrote the MySQL query from scratch though as the AutoGnereated code uses some internal Joomla classes that work well but make the process less visible and harder to debug.
Don't use an OnSubmit URL, leave that field blank if you want ChronoForms to process the results.
Bob
This topic is locked and no more replies can be posted.
