- Waddys1Asked on June 16, 2013 at 07:31 PM
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?
- JotForm SupportjonathanAnswered on June 16, 2013 at 07:34 PM
Pleaes review this guide How-to-Insert-Update-Submissions-to-Your-MySQL-Database-Using-PHP
Inform us if you have further question.
- JotForm SupportjonathanAnswered on June 16, 2013 at 07:53 PM
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
- Waddys1Answered on June 16, 2013 at 07:57 PM
Thank you JonathanI 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 :-)CheersWaddy
- JotForm SupportWelvinAnswered on June 17, 2013 at 12:43 AM
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.
- Waddys1Answered on June 17, 2013 at 01:20 AM
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 :-)
- sidharth_kchAnswered on June 17, 2013 at 01:44 AM
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?
- Waddys1Answered 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.
- sidharth_kchAnswered on June 17, 2013 at 03:48 AM
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".
You should have $db_host = 'db hostname here'; as $db_host = 'localhost';
Hope this helps. Let us know if you need further assistance.
- Waddys1Answered on June 17, 2013 at 07:22 PM
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?
- sidharth_kchAnswered on June 18, 2013 at 12:06 AM
I don't think using postgresql in your own custom page should be an issue.
- jeanettebmzAnswered 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