如何在php中用while循环生成子xml节点

Question

$xml = new DOMDocument();
$root=$xml->createElement("ROOT");
$xml->appendChild($root);

$data=$xml->createElement("DATA");

while($row=db_fetch_object($result))
{
    $data=$xml->createElement("ITEM");
    $item->setAttribute("COMPANY",$row->field_windmill_fabrikant_value);
    $item->setAttribute("HEIGHT",$row->field_windmill_ashoogte_value);
    $item->setAttribute("POWER",$row->field_windmill_vermogen_value);
    $item->setAttribute("LOCATION",$row->field_windmill_provincie_value);
    $item->setAttribute("START_YEAR",$row->field_windmill_startjaar_value);
    $data->appendChild($item);
}

$root->appendChild($data);
echo $xml->saveXML();

在这里，我想将ITEM作为子节点附加到data，但是ITEM被附加到item而不是data。我使用的是PHP。有谁能帮上忙吗。谢谢。

Answer 1

只需替换

$data=$xml->createElement("ITEM");

使用

$item=$xml->createElement("ITEM");

其结果将是

<?xml version="1.0"?>
<ROOT>
    <DATA>
        <ITEM COMPANY="COMPANY0" HEIGHT="HEIGHT0" POWER="POWER0" LOCATION="LOCATION0" START_YEAR="START_YEAR0"/>
        <ITEM COMPANY="COMPANY1" HEIGHT="HEIGHT1" POWER="POWER1" LOCATION="LOCATION1" START_YEAR="START_YEAR1"/>
        <ITEM COMPANY="COMPANY2" HEIGHT="HEIGHT2" POWER="POWER2" LOCATION="LOCATION2" START_YEAR="START_YEAR2"/>
    </DATA>
</ROOT>