I need a way to collect submission data for MySQL database - RESOLVED

I need a way to collect submission data for MySQL database. Your current applications are not working.

I need a solution ASAP. Do you have another option.

Robert

The only way to send your submissions data to your database is sending the data to your thank you page, you will find the steps on this guide: http://www.jotform.com/help/51-How-to-Post-Submission-Data-to-Thank-You-Page.

Once you have allowed your form to send the submitted data, you may follow this guide: http://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP.

That is the correct way to achieve what you want, if you have some issues when doing it, do let us know, we will be glad to take a look on it.

It is a bit late to being doing that now. I have almost 900 submissions already and need that data not new data.

You can try creating an Excel file, I mean, download your current submissions and then import them into your table in your database, I found an article with steps to import the data from an Excel file into a table in MySQL: http://stackoverflow.com/questions/1310166/how-to-import-an-excel-file-in-to-a-mysql-database.

And you may also follow the steps provided above, to send your new submissions to your database.

This guide will help you to download your submissions in Excel format: http://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel.

Hope this helps.

Hi Kevin, This did the trick thank very much. Robert

In the name of my colleague, you are most welcome. If you need any further assistance, please don't hesitate to contact us.

Have a great day.

I've moved the other issue with exporting submissions to Excel/CSV to a separate thread and shall be answered there shortly.

http://www.jotform.com/answers/768592

Thank you!