parse complex xml with php simple xml

Question

I want to parse (little critical) xml using php simplexml...But i can aither get attribute or either value...m not able to parse this XML properly

<?xml version="1.0" encoding="UTF-8" ?>
<response uri="/crm/private/xml/Leads/getMyRecords">
    <result>
        <Leads>
            <row no="1">
                <FL val="LEADID">418176000000051001</FL>
                <FL val="SMOWNERID">418176000000047003</FL>
                <FL val="Lead Owner"><![CDATA[Amit Patil]]>
                </FL>
                <FL val="Company"><![CDATA[demo Company]]>
                </FL>
                <FL val="First Name"><![CDATA[Test]]>
                </FL>
                <FL val="Last Name"><![CDATA[Demo]]>
                </FL>
                <FL val="Designation"><![CDATA[Tesing Lead]]>
                </FL>
                <FL val="No of Employees"><![CDATA[0]]>
                </FL>

And this is what i am soo far

$xml = simplexml_load_file($url);
if($xml != null){
   foreach($xml->result->Leads->row as $key=>$row){
       foreach($row->FL as $key=>$val){
           echo $val.",";
       }
   }
}

How can i parse this XML using simplexml or may be something else ??

Mark Baker · Accepted Answer · 2012-02-16 10:29:14Z

4

val is an attributeof FL, not the content... so I'm not sure what you're trying to retrieve when you use the ambiguously named $val

As the code you have should already display the content of each element: to retrieve the attributes, use

foreach($xml->result->Leads->row as $key=>$row){
    foreach($row->FL as $key => $value){
        echo $value['val']." => ";
        echo $value."<br />";
    }
}

From your snippet of XML, this gives:

LEADID => 418176000000051001
SMOWNERID => 418176000000047003
Lead Owner => Amit Patil 
Company => demo Company 
First Name => Test 
Last Name => Demo 
Designation => Tesing Lead 
No of Employees => 0

answered Feb 16, 2012 at 10:29

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

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

3 Comments

Amit Patil Over a year ago

I was working on it for 2-3 hours and gone deeeep inside and forgot to think simple...neither even noticed that it should work if i think like ita an array like u have done it :) :) i solved it using this foreach($row->FL as $val) $val->attributes()."=".$val;

Amit Patil Over a year ago

Thank u sooo much for this simple solution and for bringing me back to normal :) :) :)

Jiminy Cricket Over a year ago

On a side note, use strval($value) if you wish to store the string value of $value, since $value is actually a simple xml object.

Collectives™ on Stack Overflow

parse complex xml with php simple xml

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related