Separating values from XML using php with xpath

Question

I need help from selecting data from XML. I can't seem to figure out the way xpath works with specific data selecting. Here is my XML:

<?xml version="1.0"?>
<a>
    <b>
        <c>Value 1</c>
        <d>Value 2</d>
    </b>
    <b>
        <c>Value 3</c>
        <d>Value 4</d>
    </b>
</a>

And PHP code i'm trying to use would be:

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

$result = $xml->xpath('b/c | b/d');
foreach ($result as $val){
    echo $val['c'] . $val['d'] . "<br>;
}

If i echo $val, i get all values, however, i want to separate it so i have $val['c'] and $val['d'], like when selecting specific data from MySQL table. Thank you in advance

Kevin · Accepted Answer · 2014-11-24 00:57:42Z

1

You could just point to b first, then inside the loop, each b, point it to c and d:

$result = $xml->xpath('//b');
foreach ($result as $val) {
    echo $val->c . $val->d . "<br>";
}

answered Nov 24, 2014 at 0:57

Kevin

41.9k12 gold badges57 silver badges72 bronze badges

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

Collectives™ on Stack Overflow

Separating values from XML using php with xpath

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related