Output MySQL-Table into XML-File

[Anon]

Hi!

I am quite new to XML and I wonder if it is so easy to generate an XML-File as I think..

Just open xml-tag <name>victor lazlo</name> and close it... but what if I have a field with linefeeds? Are there any problems?

And are there any php-scripts, which export a mysql-db into an xml-file?

Thanx!

[Anon]

Line feeds are of no problem for the XML parser.

You can make one XML script pretty fast.

If you want to export th MySQL to a XML fil you shall make the following

<database name>
<table1>
<row>
<field name>
DATA
</field name>
.
.
.
</row>
</table 1>

</database name>

All the neccessary function are already found under the MySQL functions, and you can use them to fetch the table names and table fields and field types, and anything that you need.

And then you put everything together in a loop and run then and write the result to a file. It will probably take a few hours and you're done.

sincerely
//babak