Convert MySQL to XML via PHP

Question

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?

Lots of solutions on the net - you need to format the xml yourself — Adrian Cornish
– Adrian Cornish, Commented Jan 10, 2012 at 2:54
possible duplicate with: stackoverflow.com/questions/2927193/… or stackoverflow.com/questions/1433267/… — insumity
– insumity, Commented Jan 10, 2012 at 2:55

slugonamission · Accepted Answer · 2012-01-10 02:55:45Z

4

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.

answered Jan 10, 2012 at 2:55

slugonamission

9,6741 gold badge36 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

leepowers · Accepted Answer · 2012-01-10 03:46:44Z

0

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");

answered Jan 10, 2012 at 3:46

leepowers

38.4k24 gold badges102 silver badges132 bronze badges

Comments

wcandillon · Accepted Answer · 2012-01-10 07:19:30Z

0

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

answered Jan 10, 2012 at 7:19

wcandillon

2,16621 silver badges19 bronze badges

Collectives™ on Stack Overflow

Convert MySQL to XML via PHP

3 Answers 3

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Linked

Related