Can someone Help me please - Post ID 869

User 438377 Photo


Registered User
5 posts

I am trying to get form data from a PDF form inserted into a Mysql database table. Is there anyone that knows how this can be accomplished. It can't be that hard to do.

Sample scripts would be nice i am new to all this but the pdf form has 42 field that go into one table on a database.
User 37670 Photo


Registered User
2,138 posts

I notice you have not had any response. Maybe this is not an easy thing to accomplish.
Can you provide us with a link to an example PDF file?

Maybe if we see what you are working with, someone might have an idea what it will take to get it done. I also don't believe that CoffeeCup has a software that will convert the PDF output to Mysql, but they do have a form builder software that has the ability to save the data to a Mysql database. I would suggest giving the free "trial" software a shot. I think it gives you a couple of weeks to try it out before paying for it.
You could try making the form fields in Form Builder and see if you can get it to load to your Mysql database to replace the PDF file. Might be worth a shot.
E-Learning Specialist
www.mainsites.ca is my website, and yes, some of it is crappy.
User 438377 Photo


Registered User
5 posts

Thanks for the reply And i did purchase coffee cup form builder as of yet i have not been able to make that work. It is only for html forms and as i stated previously it doesnt post html forms to mysql either. it says i have no permission to input data into mysql table when in fact i do. it creates the form_fields_old but does not create the new table and enter data. PDF deos not send the actual PDF document. When you send a PDF form through email it creates an xml document with only the field information, author of the pdf file can then repopulate the form with the data submitted. Same with mysql i can import the data manually using a mysql gui ( navicat for mysql) and populate table with form data that way. I need a php script that will connect to the database and strip the form fields and insert them into the table. I know it is possible I jsut hadnt found the right script yet. PDF as a default transmits data with the fdf format. there has to be a way to do this

Thanks again for the reply
User 103173 Photo


VP of Software Development
0 posts

On Jan 14th we responded to your support ticket QGE-685755 asking for more information but we never got a reply so the ticket was closed. If you can reply with the answer to our questions, someone can look into this more.
Learn the essentials with these quick tips for Responsive Site Designer, Responsive Email Designer, Foundation Framer, and the new Bootstrap Builder. You'll be making awesome, code-free responsive websites and newsletters like a boss.
User 438377 Photo


Registered User
5 posts

you asked me for sensitive information that i do not feel comfortable giving out.
User 133269 Photo


Registered User
2,900 posts

robert@rs-sunconst.com wrote:
...When you send a PDF form through email it creates an xml document with only the field information...

Hi Robert
There's your answer i think - look for a script to grab data from the xml file to the db... ;)
Have fun
~ Fe Pixie ~
User 438377 Photo


Registered User
5 posts

Thanks Pixie but only through email does it convert to xml if i am not mistaken the actual form data itself within the PDF doc is FDF and i had looked for a script that will do that thanks for your reply though :)

This has been a big challenge but a fun one :)
User 438377 Photo


Registered User
5 posts

However if this helps I found a script to do an http post dump of the pdf form and that part works

Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.