- demo4905Asked on April 21, 2013 at 12:37 PM
I've been reading through the posts but haven't seen this answer....
Is it possible to post my form answers to my Wordpress database? Since I have access to my back end and server, I can follow this guide: "How to Insert/Update Submissions to Your MySQL Database Using PHP".
But, if it's possible...the Google Spreadsheet option was really the easiest way to do it, as it creates all the colums for you. Is it possible to use the spreadsheet in place of the MySql databse?
But, ultimately...I want to display my form answers as Wordpress posts.
I've been trying everything and thought I was onto something with sending my form data to a Google spreadsheet then I tried to display the Google spreadsheet rows as individual posts but I got stuck here because the plugin ("Magn WP Sync") I was using was outdated.
I don't want to use a report, because I need my user to have the ability to go back and EDIT the form. So, I have to find a way to do this also.
But, I think I was pretty close...can anyone offer an idea or suggestion?
- JotForm SupportjonathanAnswered on April 21, 2013 at 04:47 PM
How about the technique describe here.
Since you can already insert/update your MySQL database with JotForm's submissions, then, you can apply the wp_insert post function describe in the WP codex page.
Hope this help. Inform us if you have further inquiry.
- JotForm SupportjonathanAnswered on April 21, 2013 at 04:53 PM
Btw, you might be confuse... BUT in order for WP to have "Posts", the data should be inserted in the WP database (which is MySQL also)
I am not 100% sure as I have not tried yet, BUT I think if you can just transfer the JotForm MySQL data to your WP MySQL database.. then, the inserted data will appear as post in your WP page.
An almost similar coding discussion I found here. It should help.
- demo4905Answered on April 21, 2013 at 05:11 PMOk, well....I'm liking this idea, just confused bc of how the question is not resolved on the stack overflow page. Do I need to create a 2nd database? Or can I use the same one that my WP uses? If so, do I just add to it? I realize that may sound really friggin blonde, but I'm just not that familiar with the whole process / backend. Kinda learning as I go....If I understand correctly, should I 1. Make test.php page 2. Get my Array 3. Add to WP database 4. Insert answers into postsDoes that sound right? Thanks for the help....
- JotForm SupportjonathanAnswered on April 21, 2013 at 05:28 PM
It actually uses the existing WP database. Because all the "posts" in your WP page are recorded to the WP database. You will just add entry to the WP database.
As you already mentioned: (Yes, this is right)
1. Make test.php page
2. Get my Array
3. Add to WP database
4. Insert answers into posts (this part is automatic I think, You do not have to insert to your post in WP because the post you inserted in the database will be displayed in your WP post-- perhaps a field with true or false value triggers if the post should be display or not)
- jeanettebmzAnswered on July 03, 2013 at 10:30 PM
You might like to know that our 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 your own script codes
Please find out more about it here