Jump to content


Photo

Need to send and receive XML from MySQL


  • Please log in to reply
1 reply to this topic

#1 mlambert13

mlambert13
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 06 January 2006 - 07:52 AM

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?

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 06 January 2006 - 06:37 PM

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?
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users