How to read XML Child Node Value in a String using PHP?

Question

I have a String which gets its value dynamically from other server. Value of string is

$xmloutput = '<response uri="/crm/private/xml/Leads/getRecordById">
    <result>
        <Leads>
            <row no="1">
                <FL val="LEADID">131</FL>
                <FL val="SMOWNERID">20001</FL>
                <FL val="Lead Owner"><![CDATA[Aaron]]></FL>
                <FL val="First Name"><![CDATA[Carol]]></FL>
                <FL val="Last Name"><![CDATA[Custer]]></FL>
                <FL val="Email"><![CDATA[[email protected]]]></FL>
            </row>
            <row no="2">
                <FL val="LEADID">2070</FL>
                <FL val="SMOWNERID">20001</FL>
                <FL val="Lead Owner"><![CDATA[Aaron]]></FL>
                <FL val="Last Name"><![CDATA[Florence, SC]]></FL>
            </row>
        </Leads>
    </result>
</response>

My Question is, generally we use $xml = simplexml_load_file("test1.xml"); to load XML files, but here in my requirement it is a String, how can i read this String value and extract the child node and its value? Example:

<FL val="LEADID">131</FL> // its key is LEADID and value is 131
<FL val="First Name"><![CDATA[Carol]]></FL> // its key is First Name and value is Carol

Is there a way to put this into Array? so that its easy for me to print out its node value?

Use simplexml_load_string() instead if you have the xml as a string. — M. Eriksson
– M. Eriksson, Commented Sep 22, 2018 at 10:16

Mohammad · Accepted Answer · 2018-09-22 10:17:06Z

2

Use simplexml_load_string() that is for reading xml from string. Then loop through row elements and in loop, loop through FL elements and then get text content and attribute of element.

$xml = simplexml_load_string($string); 
foreach ($xml->Leads->row as $row) {
    foreach ($row->FL as $fl) {
        echo "{$fl} => {$fl['val']}<br>";
    }
}

answered Sep 22, 2018 at 10:17

Mohammad

21.5k16 gold badges58 silver badges86 bronze badges

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

6 Comments

Hasan Over a year ago

I am getting following Warning Message for the this line foreach ($xml->Leads->row as $row) Warning: Invalid argument supplied for foreach() in D:\xampp\htdocs\zohoclient\xmlToHtml.php on line 50

Mohammad Over a year ago

@A.T.M.Hasan It's warning and you can turn off it using error_reporting(0)

Hasan Over a year ago

It is not giving me the output at the same time!

Barmar Over a year ago

@Mohammad It's not a warning you should turn off. It means the thing you're trying to loop over isn't actually an array, which means you have a bug in the code.

Hasan Over a year ago

Thanks a lot, buddy! foreach ($xml->result->Leads->row as $row) worked for me.

|

Collectives™ on Stack Overflow

How to read XML Child Node Value in a String using PHP?

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related