使用php和xml在html中创建数组的问题

Question

i have some problem when i want create a simple html array. I use php to get information from a xml file. I get the good information but many times so i want them just one time.

I tried to create 2 for but it is not worth so i delete 1 for and i tried to move the foreach but it is not the real problem, i juste don't know what can i do.

Here is the xml file :

<?xml version="1.0"?>
<users>
    <info>
        <lname>test</lname>
        <fname>test</fname>
        <email>[e-mail]</email>
        <password>******</password>
        <role>Membre</role>
    </info>
    <info>
        <lname>test2</lname>
        <fname>test2</fname>
        <email>[e-mail]</email>
        <password>******</password>
        <role>Super-Administrateur</role>
    </info>
    <info>
        <lname>test3</lname>
        <fname>test3</fname>
        <email>[e-mail]</email>
        <password>*******</password>
        <role>Administrateur</role>
    </info>
</users>

Here is the code :

<table border="1">
        <?php
        $nbrLigne = $xml->getElementsByTagName('info')->length;
        foreach ($xml->getElementsByTagName('info') as $item) {
            for ($i=0; $i<$nbrLigne; $i++) {
                echo "<tr>";

                echo "<td>" . $item->parentNode->getElementsByTagName('fname')->item($i)->nodeValue . "</td>";
                echo "<td>" . $item->parentNode->getElementsByTagName('lname')->item($i)->nodeValue . "</td>";
                echo "<td>" . $item->parentNode->getElementsByTagName('email')->item($i)->nodeValue . "</td>";
                echo "<td>" . $item->parentNode->getElementsByTagName('role')->item($i)->nodeValue . "</td>";

                echo "</tr>";
            }
        }
        ?>
    </table>

Here is the result :

Result of the test

Answer 1

Yeah, don't know why you're going back up in the tree, using "parentNode". This seems to work :

<table border="1">
    <?php
    foreach ($xml->getElementsByTagName('info') as $item) {
            echo "<tr>";
            echo "<td>" . $item->getElementsByTagName('lname')->item(0)->nodeValue. "</td>";
            echo "<td>" . $item->getElementsByTagName('fname')->item(0)->nodeValue. "</td>";
            echo "<td>" . $item->getElementsByTagName('email')->item(0)->nodeValue. "</td>";
            echo "<td>" . $item->getElementsByTagName('role')->item(0)->nodeValue. "</td>";
            echo "</tr>";
    }
    ?>
</table>

Also, you could refactor like this, for lisibility:

<table border="1">
<?php
foreach ($xml->getElementsByTagName('info') as $item) {
    echo "<tr>";
    foreach(['lname', 'fname', 'email', 'role'] as $field){
        echo "<td>" . $item->getElementsByTagName($field)->item(0)->nodeValue. "</td>";
    }
    echo "</tr>";
}
?>
</table>