[RESOLVED] Need an example for creating an XML file

rtcary

I am new to creating an XML file that contains data produced by a DB query and would like to be pointed to some examples. The XML file is to be downloaded by the user and used to update their DB.

The number of fields is less than twelve with less than 100 records.

Many thanks...

Todd

coldwerturkey

google.com/search?q=mysql+to+xml

php.net/xml

rtcary

I appreciate the reference to exporting MySQL (for this application I am using SQL Server). What strikes me is that there is no single format holding the data.

Do you know of any references to "acceptable" formats? The

is certainly simple, however is it readable by most XML parsers?

Todd

Weedpacket

rtcary wrote:
What strikes me is that there is no single format holding the data.

That's because it depends on what the data is to be used for and the functionality and semantics that the resulting file is supposed to reflect (see here for part of a typical discussion): XML is not just a "database export format" 🙂

rtcary wrote:
is certainly simple, however is it readable by most XML parsers?

That specific example is not: XML documents need a root element; though I expect SQL Server's XML export mechanism would ensure well-formedness.

rtcary

Thank you for the excellent reference. You mentioned the need for a "root element"

Does this meet that requirement?

<table name"Members">
<row>
<field fieldname="MemberID">100083</field>
<field fieldname="Title">OWNER</field>
<field fieldname="FirstName">ROBERT</field>
<field fieldname="MiddleName">TODD</field>
<field fieldname="LastName">CARY</field>
</row>
<row>
<field fieldname="MemberID">100084</field>
<field fieldname="Title">OWNER</field>
<field fieldname="FirstName">GEORGE</field>
<field fieldname="MiddleName"></field>
<field fieldname="LastName">SMITH</field>
</row>
<row>
<field fieldname="MemberID">100085</field>
<field fieldname="Title">OWNER</field>
<field fieldname="FirstName">NEW</field>
<field fieldname="MiddleName"></field>
<field fieldname="LastName">MEMBER</field>
</row>
</table>

Weedpacket

Typo aside I'd be happy with it. Personally I'd make the primary key an attribute of the row element, but that's just me being perhaps too clever for my own good - like I said, it depends on what you're going to do with it.