PHP - Dom Xpath question

Question

With this XML:

<?xml version="1.0" encoding="UTF-8" ?>
<databases>
    <default>
        <type>mysql</type>
        <host>localhost</host>
        <table-prefix></table-prefix>
        <username>root</username>
        <password></password>
        <charset>UTF-8</charset>
    </default>
    <test>
        <type>mysql</type>
        <host>localhost</host>
        <table-prefix></table-prefix>
        <username>root</username>
        <password></password>
        <charset>UTF-8</charset>
    </test>
</databases>

Code:

public function get($xpath = '/')
    {
        $dom_object = new DOMDocument();
        $dom_object->load($this->_filename);
        $domxpath_object = new DOMXpath($dom_object);

        $domnodelist_object = $domxpath_object->query($xpath);

        return $this->XMLConfigurationToArray($domnodelist_object);
    }

private function XMLConfigurationToArray(DOMNodeList $domnodelist_object)
    {
        $configuration_array = array();

        foreach ($domnodelist_object as $element)
        {
            if ($element->hasChildNodes())
            {
                foreach ($element->childNodes as $c)
                {
                    print_r('<pre>' . $element->tagName . '</pre>');
                }
            }
        }

        return $configuration_array;
    }

Why it prints out databases 5 times? I call get('/databases') ... Thank you.

If you only want to get <databases> just query / (also see my answer related to the textnodes) — Dr.Molle
– Dr.Molle, Commented Jan 31, 2011 at 19:41

Dr.Molle · Accepted Answer · 2011-01-31 19:53:57Z

1

There are also whitespaces, which are childNodes too (textNodes)

Ignore the textNodes:

if($c->nodeType===1)
{
  echo('<pre>' . $c->tagName . '</pre>');
}

...or use also XPATH to retrieve the child(element)-nodes.

You can also ignore the whitespaces from the start(as described in the topic linked by Gordon):

$dom_object = new DOMDocument();
$dom_object->preserveWhiteSpace=false;

edited Jan 31, 2011 at 19:53

answered Jan 31, 2011 at 19:30

Dr.Molle

117k16 gold badges200 silver badges206 bronze badges

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

3 Comments

thomas Over a year ago

do you mean tabs == whitespaces? so, in xml, i cannot have whitespaces? will every whitespace be an textnode? thank you.

Dr.Molle Over a year ago

yes, tabs, linebreaks, spaces. You have one after <databases>, one after </default> and one after </test>

user357812 Over a year ago

@thomas: No, every text node is going to be a text node. Preserving or stripping white space only text nodes is usually a matter or XML parser configuration. Check for @Gordon's answer

Dimitre Novatchev · Accepted Answer · 2011-01-31 21:16:28Z

1

Why it prints out databases 5 times? I call get('/databases')

Because the databases top element has 5 children nodes: 2 elements and three (whitespace-only)text nodes, surrounding the elements.

answered Jan 31, 2011 at 21:16

Dimitre Novatchev

244k27 gold badges308 silver badges438 bronze badges

Collectives™ on Stack Overflow

PHP - Dom Xpath question

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related