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

    Can I create a form that queries and submits data into a MySQL database?

    Asked by David Kelly  on February 13, 2017 at 04:39 PM

    Hello,

     

    Can I create Forms that would would perform a query search on my MySQL Database, return data to a form, allow the user to edit the data in the form, then would allow the user to submit and Update that record in the MySQL Database.  Could users also create a new record in the mySQL Database from the form?

     

    Thanks,

     

    David Kelly

     

  • Profile Image
    JotForm Support

    Answered by Kiran on February 13, 2017 at 08:09 PM

    Please be noted that the submission received by a JotForm will be stored in the respective account. Once the form receives the submission, you may send the form submission to MySQL database as well by following the guide. 

    https://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP

    If you want to query the external MySQL database and to display the information on the form, it is required to write custom code. If you are not a programmer, you may hire one from Upwork or Freelancer websites.

    Hope this information helps! If you have any other questions, please let us know. We will be happy to help.