I've searched, scanned and have not found any simple instructions on what one needs to do to:
1) Have a form's contents written to a database. I know there needs to be code put in onSubmit, but are there some examples?
2) Retrieve the information - i.e. read it back out. I've seen the response for sofia's property listings - and that may make sense if I can figure out how to put data into a database....
Are there any tutorials for that? A hello world, I'm stored and not e-mailed?
I've got a clean Joomla 1.5 with mysql installed. Any pointers would be appreciated.
Hi bradolive,
To store data click the 'Create Data Table' link in the Forms Manager view.
To turn off email - set 'Send email' to No in the General tab for your form.
How you retrieve the info depends on what you want to do with it. ChronoForms has a simple record viewer built in.
Bob
Thanks! Hit me on the head with the Doh! hammer....
After clicking create table,it gives error "Not enough form fields to create table "Please help me
Hi rosemary,
You have to select the fields that you want recorded using the checkboxes at the left. You can 'select all' but you probably don't want 'submit' or 'reset' recorded in the database.
Bob
rosemary, either your form code doesn't have fields at all or your field names are written in an improper format like name=field without " " or there are some spaces, the ideal field name is :
name="field_name"
Cheers
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Hello,
I am trying to set up Chronoforms to write to a db and also send a notification email.
I have followed the steps to create a table and assign that table to the form to write to it.
Now, I am getting the following error on the form page:
Parse error: syntax error, unexpected '$', expecting T_VARIABLE in /home/hudson/public_html/site/components/com_chronocontact/chronocontact.php(48) : eval()'d code on line 13
and this error upon submission:
Parse error: syntax error, unexpected '$', expecting T_VARIABLE in /home/hudson/public_html/site/components/com_chronocontact/chronocontact.php(48) : eval()'d code on line 13
Fatal error: Call to a member function bind() on a non-object in /home/hudson/public_html/site/components/com_chronocontact/chronocontact.php(577) : eval()'d code on line 10
These errors go away if I disable db storage.
Any help?
Thanks in advance,
MASS
Hi masshoff,
Looks like there is a typo somewhere in Line 13 of the Autogenerated code. Can you please paste it here for us to take a look.
Bob
Hi masshoff,
That looks like the code from the Form HTML box - it's the code on the Autogenerated Code tab we need for this.
Bob
Hi Mass,
please open your form at the admin area and save it again and then retest, if this didn't work then remove any sensitive info and backup your form and attach it here, I need to check something!
Regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
still no luck.
file attached. thanks for all the help!
Hi, I see you have column names called "1-5", thats wrong, open your table in phpmyadmin and make this like "1_5" and any other fields with similar names then open the form and save it again to reinitialize the DB table class and it should work! you can create another table and connect to it as well!
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Hi and thanks for the reply.
That did NOT seem to fix the issue. Went into the table and changed column names - still getting the same error.
I tried recreating the table as well - this time not using "-" but using "_" instead.
same problem - same error.
any thoughts?
please backup your table structure and put it here and I will restore it and test on my machine! please put the SQL directly into the forum post code tags.
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Hi, we have fixed similar issue earlier today, fields names cant start with numbers! change them and all will be fine
Cheers
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
that did it. stupid error on my part.
thanks - great help on these forums!
Thanks, No problems really, this is how we learn😉
Cheers
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Would field names beginning with an * cause the same problem?
I use an asterisk to indicate a required field.
Thanks!
sure, its not HTML good or db column name too to have a name starting with *
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.