How to send Submissions to Your MySQL Database?

  • Profile Image
    swtemp999
    Asked on June 10, 2019 at 09:13 PM

    May I know how can Jotform Submission direct link to MS SQL Server database?

    If can please provide the coding guide also, I know MySQL got the coding guide but I still confusing. 

    Thank you.

  • Profile Image
    Roneet
    Answered on June 10, 2019 at 11:29 PM

    Please note that there is no built-in feature to send submission data to your own database but with a little workaround, it is possible to achieve your requirement. There are actually multiple options available to send your submission data to database:

    1. You can enable "Send Post Data" in your form preferences and then redirect to your own thank you page where you can read the submission data and save it in your own database. The following guide should help you:  http://www.jotform.com/help/213-Send-POST-Data-From-JotForm-Using-PHP-in-Custom-Thank-You-Page 

    2. You can also take advantage of our Zapier integration app as well. Take a look at here: http://apps.jotform.com/app/zapier_ integration  You may also like to check this which should help you: https://zapier.com/zapbook/jotform/mysql/4061/add-jotform-submissions-to-mysql/

    3. You need to POST your form's data to your own thank you page where you need to read the POST data and save it in your own database.

    You may like to take a look at the following guide which should help you: http://www.jotform.com/help/126-How-to-Insert-Update-Submissions-to-Your-MySQL-Database-Using-PHP

    4. You can directly download the SQL file of your submissions and import them in your database: Make a search of "export" by clicking on the following URL to find available apps for your database type:  

    http://apps.jotform.com

    Thanks.