Parsing complex XML in PHP5

Question

Hello this is my first post. i'm trying to parse an xml using php, but i'm stuck with it

example of my xml :

<xml xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
     xmlns:rs='urn:schemas-microsoft-com:rowset'
     xmlns:z='#RowsetSchema'>
<s:Schema id='RowsetSchema'>
   <s:ElementType name='row' content='eltOnly' rs:CommandTimeout='30'>
      <s:AttributeType name='ows_LinkTitle' rs:name='Phone Number*' rs:number='1'>
         <s:datatype dt:type='string' dt:maxLength='512' />
      </s:AttributeType>
      <s:AttributeType name='ows_GSM_x0020_PUK' rs:name='GSM PUK' rs:number='2'>
         <s:datatype dt:type='string' dt:maxLength='512' />
      </s:AttributeType>
   </s:ElementType>
</s:Schema>
<rs:data>
   <z:row ows_LinkTitle='628558621183' ows_GSM_x0020_PUK='41016732'/>
   <z:row ows_LinkTitle='628558621181' ows_GSM_x0020_PUK='21783670'/>
</rs:data>
</xml>

i'm trying to get the value from each of 'z:row' Any help is very appreciated. Thanks

i'm trying this code and it doesnt work

$xml_all = simplexml_load_string($xmlnya);

echo '<ol>';
foreach ($xml_all->xml->rs->z as $zrow)
{
 echo '<li> ows_LinkTitle: '.$zrow['ows_LinkTitle'];
 echo '</li>';
}
echo '</ol>';

Your XML is malformed (missing s namespace declaration, missing s:ElementType closing tag . Please fix that before trying to "parse" it. — salathe
– salathe, Commented Sep 28, 2011 at 8:39
(reference) php.net/manual/en/domdocument.getelementsbytagnamens.php — Gordon
– Gordon, Commented Sep 28, 2011 at 8:39
You could try to use simplexml. The problem is that your xml string is far from being valid (no "s" namespace, a "<s:ElementType>" not closed). — Arkh
– Arkh, Commented Sep 28, 2011 at 8:40
possible duplicate of stackoverflow.com/search?q=registerXPathNamespace — Gordon
– Gordon, Commented Sep 28, 2011 at 8:48
@naboen: if/when you fix the XML, are you looking to use any particular library in PHP? DOM, SimpleXML, XMLReader, other? — salathe
– salathe, Commented Sep 28, 2011 at 8:50

salathe · Accepted Answer · 2011-09-28 08:57:17Z

The snippets below assume the (fixed) XML document is a string in $xml.

SimpleXML

$xml  = simplexml_load_string($xml);
$rows = $xml->children('rs', TRUE)->data->children('z', TRUE)->row;
foreach ($rows as $row) {
    $attributes = $row->attributes();
    $link_title = (string) $attributes->ows_LinkTitle;
    $gsm_puk    = (string) $attributes->ows_GSM_x0020_PUK;
    var_dump($link_title, $gsm_puk);
}

To read: SimpleXML usage, SimpleXMLElement::children(), SimpleXMLElement::attributes().

DOM

$doc = new DOMDocument;
$doc->loadXML($xml);
$rows = $doc->getElementsByTagNameNS('#RowsetSchema', 'row');
foreach ($rows as $row) {
    $link_title = $row->getAttribute('ows_LinkTitle');
    $gsm_puk    = $row->getAttribute('ows_GSM_x0020_PUK');
    var_dump($link_title, $gsm_puk);
}

To read: DOMDocument::getElementsByTagNameNS(), DOMElement::getAttribute().

Arkh · Accepted Answer · 2011-09-28 08:42:31Z

0

When you get your xml fixed, you should have a look at the simpleXML documentation and specifically the xpath method.

answered Sep 28, 2011 at 8:42

Arkh

8,44043 silver badges47 bronze badges

1 Comment

Gordon Over a year ago

wont help the OP because it doesnt say that it also requires registerXPathNamespace to make it work.

Collectives™ on Stack Overflow

Parsing complex XML in PHP5

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related