Submissions and mysql database integration

  • Profile Image
    Jeremy
    Asked on April 03, 2011 at 08:25 PM

    Hi, 

    I am looking to use your software to set up a form for my client for now until the main website/database is set up for a social networking/business site. The form has to gather basic information to populate the site before it is fully launched, here is the basic template with the information fields to be created:

         Name:

         Username:

        Address:

        Skills:

        Interests:

        Invite your friends and colleagues (is this easily possible)

    I need to link the information to a mysql database as e-mail only is no good given tables will be required to then populate the website database when constructed, is it possible to recreate the PHP file that your software generates to point to a mysql database in the same way I would imagine I can adapt the CSS for styling the form? or is there another way using the e-mail link that is straight forward?
    Regards the submissions, I take it a submission is 1 persons details being entered and on the free version you only have 20 available...how can I have limitless submissions and how much would it cost as I am banking on quite high traffic volume and/or is this why your software doesn't seem to have the option to point to an external database?  
    Many thanks
  • Profile Image
    allanftd
    Answered on April 04, 2011 at 04:37 AM

    Hi Jeremy,

    Thank you for your inquiry. While there is no direct solution available at the moment, it is possible to indirectly integrate your JotForm form submissions into your Mysql database in a number of ways:

    A) Use the Send Form Post Data feature to add the data to your database indirectly. You will need to write some PHP (or other programming language) server side code to insert the data to your database. 

    B) Export your form submissions into an Excel/CSV File and import it into your database. For instructions on how to export submissions in JotForm, please click here.

    C) Purchase the JotForm Application License.  This way you can have complete control over your data.  You can also customize the source code according to your needs. 

    We hope you find this information useful. If you have any other questions or concerns , please let us know. Thank you for considering JotForm!

    JOTFORM SUPPORT

  • Profile Image
    khrisell
    Answered on July 04, 2013 at 11:55 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. :)