What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    how can I take the data from Form and put it into a database?

    Asked by Waddys1 on June 16, 2013 at 07:31 PM

    Hi

    We are looking to be able to clooect a lot of data (some in text from) using Forms but we would also like to be able to have that data in a data base so we can work with it in a variety of ways.  Is this possible?

    Regards

    Waddy

  • Profile Image
    JotForm Support

    Answered by jonathan on June 16, 2013 at 07:34 PM

    Hi Waddy,

    Pleaes review this guide How-to-Insert-Update-Submissions-to-Your-MySQL-Database-Using-PHP 

    Inform us if you have further question.

    Thanks.

  • Profile Image
    JotForm Support

    Answered by jonathan on June 16, 2013 at 07:53 PM

    Hi,

    If you responded to this thread, I'd like to inform you that your latest message was empty.

    Please try again using the this link http://www.jotform.com/answers/230129-how-can-I-take-the-data-from-Form-and-put-it-into-a-database#2 to reply

     

    Thanks.

  • Profile Image

    Answered by Waddys1 on June 16, 2013 at 07:57 PM

    Thank you Jonathan

    I am an absolute novice at all of this so some of the language you are using makes about as much sense as Klingon to me :-)
    Let me see if I am close.
    First is to get a piece of Database Software which uses MySQL and then somehow get the code you have pointed me into somewhere on the form which will send the data to my database rather than and email to me an into DropBox?  As far as I am aware I have not told it to send to a custom URL Page ? so i am not sure what is meant here.
    Am I close here?  Sorry to be a pest but if I can get to understand it your software must be great :-)
    Cheers
    Waddy
  • Profile Image
    JotForm Support

    Answered by Welvin on June 17, 2013 at 12:43 AM

    Hi Waddy,

    You have to first Enable the "Send Post Data" and create your Custom Thank URL in PHP Format because this method is your first step to forward your form submissions to your MySQL Database. I suggest you to apply every first step from the guide to test it out. 

    Let us know what form in your account that you'd like this to have, and we'll try our best to come up with those steps that can be done on our side.

     

    Thanks

  • Profile Image

    Answered by Waddys1 on June 17, 2013 at 01:20 AM

    Hi Welvin

    I have spent the day going around in circles.  My webhost does not allow acess to the data on MySQL on their system.  MySQL does not want to run on my desk top OSX 10.8 and I have no idea what to do next so any hints would be most welcome :-)

    Cheers

    Waddy

  • Profile Image

    Answered by sidharth_kch on June 17, 2013 at 01:44 AM

    @Waddys1

    You need to speak to your hosting provider and there should be some option to get the access to your MySQL server. 

    BTW who is your hosting provider?

    Thanks,

    Sidharth

  • Profile Image

    Answered by Waddys1 on June 17, 2013 at 03:40 AM

    Hi Sidharth.  I did an theywere the ones who told me I could not get remote access .....  iPage is the host but I would not like to bet on how much longer if a simple function like that is unavailable.

    Cheers

    Waddy

  • Profile Image

    Answered by sidharth_kch on June 17, 2013 at 03:48 AM

    @Waddys1

    Well I don't think you will need a remote access to your DB. The custom URL page will be in your own domain/website. You should be able to connect to your MySQL DB as "localhost".

    Reference: http://www.jotform.com/help/126-How-to-Insert-Update-Submissions-to-Your-MySQL-Database-Using-PHP

    You should have $db_host = 'db hostname here'; as $db_host = 'localhost';

    Hope this helps. Let us know if you need further assistance.

    Thanks,

    Sidharth

  • Profile Image

    Answered by Waddys1 on June 17, 2013 at 07:22 PM

    Hi Sidharth

    Would any SQL database do.  MySQL does not want to work on a O SX 10.8 which is why I was trying the other option. I am installing postgre SQL as an option?

    Cheers

    Waddy

  • Profile Image

    Answered by sidharth_kch on June 18, 2013 at 12:06 AM

    @Waddys1

    I don't think using postgresql in your own custom page should be an issue. 

    Thanks,

    Sidharth

  • Profile Image

    Answered by jeanettebmz on July 03, 2013 at 08:42 PM

    We are very proud to announce that our amazing team of developers 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 a script code

    Please find out more about it here

    Cheers!