How can I submit form results to my own database table for use in other parts of my site?

  • Profile Image
    grayceworks
    Asked on February 06, 2011 at 05:06 AM

    I am creating a site where I need a complex form with conditional formatting such as what I've designed here, however, when the form is submitted, I need a way to store those values in a separate database, in order to access and display the results using a query.

     

    I also need to be able to autofill a couple of the form fields based on info already in my site's database for the logged in user.

    Willing to pay for the extra support and/or upgrade membership as needed.

    Any hints or ideas? Thanks!

  • Profile Image
    aytekin
    Answered on February 07, 2011 at 04:03 AM

    You can accomplish that using Send Post Data feature. It will post the POST data to your Thank You page. You can enable it from Preferences button on the toolbar. 

  • Profile Image
    grayceworks
    Answered on February 07, 2011 at 04:06 AM

    Ok, I understand that will put the submitted info on the thankyou page, but from there, how does it get to my database? I don't see where I can enter code to insert into my mysql database?

     

    I also need to be able to insert code somewhere to retrieve existing info from my database and fill certain form values with it.

     

  • Profile Image
    aytekin
    Answered on February 07, 2011 at 09:31 AM

    If you make your Thank You page a PHP page, you can connect to Mysql from PHP and insert the data into one of your tables. 

  • Profile Image
    grayceworks
    Answered on February 07, 2011 at 10:16 AM

    Can I use standard Joomla variables to do this? Or do I need to manually include all the database connection info?

  • Profile Image
    aytekin
    Answered on February 07, 2011 at 10:18 AM

    JotForm will send the variables using HTTP POST. After that it is up to you. I don't know about Joomla variables, so I cannot say anything. You should probably hire a programmer. 

  • Profile Image
    khrisell
    Answered on July 04, 2013 at 11:08 PM
    Greetings!

    We are happy to announce that we have released Jotform Webhooks,  this feature would replace Send Post Data + Custom URL Thank You Page workaround in order to help you transfer forms data to your own database using your own script codes.

    To know more about Jotform Webhooks, please click here.

     

    Thank you for using JotForm. :)