InfoPath with MySQL and PHP

[Matt Bowden (MCP)]

I have an HTML form which submits it's contents to a php script which inserts
data into a MySQL database. I'd like to replace this HTML form with an
InfoPath form. I've tried to use the "Submit through HTTP" feature in
InfoPath but I had bad luck in that it sent data to my script for each field
one-by-one.

Does anyone know how to make InfoPath work with PHP or MySQL. Better yet,
can someone explain how InfoPath sends data when using the "Submit through
HTTP" feature? Any details on this would be really helpful.

 

[G. Tarazi]

I haven't worked with PHP since long time, but here is an idea.



To save (submit) a form to a PHP web site, try to build a web service first
(it is very easy to submit the form to a web service), I am not sure if
there are web services in PHP, but if there is, you just need PHP a page to
act like a web service.



The InfoPath will send the entire form as XML, now in your PHP code, you
must load the received xml (which is probably a string) to an xml document,
and extract the fields you want to extract, and then store them in my sql.



To retrieve the form back, have a link on your web site, when clicked, it
will open the my sql database, retrieve the fields, and print them as text
with the xml tags required by the InfoPath schema.



InfoPath will open automatable from IE if the mimi type is xml, even if the
page itself is PHP



The idea is simple and we are using it in all of our projects (but we are
using IIS and SQL server instead) it's only problem is the amount of code
that needs to be written.