Parsing XML namespace with PHP

Question

I've been beating my head against the wall trying to parse out the items below under the first xs:sequence (starting with AssetID):

<Response> <xs:schema id="Response" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xs:element name="Response" msdata:IsDataSet="true" msdata:UseCurrentLocale="true"> <xs:complexType> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:element name="Server"> <xs:complexType> <xs:sequence> <xs:element name="AssetID" type="xs:int" minOccurs="0" /> <xs:element name="Asset_x0020_Number" type="xs:int" minOccurs="0" /> <xs:element name="Asset_x0020_Name" type="xs:string" minOccurs="0" /> <xs:element name="Tag" type="xs:string" minOccurs="0" /> <xs:element name="Server_x0020_Material" type="xs:string" minOccurs="0" /> <xs:element name="Cabinet_x0020_Name" type="xs:string" minOccurs="0" /> <xs:element name="Server_x0020_Project_x0020_Purpose" type="xs:string" minOccurs="0" /> <xs:element name="Tranche_x0020_Number" type="xs:int" minOccurs="0" /> <xs:element name="Strategy" type="xs:string" minOccurs="0" /> <xs:element name="Total_x0020_System_x0020_U_x0020_Height" type="xs:int" minOccurs="0" /> <xs:element name="Cabinet_x0020_U_x0020_Number" type="xs:int" minOccurs="0" /> <xs:element name="Mounting_x0020_Direction" type="xs:string" minOccurs="0" /> <xs:element name="Serial_x0020_Number" type="xs:string" minOccurs="0" /> <xs:element name="Purchase_x0020_Price" type="xs:decimal" minOccurs="0" /> <xs:element name="Location_x0020_Group" type="xs:string" minOccurs="0" /> <xs:element name="Row" type="xs:string" minOccurs="0" /> <xs:element name="Column" type="xs:string" minOccurs="0" /> <xs:element name="Rotation" type="xs:int" minOccurs="0" /> <xs:element name="AssetOperationalStatus" type="xs:string" minOccurs="0" /> <xs:element name="Discovered" type="xs:boolean" minOccurs="0" /> <xs:element name="Power_x0020_State" type="xs:string" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="Strategy"> <xs:complexType> [...continues on...]

I've been trying this using PHP's SimpleXMLElement, but I can't figure out how to isolate just those 20 lines. All I need is an array of the names of the elements, e.g.:

{"AssetID", "Asset_x0020_Number","Asset_x0020_Tag","Tag", ... ,"Power_x0020_State"}

David Mongeau-Petitpas · Accepted Answer · 2012-06-07 02:04:16Z

Here is an example for displaying "name" attributes of every xs:element

$xml = simplexml_load_string($xmlString); $namespaces = $xml->getNameSpaces(true); $xs = $xml->children($namespaces['xs']); foreach($xs->schema->element->complexType->choice->element->complexType->sequence->element as $element) { echo $element->attributes()->name.PHP_EOL; }

Awesome! Thanks, Mongo. XML seems more difficult than it has to be, but this helps a lot to see the structure.

Collectives™ on Stack Overflow

Parsing XML namespace with PHP

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related