Transforming XML from Moneyexpert with XLST

dlw

17 posts

Hi,

I’ve been searching on here and various forums/search engines etc for a solution. I think it may be a tricky one. The output of this url is XML: http://webservices.moneyexpert.com/creditcard.asmx/Search?affiliateID=17&searchType=LowestIntroBalanceTransferRate&creditCardClass=Standard&currentBalance=2000&currentAPR=10&postcodeOutCode=SK7&postcodeInCode=3PH&pageSize=30&pageIndex=1

The parameters will change depending on the users selection but I think I can deal with that by checking the segment passed. The site was originally going to be done in ASP and MoneyExpert do provide the following code:

xmlURL = <a href="http://webservices.moneyexpert.com/creditcard.asmx/Search?affiliateID=17&searchType=LowestIntroBalanceTransferRate&creditCardClass=Standard&currentBalance=2000&currentAPR=10&postcodeOutCode=SK7&postcodeInCode=3PH&pageSize=30&pageIndex=1">http://webservices.moneyexpert.com/creditcard.asmx/Search?affiliateID=17&searchType=LowestIntroBalanceTransferRate&creditCardClass=Standard&currentBalance=2000&currentAPR=10&postcodeOutCode=SK7&postcodeInCode=3PH&pageSize=30&pageIndex=1</a>
        
        'XML http calls a URL and returns the text from that request (either xml for a web service or html for a webpage)
        set xml = Server.CreateObject("Microsoft.XMLHTTP")
        'populate the XmlHttp object with the xml returned from the webservice
        xml.Open "GET", xmlURL, False
        xml.Send
        
        response.write(xmlURL)
        
        strWebServiceReturnedXml = xml.responseText
        ' this will not render in a browser of course, look at it in the ViewSource to see the XML
        'Response.Write "xmlStart" & strWebServiceReturnedXml & "xmlEnd"
        
        'load the web service xml into an XmlDom
        set XMLdoc  = server.CreateObject("MSXML.DOMDocument")
        XMLdoc.loadXML strWebServiceReturnedXml
        
        'load a stylesheet from a file into an XmlDom
        set XSLTdoc = server.CreateObject("MSXML.DOMDocument")
        XSLTdoc.load server.MapPath("creditCard.xslt")
        
        'transform the XML using the XSLT, it returns a string
        strHtml = XMLdoc.transformNode(XSLTdoc)
        Response.Write  strHtml

Essentially I need to do the above but in PHP and being a newbie when it comes to both PHP and EE I am really struggling. EE has been great for the rest of it with various weblogs etc but this could be a stumbling block for me.

TIA,
Darren

<?php $xml = new DomDocument; $xml->load('http://webservices.moneyexpert.com/creditcard.asmx/Search?affiliateID=17&searchType=LowestIntroBalanceTransferRate&creditCardClass=Standard&currentBalance=2000&currentAPR=10&postcodeOutCode=SK7&postcodeInCode=3PH&pageSize=30&pageIndex=1'); $xsl = new DomDocument; $xsl->load('http://therichlady.com/creditCard.xslt'); $xslt = new XsltProcessor; $xslt->importStylesheet($xsl); $transformation = $xslt->transformToXml($xml); echo $transformation; } ?>

Thread

dlw

dlw

Username

Password

Thread