What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

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

    Asked by AA_C on February 08, 2016 at 01:42 PM

    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

    submission data collect a solution another current
  • Profile Image
    JotForm Support

    Answered by Kevin_G on February 08, 2016 at 04:11 PM

    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.

  • Profile Image

    Answered by AA_C on February 08, 2016 at 04:26 PM

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

  • Profile Image
    JotForm Support

    Answered by Kevin_G on February 08, 2016 at 05:42 PM

    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.

  • Profile Image

    Answered by AA_C on February 08, 2016 at 08:48 PM

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

  • Profile Image
    JotForm Support

    Answered by mert on February 09, 2016 at 04:25 AM

    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.

  • Profile Image

    Answered by AA_C on February 09, 2016 at 04:24 PM

    One thing of note is that I find the reports generator tool generates a much cleaner excel sheet then using the view submissions,excel option.

    Same for the csv option there, it can make a very messy file also, mine were useless.

    I haven't tried the Reports csv option yet.

    Perhaps its just me... Just my 2 cents... wait we don't have pennies in Canada any more so I guess a nickles worth then.

    Robert

  • Profile Image
    JotForm Support

    Answered by Kiran on February 09, 2016 at 10:22 PM

    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!