1
hi i want get data from database and change it to xml
for example properties of one paper
i want get name,lastname,title,....
and change it to xml like this
what must i do??????????/
<?xml version="1.0" encoding="UTF-8"?>
<records>
<record>
<language>eng</language>
<publisher>Popular Chemistry</publisher>
<journalTitle>Botanical Magazine</journalTitle>
<issn>17497221</issn>
<publicationDate>2002-09-04</publicationDate>
<volume>98</volume>
<issue>2</issue>
<startPage>1234</startPage>
<endPage>1235</endPage>
<doi>1234567</doi>
<publisherRecordId>12345</publisherRecordId>
<documentType>article</documentType>
<title language="eng">Roses and Lilies</title>
<title language="ger">Roses und Lilies</title>
<authors>
<author>
<name>Fritz Haber </name>
<email>fritz.haber@some.university.org</email>
<affiliationId>1</affiliationId>
<affiliationId>2</affiliationId>
<affiliationId>3</affiliationId>
</author>
</authors>
<affiliationsList>
<affiliationName affiliationId="1">
University of A
</affiliationName>
<affiliationName affiliationId="2">
Universitaty of B
</affiliationName>
<affiliationName affiliationId="3">
University of C
</affiliationName>
</affiliationsList>
<= The language tag content must conform to the
iso 639-2b standard.
<= Here is the issn number of the journal in which
the article has been published. If you have an eissn
number instead then this line should be replaced by
<eissn>17497221</eissn>. If you have both issn
and eissn numbers then the eissn tag should occur
after the issn tag.
<= If the title occurs in more than one language
then you may list the titles here. The title tag
has got the attribute language that must be set
according to the ISO638.2 standard.
<= Note that the affilitationId numbers denote the
affilitations in the affiliationslist below.
<abstract language="eng">
The catalytic formation of ammonia from hydrogen
and atmospheric nitrogen under conditions of high
temperature and high pressure.
</abstract>
<fullTextUrl format="pdf">
http://www.science.org/articles/HaberBosch.pdf
</fullTextUrl>
<keywords language="eng">
<keyword>garden</keyword>
<keyword>rose</keyword>
</keywords>
</record>
<record>
...
</record>
...
</records>