Convert MySql database records to XML in PHP

Question

My PHP script is calling MySQL and getting bunch of records. Is there a function/library in PHP that converts SQL database records into XML? Something like myDBRecords.ToXML()

Glen Solsberry · Accepted Answer · 2012-05-11 10:46:50Z

1

You probably want something like XML_Serializer. It will take just about any PHP data structure and return you some XML.

answered May 11, 2012 at 10:46

Glen Solsberry

12.4k16 gold badges74 silver badges96 bronze badges

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

Comments

Yago Riveiro · Accepted Answer · 2012-05-10 16:27:11Z

0

The command line allows to do

shell> mysql --xml -uroot -e "SHOW VARIABLES LIKE 'version%'"

I don't know if is possible replicate this behavior on SELECT statement

More information in:

http://dev.mysql.com/doc/refman/5.0/en/mysql-command-options.html#option_mysql_xml

Other way to do is using a custom class, an example:

http://px.sklar.com/code.html/id=229

edited May 10, 2012 at 16:27

answered May 10, 2012 at 16:20

Yago Riveiro

72713 silver badges28 bronze badges

Collectives™ on Stack Overflow

Convert MySql database records to XML in PHP

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related