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

    Download submission data

    Asked by barryblizzard 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.

  • Profile Image
    JotForm Support

    Answered by Jan 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.

    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.

  • Profile Image

    Answered by barryblizzard on February 15, 2017 at 02: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
  • Profile Image
    JotForm Support

    Answered by Jan on February 15, 2017 at 04: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.