XML to one level php array

Question

I want to convert this xml output:

<?xml version="1.0" encoding="UTF-8"?>
<levela xmlns="https://restapi" version="1.0.0">
 <levelb>
   <levelc>
     <var1>01</var1>
     <var2>String1</var2>
   </levelc>
   <levelc>
     <var1>02</var1>
     <var2>String2</var2>
   </levelc>
   <levelc>
     <var1>08</var1>
     <var2>String3</var2>
   </levelc>
 </levelb>
</levela>

to this php array:

array(
    '01' => 'String1',
    '02' => 'String2',
    '08' => 'String3'
  )

I tried in many ways, but it's more difficult than I thought (for me). I hope someone can help me. Many thanks in advance!

Possible duplicate of How do you parse and process HTML/XML in PHP? — Andy Hoffner
– Andy Hoffner, Commented Mar 23, 2016 at 21:57
I'm voting to close this question as off-topic because it is a "write my code" type question — michi
– michi, Commented Mar 24, 2016 at 0:44

fusion3k · Accepted Answer · 2016-03-23 21:32:45Z

1

It's an easy task with SimpleXML:

Load the XML into a SimpleXML object:

$xml = simplexml_load_string( $string );

Perform a foreach() loop through all <issuer> nodes and add <issuername> child node text value to your array using <issuerid> as key:

$result = array();
foreach( $xml->directory->issuer as $node )
{
    $result[ $node->issuerid->__toString() ] = $node->issuername->__toString();
}

print_r( $result );

The output is:

Array
(
    [01] => ABN Amro Bank
    [02] => ASN Bank
    [08] => Friesland Bank
)

SimpleXML return an object, so you need to cast as string node values with ->toString() method to add it as string.

Read more about SimpleXML

edited Mar 23, 2016 at 21:32

answered Mar 23, 2016 at 21:28

fusion3k

11.7k4 gold badges27 silver badges47 bronze badges

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

2 Comments

Loufylouf Over a year ago

Apparently the last entry in the array should be [08] => 'Friesland Bank' , you may have to change a bit your code.

fusion3k Over a year ago

@Loufylouf Yes, you are right. I did not see the use of issuerid as key. Thank you for the catch! Answer edited.

Loufylouf · Accepted Answer · 2016-03-23 21:22:03Z

You can use the follwong little trick to first get an array.

$xml = simplexml_load_string($xmlstring);
$json = json_encode($xml);
$array = json_decode($json,TRUE);

The result of this will be an array representing exactly the XML structure, like that :

Array
(
    [@attributes] => Array
        (
            [version] => 1.0.0
        )

    [directory] => Array
        (
            [issuer] => Array
                (
                    [0] => Array
                        (
                            [issuerid] => 01
                            [issuername] => ABN Amro Bank
                        )

                    [1] => Array
                        (
                            [issuerid] => 02
                            [issuername] => ASN Bank
                        )

                    [2] => Array
                        (
                            [issuerid] => 08
                            [issuername] => Friesland Bank
                        )

                )

        )

)

With just a little bit of work, you will be able to build the array you want.

Collectives™ on Stack Overflow

XML to one level php array

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related