Question

Trying to generate XML file from returend SQL query results. The SQL query returns ItemId, ItemName, ItemDescription from Items table. I want to list the ItemNames inside XML like so:

XML

...
<item>
    <name>ItemName1</name>
</item>
<item>
    <name>ItemName2</name>
</item>
...

PHP

...
    while($items = @mysql_fetch_assoc($query)){
    foreach($items as $row){
    }
        $node = $doc->createElement( item );
        $node = $root->appendChild($node);
        $child = $doc->createElement( name );
        $child = $node->appendChild($child);
        $value = $doc->createTextNode($row[ ItemName ]); // !
        $value = $child->appendChild($value);
    }}
...

My XML structure generates properly but the problem is I get the first letter of each of the item s ItemDescription, instead ItemName inside every name element like so:

...
<name>D</name>
...
<name>H</name>
...

头两个项目有说明,从D和H信函开始。

What is causing this behaviour?

Answer 1

如果我正确理解,问题就是<代码>foreach(>,该编码正通过$ 阵列的每一关键/价值配对。我认为,这是你所希望的行为,因为我方言中的每一行都不是多维的。由于没有发现指数项目Name,因此没有达到[0](价值的第一个特性)。

Try just the while() loop:

...
    $resultset = mysql_query( $query );
    while($row = @mysql_fetch_assoc($resultset)){
        $node = $doc->createElement( item );
        $node = $root->appendChild($node);
        $child = $doc->createElement( name );
        $child = $node->appendChild($child);
        $value = $doc->createTextNode($row[ ItemName ]); // !
        $value = $child->appendChild($value);
    }
...

友情链接