使用PHP创建一个XML文件

最大的问题出现在这一行：

$xml->endElement('member');

对于面向对象的样式，XMLWriter::endElement不需要任何参数。从…起http://php.net/manual/en/function.xmlwriter-end-element.php:

bool XMLWriter:：endElement（void）

该参数使endElement失败，从而导致意外嵌套。删除参数，您的嵌套问题应该得到解决：

$xml->endElement();

另一个问题是XMLWriter::startDocument将在打开php标记之前开始的文档中间输出<?xml version="1.0"?>。不要将原始XML与XMLWriter混合，而是让XMLWriter对象处理所有内容。

尝试以下修改版本的代码：

<?php
//mysql_connect("", "", "") or die(mysql_error()); 
//mysql_select_db("") or die(mysql_error());
//$sql = "SELECT fid37, fid38, fid39 FROM mytable WHERE fid37 IS NOT NULL";
//$res = mysql_query($sql);
$rows = array
(
    array ("fid37" => "1fid37", "fid38" => "1fid38", "fid39" => "1fid39"),
    array ("fid37" => "2fid37", "fid38" => "2fid38", "fid39" => "2fid39"),
    array ("fid37" => "3fid37", "fid38" => "3fid38", "fid39" => "3fid39"),
    array ("fid37" => "4fid37", "fid38" => "4fid38", "fid39" => "4fid39")
);
$xml = new XMLWriter();
$xml->openURI("php://output");
$xml->startDocument();
$xml->setIndent(true);
$xml->writePI('xml-stylesheet', 'href="squad.xsl?" type="text/xsl"');
$xml->writeDTD('squad', null, 'squad.dtd');
$xml->startElement('squad');
$xml->writeAttribute('nick', 'MyTAG');
$xml->writeElement('name', 'GROUP NAME');
$xml->writeElement('email', 'admin@website.com');
$xml->writeElement('web', 'http://website.com/');
$xml->writeElement('picture', 'Logo.png');
$xml->writeElement('title', 'Multi-gaming Team');
//while ($row = mysql_fetch_assoc($res))
foreach ($rows as $row)
{
    $xml->startElement('member');
    $xml->writeAttribute('id', $row['fid38']);
    $xml->writeAttribute('nick', $row['fid37']);
    $xml->writeElement('name', $row['fid37']);
    $xml->writeElement('email', 'N/A');  
    $xml->writeElement('icq', 'N/A');  
    $xml->writeElement('remark', $row['fid39']);  
    $xml->endElement();
}
$xml->endElement();
header('Content-type: text/xml');
$xml->flush();

代码应该生成以下XML:

<?xml version="1.0"?>
<?xml-stylesheet href="squad.xsl?" type="text/xsl"?>
<!DOCTYPE squad
SYSTEM "squad.dtd">
<squad nick="MyTAG">
 <name>GROUP NAME</name>
 <email>admin@website.com</email>
 <web>http://website.com/</web>
 <picture>Logo.png</picture>
 <title>Multi-gaming Team</title>
 <member id="1fid38" nick="1fid37">
  <name>1fid37</name>
  <email>N/A</email>
  <icq>N/A</icq>
  <remark>1fid39</remark>
 </member>
 <member id="2fid38" nick="2fid37">
  <name>2fid37</name>
  <email>N/A</email>
  <icq>N/A</icq>
  <remark>2fid39</remark>
 </member>
 <member id="3fid38" nick="3fid37">
  <name>3fid37</name>
  <email>N/A</email>
  <icq>N/A</icq>
  <remark>3fid39</remark>
 </member>
 <member id="4fid38" nick="4fid37">
  <name>4fid37</name>
  <email>N/A</email>
  <icq>N/A</icq>
  <remark>4fid39</remark>
 </member>
</squad>

问题是您的脚本对您发布在其顶部的XML代码没有任何作用。您需要使用XMLWriter来输出它——您不能像以前那样只将XML添加到脚本中。

你的脚本应该是这样的（我省略了一些细节——你可以在空闲时填写！）：

<?php
## these should be changed to mysqli_* functions!
mysql_connect("", "", "") or die(mysql_error()); 
mysql_select_db("") or die(mysql_error());
$sql = "SELECT fid37, fid38, fid39 FROM mytable WHERE fid37 IS NOT NULL";
$res = mysql_query($sql);
# open the XML document
$xml = new XMLWriter();
$xml->openURI("php://output");
$xml->setIndent(true);
$xml->startDocument('1.0');
# writes the DTD line
$xml->writeDTD('squad', NULL, 'squad.dtd');
# writes the stylesheet line
$xml->writePI('xsl-stylesheet', 'href="squad.xsl?" type="text/xsl"');
# now output the squad element and its child nodes
$xml->startElement("squad");
$xml->writeAttribute('nick', 'MYTAG');
$xml->writeElement('name', 'GROUP NAME');
... # etc. for the rest of the elements
# add the members    
while ($row = mysql_fetch_assoc($res)) {
  $xml->startElement('member');
  $xml->writeAttribute('id', $row['fid38']);
  ... # etc.
  # close the member element
  $xml->endElement();
}
# close the squad element and the document
$xml->endElement();
$xml->endDocument();

这就是我最终使用的（Starson Hochschild的代码进行了小编辑）：

$sql = "SELECT * FROM mytable WHERE `fid37` IS NOT NULL";
$res = mysql_query($sql);


$xml = new XMLWriter();
$xml->openURI("php://output");
$xml->startDocument();
$xml->setIndent(true);
$xml->writePI('xml-stylesheet', 'href="squad.xsl?" type="text/xsl"');
$xml->writeDTD('squad', null, 'squad.dtd');
$xml->startElement('squad');
$xml->writeAttribute('nick', 'MyTag');
$xml->writeElement('name', 'GroupName');
$xml->writeElement('email', 'GroupEmail');
$xml->writeElement('web', 'GroupWebsite');
$xml->writeElement('picture', 'GroupLogo.png');
$xml->writeElement('title', 'Multi-gaming Team');
while ($row = mysql_fetch_assoc($res))
//foreach ($rows as $row)
{
    $xml->startElement('member');
    $xml->writeAttribute('id', $row['fid38']);
    $xml->writeAttribute('nick', $row['fid37']);
    $xml->writeElement('name', $row['fid37']);
    $xml->writeElement('email', 'N/A');  
    $xml->writeElement('icq', 'N/A');  
    $xml->writeElement('remark', $row['fid39']);  
    $xml->endElement();
}
$xml->endElement();
header('Content-type: text/xml');
$xml->flush();
?>

它看起来很像，如果我真的写xml代码，它会是什么样子。