How do I retrieve a node from an array using simplexmlelement or other XML function?

Question

I'm using Linkedin API --> https://developer.linkedin.com/documents/profile-fields#company

Everything is working fine, I can connect to the API with no problem. Bellow follow the data returned by the API when I request some data.

Here is my request (I will not post the whole code, it is more than 500 lines) but it is the essence of what I want to retrieve.

$response2 = $OBJ_linkedin->profile('~:(recommendations-received)');
if($response2['success'] === TRUE) 
{
   $response2['linkedin'] = new SimpleXMLElement($response2['linkedin']);
   echo "<pre>" . print_r($response2['linkedin'], TRUE) . "</pre>";
}
else 
{
   // request failed
   echo "Error: <br />RESPONSE:<br /><br /><pre>" . print_r($response2) . "</pre>";
}

Above follow the response:

SimpleXMLElement Object
(
    [recommendations-received] => SimpleXMLElement Object
        (
            [@attributes] => Array
                (
                    [total] => 1
                )

            [recommendation] => SimpleXMLElement Object
                (
                    [id] => 0123456
                    [recommendation-type] => SimpleXMLElement Object
                        (
                            [code] => service-provider
                        )

                    [recommendation-text] => Here come the recommendation text from the API.
                    [recommender] => SimpleXMLElement Object
                        (
                            [id] => npAnFGrTys
                            [first-name] => John
                            [last-name] => Doe
                        )

                )

        )

)

Now my question:

How to retrieve and print only the [recommendation-text] node? I'm already calling only the recommendations-received $response2 = $OBJ_linkedin->profile('~:(recommendations-received)'); but it returns the whole thing, then how to get only the [recommendation-text] ???

I have try with simplexmlelement (http://br2.php.net/manual/en/class.simplexmlelement.php), but with no success.

Thanks in advance for any, any help.

[RESULT]

I will post what was the answer that worked out to me.

I'm using the following code as suggested @Mircea:

$sxml = new SimpleXMLElement($response2['linkedin']); 
$res = $sxml->xpath('recommendations-received/recommendation/recommendation-text'); 
echo $res[0];

Instead of this code:

   $response2['linkedin'] = new SimpleXMLElement($response2['linkedin']);
   echo "<pre>" . print_r($response2['linkedin'], TRUE) . "</pre>";

The difference here is now I'm using the xpath method to search the simpleXML node for children matching. Thanks @Mircea.

hakre · Accepted Answer · 2012-05-18 22:28:39Z

2

You should try xpath function of simplexmlelement http://www.php.net/manual/en/simplexmlelement.xpath.php. I think that the corect way to get what you want is:

$sxml->xpath('recommendations-received/recommendation/recommendation-text')

It returns an array, so you should iterate on it (look at the examples on that page). The xpath query is something like that, it ultimately depends on the structure of the xml received.

Hope it helps.

edited May 18, 2012 at 22:28

hakre

200k55 gold badges454 silver badges866 bronze badges

answered Apr 16, 2012 at 15:42

Mircea

9256 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

devasia2112 Over a year ago

You are right man! $sxml = new SimpleXMLElement($response2['linkedin']); $res = $sxml->xpath('recommendations-received/recommendation/recommendation-text'); echo $res[0];

devasia2112 Over a year ago

I will accept your answer as the correct one! Thank you very much, it was so simple that I can't imagine. Thanks again to clear up the idea!

Mircea Over a year ago

No problem. Glad to be helpful

Unpossible · Accepted Answer · 2012-04-16 16:53:36Z

0

Accessing the recommendation-text property would be done via something like:

foreach($response2->{recommendations-received} as $recommendation) {
  $recommendation->{recommendation-text}
}

answered Apr 16, 2012 at 16:53

Unpossible

10.7k23 gold badges78 silver badges115 bronze badges

2 Comments

devasia2112 Over a year ago

I can't retrieve doing like this. Isn't work here. Nothing happen. :(

devasia2112 Over a year ago

Thanks anyway, the answer was in using the xpath method to search the node.

Collectives™ on Stack Overflow

How do I retrieve a node from an array using simplexmlelement or other XML function?

2 Answers 2

3 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related