RSS, Web Services and...

Displayind data in XML file using HTML

Please support our RSS, Web Services and SOAP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jun 2005

Posts: 8

Reputation: Gody is an unknown quantity at this point

Solved Threads: 0

Gody

Offline

Newbie Poster

Displayind data in XML file using HTML

May 8th, 2006

Hi everybody,

I have a XML file having data stored in tags as

<Username>User name here</Username>
<Password>Password here</Username>

(There will be data of around 100 users)

I need to display this data in a HTML file in a tabular format.
Kindly help me.

•

Join Date: Jun 2006

Posts: 3

Reputation: g8trGTO is an unknown quantity at this point

Solved Threads: 0

g8trGTO

Offline

Newbie Poster

Re: Displayind data in XML file using HTML

Jun 6th, 2006

Try creating an XSLT (XML style) file and most browsers will properly render the XM. There are lots of tutorials on the web on this. Hope that helps.

•

Join Date: May 2006

Posts: 6

Reputation: bwhiti is an unknown quantity at this point

Solved Threads: 1

bwhiti

Offline

Newbie Poster

Re: Displayind data in XML file using HTML

Jun 9th, 2006

If you know javascript you could use Ajax. This will give you the ability of updating just those fields with out having to call the whole page if you wish.

•

Join Date: Jun 2006

Posts: 2

Reputation: inkrajesh is an unknown quantity at this point

Solved Threads: 0

inkrajesh

Offline

Newbie Poster

Re: Displayind data in XML file using HTML

Jun 13th, 2006

Hi Gody,

You can use XSLT to format the pages like the way you want

Refer to http://www.w3schools.com/xsl/default.asp and find the formatting.

Remember to include the reference to your XSLT file you created in the xml

The sample xslt file will be like this...........

<?xmlversion="1.0"encoding="iso-8859-1"?>
<xsl:stylesheetversion="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:templatematch="/">
<html>
<body>
<h2>My page</h2>
<tableborder="1">
<trbgcolor="#9acd32">
<th>Date</th>
<th>Purpose</th>
</tr>
<xsl:for-eachselect="SalesVisit/Details">

<tr>
<td>
<xsl:value-ofselect="Date"/>
</td>
<td>
<xsl:value-ofselect="Purpose"/>
</td>
</tr>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>

MY Raw xml file before formatting was like this...

<?xmlversion="1.0"encoding="UTF-8"?>
<?xml-stylesheettype="text/xsl" href="XSLTFile.xsl"?>
<SalesVisit>
<Details>
<Date>1/1/2006</Date>
<Purpose>Sales Visist 1</Purpose>
</Details>
<Details>
<Date>2/1/2006</Date>
<Purpose>Sales Visist 2</Purpose>
</Details>
<Details>
<Date>3/1/2006</Date>
<Purpose>Sales Visist 3</Purpose>
</Details>
<Details>
<Date>4/1/2006</Date>
<Purpose>Sales Visist 4</Purpose>
</Details>
</SalesVisit>

by Rajesh C Medackel, TVM, India

Last edited by inkrajesh; Jun 13th, 2006 at 3:54 am.