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

  • Profile Image
    Waddys1
    Asked 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
    jonathan
    Answered 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
    jonathan
    Answered 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
    Waddys1
    Answered 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
    Welvin
    Answered 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
    Waddys1
    Answered 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
    sidharth_kch
    Answered 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
    Waddys1
    Answered 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
    sidharth_kch
    Answered 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
    Waddys1
    Answered 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
    sidharth_kch
    Answered 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
    jeanettebmz
    Answered 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!