Referencing "Form to MySQL - Send form data to your MySQL Database".

  • lplatz
    Asked on October 24, 2019 at 7:02 PM

    Referencing "Form to MySQL - Send form data to your MySQL Database". I'd like to post the data from my form to more that one table. Is that possible?

  • John Support Team Lead
    Replied on October 24, 2019 at 7:11 PM

    I believe this guide my help you achieve the requirement:

    How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP

    Please try that and let us know how it goes.


  • lplatz
    Replied on October 24, 2019 at 8:20 PM

    The script (in it's present form) will only insert into a single table.  I've posted a question requesting the ability to modify the "How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP" script to post form data into multiple tables.  Thank you for your follow-up JohnRex.

  • Jed_C
    Replied on October 24, 2019 at 9:09 PM

    If mysql supports that functionality then it should work as Jotform only sending the POST to your mysql database, this means that whatever function is supported with your mysql version should work.

    I've searched through online and found some feedback that this technically is not possible in mysql, but there are some suggestions that you can try how you can insert into multiple tables.

    Reference link: https://stackoverflow.com/questions/5178697/mysql-insert-into-multiple-tables-database-normalization

    Let us know if you have any questions or if you need further assistance.