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.
I haven't had a chance to try it yet, but maybe the PEAR XML extension would have some useful functions?
any other option than PEAR? any class already developed for that?
Hi Cups ,
what I c that it dump all table is there anyway to dump a query ??
I use this
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..
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.
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.