Connect form to database

  • DoyleShipping
    Asked on August 12, 2020 at 9:42 AM

    How do I connect my form to a data base so that the forms will update the database?

    i.e. Fruit collections form

    Database has 30 oranges and 20 apples

    Form states 10 oranges and 5 apples collected

    Database will now show 20 oranges and 15 apples and I can get a signed collection docket via the submissions list

  • John Support Team Lead
    Replied on August 12, 2020 at 11:12 AM

    Hello @DoyleShipping - That would be possible. If you are using MySQL, you may refer to this guide on How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP.

    If you want to save the data to your database through Webhooks, you can use the sample script provided on this page Webhook-PHP-Script-Examples. Please see #3 in that guide.

    If you want to export your form's submission data to your database, you can also use this application — http://mysqldump.jotform.io/

  • John Support Team Lead
    Replied on August 12, 2020 at 11:12 AM

    Hello @DoyleShipping - That would be possible. If you are using MySQL, you may refer to this guide on How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP.

    If you want to save the data to your database through Webhooks, you can use the sample script provided on this page Webhook-PHP-Script-Examples. Please see #3 in that guide.

    If you want to export your form's submission data to your database, you can also use this application — http://mysqldump.jotform.io/