[SOLVED]Saving data as XML for Export
Posted: Tue May 25, 2004 1:25 am
Hi all,
i hope i post this in the right forum
so here's my question: i have to export a whole MySQL database with 9 relational connected tables and a total of about 22.000 rows to an PostgreSQL db - this does not sound like a big Prob, but 'the other side' does not want .sql, .txt, .csv or simple .xml files - they want the export files matching THEIR xml scheme.
So does anyone of you have experiences with pulling data from MySQL via PHP into an XML scheme?
I have a field in one of the nine db's which has the name 'accessType' and it can have the values shown above.
This is not a 'Hey Guys do my work and write my code' post - i just need an initial idea to do this.
Greez and TiA,
- bluenote
i hope i post this in the right forum
So does anyone of you have experiences with pulling data from MySQL via PHP into an XML scheme?
Code: Select all
- <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" attributeFormDefault="unqualified">
- <xs:simpleType name="accessType">
- <xs:restriction base="xs:string">
<xs:enumeration value="intern" />
<xs:enumeration value="public" />
<xs:enumeration value="user" />
</xs:restriction>
</xs:simpleType>This is not a 'Hey Guys do my work and write my code' post - i just need an initial idea to do this.
Greez and TiA,
- bluenote