Download submission data

  • barryblizzard
    Asked on February 15, 2017 at 10:27 AM

    Is it possible to read the submission data directly from the database instead of having to export to CSV first.

    I would like to read it via Mysql or using php etc.

  • Jan
    Replied on February 15, 2017 at 12:30 PM

    My understanding is that you want to connect the form to your MySQL database.

    It is possible to send the form submission to your own MySQL database using PHP. However, you will need to create a script that will serve as the landing page for the receiving post data. That script will insert the submitted post data to your MySQL database. Please refer to this guide: https://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP.

    You might also want to check JotForm Webhooks. Here's the link: https://www.jotform.com/help/245-How-to-Setup-a-Webhook-with-JotForm.

    You can find an example in this guide: https://www.jotform.com/help/248-Webhook-PHP-Script-Examples, please check the number 3 example.

    Download submission data Image 1 Screenshot 20

    We also have an app called MySQL Export. This will allow you to export the data and import using phpMyAdmin.

    Hope that helps. Thank you.

  • barryblizzard
    Replied on February 15, 2017 at 2:46 PM
    That looks useable but when does it run th ecode. I have a thank you script and the submit goes to paypal. Will this run when submit is clicked ?
    Barry Brown CITP; MBCS; APM; Bsc Econ,
    Technical Director,
    GURU Consultancy Limited,
    M : 07903 804715
    ...
  • Jan
    Replied on February 15, 2017 at 4:23 PM

    After the payment was made, the user should be redirected to the Thank You page. Please do try it and let us know if you encounter any errors. Thank you.