I've been trying to parse this xml document to loop the 'table' element for the last 2 hours, but it's not working ! I've tried this mainly as reference but it's not working simplexml_load_string returns blank array
here's my XML, how can I loop through the 'table' node ?
<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><GetMovieListResult xmlns="http://vista.co.nz/services/WSVistaWebClient.DataTypes/1/"><Result>OK</Result><DatasetXML><NewDataSet> <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true"> <xs:complexType> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:element name="Table"> <xs:complexType> <xs:sequence> <xs:element name="Cinema_strID" type="xs:string" minOccurs="0" /> <xs:element name="Movie_strID" type="xs:string" minOccurs="0" /> <xs:element name="Movie_strName" type="xs:string" minOccurs="0" /> <xs:element name="Movie_strRating" type="xs:string" minOccurs="0" /> <xs:element name="Movie_strName_2" type="xs:string" minOccurs="0" /> <xs:element name="Movie_strRating_2" type="xs:string" minOccurs="0" /> <xs:element name="Movie_HOFilmCode" type="xs:string" minOccurs="0" /> <xs:element name="Movie_intFCode" type="xs:int" minOccurs="0" /> <xs:element name="CinOperator_strCode" type="xs:int" minOccurs="0" /> <xs:element name="CinOperator_strName" type="xs:int" minOccurs="0" /> <xs:element name="Event_strCode" type="xs:string" minOccurs="0" /> <xs:element name="Event_strFilmsIndependent" type="xs:string" minOccurs="0" /> <xs:element name="MemberMovie" type="xs:string" minOccurs="0" /> <xs:element name="HOPK" type="xs:string" minOccurs="0" /> <xs:element name="Movie_intList_Pos" type="xs:int" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> </xs:element> </xs:schema> <Table> <Cinema_strID>0</Cinema_strID> <Movie_strID>0010000845</Movie_strID> <Movie_strName>BATMAN Vs SUPERMAN</Movie_strName> <Movie_strRating>PG13</Movie_strRating> <Movie_strName_2 /> <Movie_strRating_2 /> <Movie_HOFilmCode /> <Movie_intFCode>0</Movie_intFCode> <Event_strCode /> <MemberMovie>N</MemberMovie> <HOPK /> <Movie_intList_Pos>50</Movie_intList_Pos> </Table> <Table> <Cinema_strID>0</Cinema_strID> <Movie_strID>0010000846</Movie_strID> <Movie_strName>BATMAN Vs SUPERMAN VIP</Movie_strName> <Movie_strRating>PG13</Movie_strRating> <Movie_strName_2 /> <Movie_strRating_2 /> <Movie_HOFilmCode /> <Movie_intFCode>0</Movie_intFCode> <Event_strCode /> <MemberMovie>N</MemberMovie> <HOPK /> <Movie_intList_Pos>50</Movie_intList_Pos> </Table> </NewDataSet></DatasetXML></GetMovieListResult></soap:Body></soap:Envelope>
No comments:
Post a Comment