Export forms capture information.

rob_illinois

I post this in the Database area but was told to post here as it would be better answered here. The basic idea I am after is I want to be able to export or all the information captured from the forms users submit. I have several forms all have differant fields and drop down options all which I want to capture and then export. I would like the export to be Excel format so I can if needed add more columns for local use. If needed I could do one for each form to make it easier for the different fields on them all.

So I what I would like to know is if there is a script now that does this or a tutorial that would take me through this. If it is easier to do I would be open to a login area to view the file in a secure are on my site also so either export or a way to intergrate to the online site. Thank you for any help on this.

This is what I posted:

I have a website now I am making with a backend database. I have a few forms on it that have users fill out information and select from drop downs and check boxes. I want to be able to capture the data the enter and store in a DB that I can login to and see from the admin area or export to an excel file and view. This is a lead generator website.

I would then look at the data and be able to add in if it is a good lead or dead ect. What is the easiest way to do this or to start it?

Thanks

big_nerd

rob_illinois,

What version of PHP are you running? And what Database Background is it?

You would have to script it for each form as the script needs to know what data fields to record and where to put them.

For exporting to excel, I started with PEAR, it has an example on how to write excel files (which you can generate so long as you can get the info into PHP).

Truely, the easiest way would be to export to CSV, there is lots of tutorials on that, which you could open in excel, format, etc for export.

There is information on pulling it from an SQL Database Here.

You can get a step by step lesson on forms here

Good Luck