<?
$result = mysql_query("select * from table");
header("contenttype:text/xml");
echo "<?xml version='1.0' encoding='UTF-8'?>";
echo "<root>"
while($arr = mysql_fetch_array($result))
{
echo "<content>";
$i = 0;
while($meta = mysql_fetch_field($result))
{
echo "<".$meta->name.">".$arr[$i]."</".$meta->name.">";
$i++;
}
echo "</content>";
}
echo "</root>";
mysql_free_result($result);
?>
$result = mysql_query("select * from table");
header("contenttype:text/xml");
echo "<?xml version='1.0' encoding='UTF-8'?>";
echo "<root>"
while($arr = mysql_fetch_array($result))
{
echo "<content>";
$i = 0;
while($meta = mysql_fetch_field($result))
{
echo "<".$meta->name.">".$arr[$i]."</".$meta->name.">";
$i++;
}
echo "</content>";
}
echo "</root>";
mysql_free_result($result);
?>
那时我就欠了header("content-type:text/xml"); 我是用DW MX2004开发的,然后自己去修改代码,我的修改代码如下:
----------------------------------------
<?php header("content-type:text/xml");?>
<?php require_once('Connections/conn.php'); ?>
<?php
mysql_select_db($database_conn, $conn);
$query_rs = "SELECT * FROM `admin`";
$rs = mysql_query($query_rs, $conn) or die(mysql_error());
$row_rs = mysql_fetch_assoc($rs);
$totalRows_rs = mysql_num_rows($rs);
?>
<?php
echo"<?xml version=\"1.0\" encoding=\"gb2312\"?>\n";
echo"<管理员>\n";
?>
<?php do { ?>
<?php echo " <用户ID ID='".$row_rs['amdin_id']."'>\n"; ?>
<?php echo " <用户名>". $row_rs['admin_name']."</用户名>\n"; ?>
<?php echo " <密码>".$row_rs['admin_pass']."</密码>\n"; ?>
<?php echo " <水平>".$row_rs['admin_leavel']."</水平>\n"; ?>
<?php echo " </用户ID>\n";?>
<?php } while ($row_rs = mysql_fetch_assoc($rs)); ?>
<?php
echo"</管理员>\n";
mysql_free_result($rs);
?>