ansaurus

Question

is it possible to access xml data as a multidimensional array?

Answer 1

+1 A:

Unfortunately, unless you are parsing the xml file yourself, you cannot do this. Any attempt to access one of the nodes will most likely return a DOM error saying that it cannot be converted to a string.

You can take a look at this post: http://bytes.com/topic/php/answers/1364-turn-xml-into-2-dimensional-array.

If it is something you really need to do, you will probably need to do it yourself with an additional step, like creating a function or class to handle it.

Senica Gonzalez 2010-02-11 06:24:48

Answer 2

A:

Hi

i think its not a perfect solution for you but it might help you for your problem.

XML FILE:

<?xml version="1.0" encoding="ISO-8859-1"?>
<note>
<to>Tove</to>
<from>
    <name>Jani</name>
    <email>[email protected]</email>
</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</note>

PHP FILE:

<?php 
    $xml = simplexml_load_file("new.xml");  

    $webroot="http://".$_SERVER['HTTP_HOST']."/";
    $doc = new DOMDocument();

    $doc->load( $webroot.'/new.xml' );

    $note = $doc->getElementsByTagName( "note" );
    $final_arr = array();
    $i=0;
    foreach($note as $note)
    {
        $to = $note->getElementsByTagName( "to" );
        $to = $to->item(0)->nodeValue;
        $final_arr[$i]['to'] = $to;

        $from = $note->getElementsByTagName( "from" );
        foreach($from as $from)
        {
            $name = $from->getElementsByTagName( "name" );
            $name = $name->item(0)->nodeValue;
            $final_arr[$i]['from']['name'] = $name;
            $email = $from->getElementsByTagName( "email" );
            $email = $email->item(0)->nodeValue;
            $final_arr[$i]['from']['email'] = $email;
        }


        $heading = $note->getElementsByTagName( "heading" );
        $heading = $heading->item(0)->nodeValue;
        $final_arr[$i]['heading'] = $heading;

        $body = $note->getElementsByTagName( "body" );
        $body = $body->item(0)->nodeValue;
        $final_arr[$i]['body'] = $body;
        $i++;
    }

    echo "<pre>";
    print_r($final_arr);
    echo "</pre>";
?>

hope this works for you.

Avinash 2010-02-11 06:40:49

Wow avinash you code with amazing speed! Thank you so much for this solution. I really appreciate it and will certainly be putting it to good use!

Rees 2010-02-11 06:51:21

Glad to help You Rees :-)

Avinash 2010-02-11 06:53:32

Answer 3

A:

"and I would like to use syntax similar to multidimensional arrays." - I don't know if it's similar enough: $notes->note[0]->to; as in

<?php
$notes = new SimpleXMLElement('<?xml version="1.0" encoding="ISO-8859-1"?>
<notes>
  <note>
    <to>Tove</to>
    <from>
        <name>Jani</name>
        <email>[email protected]</email>
    </from>
    <heading>Reminder</heading>
    <body>Don\'t forget me this weekend!</body>
  </note>
  <note>...</note>
  <note>...</note>
</notes>');
echo $notes->note[0]->to;

VolkerK 2010-02-11 06:56:58

ansaurus

tags:

views:

answers:

is it possible to access xml data as a multidimensional array?

related questions