XML from PHP, how to apply the XSL

[JamesFlowers]

I have the code as below , but I cant work out how to apply the XSL file for formatting? Any ideas, Thanks.

<?php header("Content-Type: text/xml"); //set the content type to xml?>
<?php include 'dbconn.php'; // database Conn?>
<?php include 'sql.php'; // SQL?>
<?php
$xmlBody = '<?xml version="1.0" encoding="ISO-8859-1"?>';
$xmlBody .= "<XML>";
while($row = mysql_fetch_array($sql)){
$country = $row["country"];
$xmlBody .= '
<Customers>
<Country>'.$country.'</Country>
</Customers>';
}
mysql_close();
$xmlBody .= "</XML>";
echo $xmlBody;
?>

James Flowers
Crystal Consultant

 

[k5tm]

I would start with the manual:

http://php.net/manual/en/book.xsl.php

Tom Morrison
Micro Focus

 

[JamesFlowers]

The php.net pages are more about using XML as a datasource not an output.

James Flowers
Crystal Consultant

 

[MakeItSo]

Hi James,

this link should give you all you need:

http://devzone.zend.com/179/using-php-and-xsl-to-transform-xml-into-web-content/#Heading14

Regards,
MakeItSo

“Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family.” (Kofi Annan)
Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever name whatsoever.

 

[k5tm]

The php.net pages are more about using XML as a datasource not an output.

Perhaps you could provide a specification a little less vague. For example, do you want to apply the transform on the server, or on the client? What do you expect the result to look like? Better problem statement might provide better advice...

Tom Morrison
Micro Focus