Getting info from a specific XML Node

Question

I am trying to read the value for 3 specific XML nodes (bill_codes, sent_total, clicked_unique_total) I have done a lot of testing and I feel like I need someone with fresh eyes to look at this and help me find out what I no longer see..

I am using the simplexml_load_string function to load the XML into an array..

Here is the code that I have so far:

$xml = simplexml_load_string($content);
echo $xml->methodResponse->item->responseData->message_data->message->bill_codes;

This is the XML that I am using (comes from an API Call so I have no access to modifying/updating the structure of the XML)

<?xml version="1.0" encoding="utf-8"?>
<methodResponse>
  <item>
    <methodName>
      <![CDATA[legacy.message_stats]]>
    </methodName>
    <responseData>
      <message_data>
        <message id="2345456">
          <message_subject>
            <![CDATA[#1 Item You Should Be Hoarding in 2015]]>
          </message_subject>
          <date_sent>2014-12-18 04:01:34</date_sent>
          <message_notes>
            <![CDATA[Sample Notes]]>
          </message_notes>
          <withheld_total>0</withheld_total>
          <globally_suppressed>0</globally_suppressed>
          <suppressed_total>0</suppressed_total>
          <bill_codes>
            <![CDATA[8578]]>
          </bill_codes>
          <sent_total>734273</sent_total>
          <link_append_statement/>
          <timezone/>
          <message_name>
            <![CDATA[Sample Message Name]]>
          </message_name>
          <optout_total>4054</optout_total>
          <optout_rate_total>0.55</optout_rate_total>
          <clicked_total>5363</clicked_total>
          <clicked_unique>4350</clicked_unique>
          <clicked_rate_unique>13.71</clicked_rate_unique>
          <campaign_id>228640</campaign_id>
          <campaign_type>C</campaign_type>
          <included_groups>
            <segment id="1208891">
              <![CDATA[Segment Name Here]]>
            </segment>
          </included_groups>
          <included_smartlists></included_smartlists>
          <excluded_groups></excluded_groups>
          <excluded_smartlists></excluded_smartlists>
          <attributes></attributes>
          <link id="40278272">
            <has_name>1</has_name>
            <clicked_unique_total>4350</clicked_unique_total>
          </link>
        </message>
      </message_data>
    </responseData>
    <responseNum>
      <![CDATA[1]]>
    </responseNum>
    <responseCode>
      <![CDATA[201]]>
    </responseCode>
  </item>
</methodResponse>

score 1 · Accepted Answer · answered Jan 28 '15 at 01:56

1

No need to include the parent, just start with the ->item:

echo $xml->item->responseData->message_data->message->bill_codes;

Sample Output

answered Jan 28 '15 at 01:56

Kevin

41,694
12
53
70

What if the XML returns multiple messages? How do I identify bill_codes from message 1 and bill_codes from message 2? – Yaco Zaragoza Jan 28 '15 at 02:02
I tested adding the array position to message and it seems to be working fine.. I guess I can run this in a loop to get all the values.. this is the code that I am using right now: $xml->item->responseData->message_data->message[0]->bill_codes – Yaco Zaragoza Jan 28 '15 at 02:15
1

@YacoZaragoza you could also use `foreach` if thats the case, anyways, im just working on what you got on the question – Kevin Jan 28 '15 at 02:28
1

@YacoZaragoza so if there are multiple messages, you'll need to point it until messages, then each copy of the message node, you just simple echo the bill codes. – Kevin Jan 28 '15 at 02:29
1

@YacoZaragoza here's an example of what i mean, just in case http://codepad.viper-7.com/aMxEPp – Kevin Jan 28 '15 at 02:31

Getting info from a specific XML Node

1 Answers1