- barryblizzardAsked on February 15, 2017 at 10:27 AM
Is it possible to read the submission data directly from the database instead of having to export to CSV first.
I would like to read it via Mysql or using php etc.
- JotForm SupportJanAnswered on February 15, 2017 at 12:30 PM
My understanding is that you want to connect the form to your MySQL database.
It is possible to send the form submission to your own MySQL database using PHP. However, you will need to create a script that will serve as the landing page for the receiving post data. That script will insert the submitted post data to your MySQL database. Please refer to this guide: https://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP.
You might also want to check JotForm Webhooks. Here's the link: https://www.jotform.com/help/245-How-to-Setup-a-Webhook-with-JotForm.
You can find an example in this guide: https://www.jotform.com/help/248-Webhook-PHP-Script-Examples, please check the number 3 example.
We also have an app called MySQL Export. This will allow you to export the data and import using phpMyAdmin.
Hope that helps. Thank you.
- barryblizzardAnswered on February 15, 2017 at 02:46 PMThat looks useable but when does it run th ecode. I have a thank you script and the submit goes to paypal. Will this run when submit is clicked ?
Barry Brown CITP; MBCS; APM; Bsc Econ,
GURU Consultancy Limited,
M : 07903 804715
- JotForm SupportJanAnswered on February 15, 2017 at 04:23 PM
After the payment was made, the user should be redirected to the Thank You page. Please do try it and let us know if you encounter any errors. Thank you.