how do you create a form to store data on database?

[matta]

Hi guys,

I want to create a form and store the data on a database.

How do I create a table to insert information into it?

This is really frustrating, I dont want the information emailed. and there is no documentation about it at all!

[markhurd]

When you create a new form via the Form Generator, there is an option to store data under the "Store form data" section.

As far as I can tell, there's no way to create a database table from within TYPOlight. You'll need to use your webhost's control panel, phpMyAdmin, etc., to manually create the table.

To test, I just added a table (tl_form_data) via phpMyAdmin and it was listed as an option in the select dropdown after checking the "Store data" option. I'm running 2.7.5 in my testing environment.

[geung]

You could also use the EFG - Extended Form Generator http://www.typolight.org/extension-l...120019.en.html
It saves data from any submitted form that was custom made in the form generator, so you can view it in front or back end, it provides nice tables to view and edit the data in TYPOlight backend.

It does the same thing as the "Store data" option in forms that markhurd mentioned. But it creates database tables by itself.

[EDIT]
uhhhh I think FormAuto does similar things!!!!
http://www.typolight.org/extension-l...000099.en.html

[matta]

Thanks guys,

Yea I tried creating a table in phpMyAdmin, but the data didnt store, it was probably because I have no experience with mysql at all.

EFG kept getting errors and didnt work either, so I tried FormAuto and it works great!

The only issue I'm having now is that Typolight doesn't send data to my email address. Also using the "confirmation email" in FormAuto doesnt work either, but its a Typolight base issue, and not FormAuto issue.

I checked system/log/email.log but there are no errors in there.

Any ideas why emails may not be sending?

[geung]

check your form settings. I've only ever done it one way and this is it.

go to the form header section of your form (where the settings are).
In 'Send form data' - 'Send form data via e-mail'
make sure you've chosen 'Data format' as Raw Data.
it will send it via the mail php script.

try that! good luck

[matta]

Thanks guys.

using formauto and loving it. turned out that the hosting provider had restrictions on the server that was preventing it from happening.

Efg still wouldnt work though for some reason.