XML creation

[jito]

Hi,
how can i create xml files from mysql database. Currently i'm doing that with simple file handling in php. but i believe there is a better way to do that. May be xml writer, but have never used that.
I am using php 5 and tried dom methods like domxml_new_doc,add_root etc. but those methods are not working may becoz of the version of php.

[Jeanco]

I haven't had a chance to try it yet, but maybe the PEAR XML extension would have some useful functions?

http://pear.php.net/packages.php?catpid=22&catname=XML

[jito]

any other option than PEAR? any class already developed for that?

[Cups]

Mysql dump has an xml export option, dont know if thats of interest to you.
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

Heres how to use it:
http://lists.evolt.org/archive/Week-...11/127859.html

[ruba]

Hi Cups ,
what I c that it dump all table is there anyway to dump a query ??

I use this
http://www.tonymarston.net/php-mysql/dom.html

but I have problem in UTF-8,
I want to use UTF-8 I want to use windows-1256

so I save the file in uft-8 by modify it using iconv , then change it when read the xml..

[Cups]

TBH, I dont know - I have never tried it - one of those things that stuck in my head, not sure if I'd ever use it.

Not in a position to try it at the moment.

[jito]

Thnx Cups, i will try that for sure but for now i have done my job with PHP 5 s DOM object.

A good tutorial for XML creation here.