xml parsing question

roushguy

Hello everyone.. i have done some xml parsing before in the past, but i am having trouble parsing this xml.. basically all i want to do is parse out the field name, and the field value...

$response = "<RESPONSE>
<FIELDS>
<FIELD KEY=\"CUST_NBR\">9009</FIELD>
<FIELD KEY=\"DBA_NBR\">1</FIELD>
<FIELD KEY=\"TERMINAL_NBR\">1</FIELD>
<FIELD KEY=\"TRAN_TYPE\">CCM1</FIELD>
<FIELD KEY=\"BATCH_ID\">1200</FIELD>
<FIELD KEY=\"TRAN_NBR\">4</FIELD>
<FIELD KEY=\"LOCAL_DATE\">080408</FIELD>
<FIELD KEY=\"LOCAL_TIME\">084907</FIELD>
</FIELDS>
</RESPONSE>";

i hope someone can help me out on this one.. whats the way to get this done?
thanks!

NogDog

Are you using something like the [man]simplexml[/man] functions to do the parsing, or are you looking for more of something like a [man]preg_match/man regular expression solution?

TeraTask

This should help:

<?php
$response = "<RESPONSE>
<FIELDS>
<FIELD KEY=\"CUST_NBR\">9009</FIELD>
<FIELD KEY=\"DBA_NBR\">1</FIELD>
<FIELD KEY=\"TERMINAL_NBR\">1</FIELD>
<FIELD KEY=\"TRAN_TYPE\">CCM1</FIELD>
<FIELD KEY=\"BATCH_ID\">1200</FIELD>
<FIELD KEY=\"TRAN_NBR\">4</FIELD>
<FIELD KEY=\"LOCAL_DATE\">080408</FIELD>
<FIELD KEY=\"LOCAL_TIME\">084907</FIELD>
</FIELDS>
</RESPONSE>";

echo '<h1>Parsed Using Regular Expression</h1>';
preg_match_all('#<FIELD KEY="(\w+)">(\w+)</FIELD>#',$response, $matches);

foreach ($matches[1] as $index=>$a_key) {
  echo $a_key.'='.$matches[2][$index].'<br />';
}
echo '<hr />';
echo '<h1>Parsed Using SimpleXMLElement</h1>';
try {
  $response_parsed = new SimpleXMLElement($response);
  if (isset($response_parsed->FIELDS) && isset($response_parsed->FIELDS->FIELD)) {
    foreach($response_parsed->FIELDS->FIELD as $a_field) {      

      $field_key = '';
      foreach ($a_field->attributes() as $attribute_name=>$attribute_value) {
        if ($attribute_name == 'KEY') {
          $field_key = $attribute_value;
          }
      }
      echo $field_key.'='.((string)$a_field).'<br />';
    }
  } else {
    throw new Exception('XML Formatting does not match for this routine.');
  }
} catch (Exception $e) {
  echo 'Error parsing XML: '.$e->getMessage();
}
?>