Wrong Display Converting Array to XML Result in PHP

Question

I have trouble to display xml in php. before it, i converted an array code to xml. i got array result from oci_fetch_array

while ($data = oci_fetch_array($stmt, OCI_BOTH)) {
        $parent = $data['PARENT'];
        if($data['PARENT'] == 0) {
            $idx++;
            $idx2 = 0;
            $product[$idx]['text'] = $data['NAME'];
            $product[$idx]['cls'] = "folder"; 
        } else {
            $product[$idx]['children'][$idx2]['id'] = $data['ID'];
            $product[$idx]['children'][$idx2]['name'] = $data['NAME'];
            $product[$idx]['children'][$idx2]['code'] = $data['CODE'];
            $idx2++;
        }
    }

And this is the array result:

Array
(
    [-1] => Array
        (
            [children] => Array
                (
                    [] => Array
                        (
                            [id] => 4
                            [name] => SPEEDY 384 KB
                            [code] => SPEEDY_384KB
                        )

                    [1] => Array
                        (
                            [id] => 7
                            [name] => SPEEDY 2 MB
                            [code] => SPEEDY_2MB
                        )

                )

        )

)

then i used php code to convert it into xml, this is the code:

$product2=array($product);
$xml = new SimpleXMLElement("<services/>");
array_walk_recursive($product2, array ($xml, 'addChild'));
$string=$xml->asXML();
echo '<pre>', htmlentities($string), '</pre>';

yes, i got result but it's not what i hope. this is the result...

   <?xml version="1.0"?>
   <services>
        <4>id</4>
        <SPEEDY YOO>name</SPEEDY YOO>
        <SPEEDY_LOO>code</SPEEDY_LOO>
        <7>id</7>
        <2 MB>name</ 2 MB>
        <U2MB>code</U2MB>
    </services>

the result that i want is like this:

<?xml version="1.0"?>
   <services>
        <id>4</id>
        <name>SPEEDY YOO</name>
        <code>SPEEDY_LOO</code>
        <id>7</id>
        <name>2 MB</name >
        <code>U2MB</code>
    </services>

how can i get the right one? help me, thanks

Daniele D · Accepted Answer · 2014-11-27 07:32:56Z

1

You need to use array_flip() before using SimpleXMLElement because it uses the array index as values and the array values as tag names.

presuming that $product contains your data:

$product2=array(array_flip($product));
$xml = new SimpleXMLElement("<services/>");
array_walk_recursive($product2, array ($xml, 'addChild'));
$string=$xml->asXML();
echo '<pre>', htmlentities($string), '</pre>';

edited Nov 27, 2014 at 7:32

answered Nov 27, 2014 at 7:17

Daniele D

9691 gold badge9 silver badges21 bronze badges

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

7 Comments

Nike Angreni Over a year ago

could you give me an example? @DanieleD ? Cause i try with '$product2=array($product); $products=array_flip($product2); $xml = new SimpleXMLElement("<services/>"); array_walk_recursive($products, array ($xml, 'addChild')); $string=$xml->asXML(); echo '<pre>', htmlentities($string), '</pre>';'

Daniele D Over a year ago

I added one, presuming that $product is your array.

Nike Angreni Over a year ago

ok, i've tried, but it show '<?xml version="1.0"?> <services/>' only, there's no data... @DanieleD

Daniele D Over a year ago

Can you please tell me the content of $product and $product2 by print_r() ?

Nike Angreni Over a year ago

the result of print_r() is the array result.. @DanieleD

|

Collectives™ on Stack Overflow

Wrong Display Converting Array to XML Result in PHP

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related