How to send submission data to MySQL database?

  • Profile Image
    BradleySlavik
    Asked on May 08, 2015 at 12:48 PM
    When someone fills out the form I want to save it to a local MySql database.
  • Profile Image
    raul
    Answered on May 08, 2015 at 12:53 PM

    Please refer to the following guide: http://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP to accomplish this.

    Should you have further questions, please let us know.

  • Profile Image
    BradleySlavik
    Answered on July 22, 2015 at 01:24 PM

    That page worked very well. I modeled my PHP code after it. You might consider telling people that the FormID and SubmissionIDs require BIGINT in MySQL or they will overflow and consequently will not end up saving the correct value.

     

    Thanks!

  • Profile Image
    david
    Answered on July 22, 2015 at 02:10 PM

    Thank you for the information.  We will have a look and see if our guide needs some updating.  If you need help with anything else, let us know and we will be happy to do what we can.