XML from PHP, how to apply the XSL
XML from PHP, how to apply the XSL
(OP)
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;
?>
<?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
RE: XML from PHP, how to apply the XSL
Tom Morrison
Micro Focus
RE: XML from PHP, how to apply the XSL
James Flowers
Crystal Consultant
RE: XML from PHP, how to apply the XSL
this link should give you all you need:
http://devzone.zend.com/179/using-php-and-xsl-to-t...
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.
RE: XML from PHP, how to apply the XSL
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