CODEWITHSUNDEEP
phpmysqlxml
Peter Kazazes
Peter Kazazes

Reputation: 3628

Convert MySQL to XML via PHP

I have a MySQL database on my server and I'd like a certain table to be returned via PHP as XML. I've seen various ways to get XML to MySQL, but not an easy to follow way of the opposite. How should I go about doing so?

Upvotes: 0

Views: 1471

Answers (3)

wcandillon
wcandillon

Reputation: 2176

You should consider the XQuery PHP extension to customize your XML output from Mysql: http://www.zorba-xquery.com/site2/html/php.html

Upvotes: 0

leepowers
leepowers

Reputation: 38318

Seconding using XMLWriter or DOM to generate XML in PHP. An alternate approach would be to use the mysql command, which will write out simple XML structures. Something like this:

header("Content-type: application/xml");
passthru('mysql mydatabase --xml -umysqluser -pmysqlpassword -e "SELECT * FROM mytable");

Upvotes: 0

slugonamission
slugonamission

Reputation: 9642

Just pull the data out and manually form it into an XML document (using the DOM or XMLWriter classes), there's no built in way to just do it. If you're looking for a pre-built solution though, PHPMyAdmin has functionality to dump a table to an XML document.

Upvotes: 4

Related Questions