刚刚学,我的源代码如下,但在浏览器中显示“XML 文档必须有一个顶层元素”错误,请问问题出在哪儿呢,谢谢!
<?php
//数据库基本信息
$server = "localhost";
$db_user = "root";
$db_pass = "root";
$database = "test";//连接数据库
$result = mysql_connect($server, $db_user,$db_pass); if (!$result) {
$errno = mysql_errno();
echo "连接错误:代码".$errno."<br>";
exit();
}//得到查询结果
$sql_select = "select time,serials1,serials2,serials3 from t_test";
$result = mysql_db_query($database,$sql_select);//创建XML
$dom = new DomDocument("1.0","UTF-8");
header( "Content-type: text/xml" );
$dom->formatOutput = true;
$root = $dom->createElement( "Chart" );
$dom->appendChild( $root );while ($row = mysql_fetch_array($result)) {
$dn = $dom->createElement( "data" );
$dn->setAttribute( 'time', $row['time'] );
$dn->setAttribute( 'serials1', $row['serials1'] );
$dn->setAttribute( 'serials2', $row['serials2'] );
$dn->setAttribute( 'serials3', $row['serials3'] );
$root->appendChild( $dn );
} echo $dom->save('test.xml');mysql_close();
?>
<?php
//数据库基本信息
$server = "localhost";
$db_user = "root";
$db_pass = "root";
$database = "test";//连接数据库
$result = mysql_connect($server, $db_user,$db_pass); if (!$result) {
$errno = mysql_errno();
echo "连接错误:代码".$errno."<br>";
exit();
}//得到查询结果
$sql_select = "select time,serials1,serials2,serials3 from t_test";
$result = mysql_db_query($database,$sql_select);//创建XML
$dom = new DomDocument("1.0","UTF-8");
header( "Content-type: text/xml" );
$dom->formatOutput = true;
$root = $dom->createElement( "Chart" );
$dom->appendChild( $root );while ($row = mysql_fetch_array($result)) {
$dn = $dom->createElement( "data" );
$dn->setAttribute( 'time', $row['time'] );
$dn->setAttribute( 'serials1', $row['serials1'] );
$dn->setAttribute( 'serials2', $row['serials2'] );
$dn->setAttribute( 'serials3', $row['serials3'] );
$root->appendChild( $dn );
} echo $dom->save('test.xml');mysql_close();
?>
解决方案 »
- 比较难的一个CURL
- 为什么我的网站用css+DIv做好后点下页上一页就变形了
- php-5.3.8目录下面 没有 php-cgi.exe文件
- linux 命令问题,求助~
- xml 与smarty问题
- 200分 非常不爽 散尽所有分数
- 求一个POSIX语法的正则式
- 请问各位大侠,如何在PHP程序中调用C语言写的函数?(急)
- 这个错误怎么解决啊?
- ASP.NET推出了,到底是ASP有前途还是PHP有前途?为什么现在公司都要PHP设计员,不要ASP设计员?
- 请问一下,申请了一个空间,而且里面自带一个数据库,我用默认的账号密码连接SELECT command denied to user 这个错误
- php 怎么动态更新网页内容
可以用<HTML></HTML>把一个网页所有内容都包在里面。这个<HTML></HTML>就是顶层元素了吧。
$server = "localhost";
$db_user = "root";
$db_pass = "root";
$database = "test"; //连接数据库
$result = mysql_connect($server, $db_user,$db_pass);
mysql_query("set names 'utf8'");
if (!$result) {
$errno = mysql_errno();
echo "连接错误:代码".$errno." <br>";
exit();
} //得到查询结果
$sql_select = "select time,serials1,serials2,serials3 from t_test";
$result = mysql_db_query($database,$sql_select); //创建XML
$dom = new DomDocument("1.0","UTF-8");
//header( "Content-type: text/xml" );
$dom->formatOutput = true;
$root = $dom->createElement( "Chart" );
$dom->appendChild( $root ); while ($row = mysql_fetch_array($result)) {
$dn = $dom->createElement( "data" );
$dn->setAttribute( 'time', $row['time'] );
$dn->setAttribute( 'serials1', $row['serials1'] );
$dn->setAttribute( 'serials2', $row['serials2'] );
$dn->setAttribute( 'serials3', $row['serials4'] );
$root->appendChild( $dn );
}
echo $dom->save('test.xml');
mysql_close(); 结帖吧.