mlambert13 Posted January 6, 2006 Share Posted January 6, 2006 I am trying to do something, but not quite sure I do it with MySQL or PHP. Basically, I want to collect some information from a visitor through a webpage, enter it into MySQL, and then provide them a Thank You page. I then want to take some of that data, and pass it via SOAP or XML to a partner using PHP or something, and then parse their XML response and enter the data in another table. Not sure if this can be done. I know MySQL 5 has stored procedures, however, I'm only on 3.23.58. Any way to do this, or should I upgrade? Quote Link to comment Share on other sites More sharing options...
fenway Posted January 6, 2006 Share Posted January 6, 2006 First, you should definitely upgrade, at least to 4.1 -- 3.23.x is quite old, and lacks many features. Second, I don't see what the problem is. You don't need to dump the raw XML into a table temporarily (though you could for archival reasons); simply send it off to be parsed, and enter whatever name/value pairs directly into your MySQL tables. Did I miss something? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.