新手请求各位帮助:php和xml的问题

zzyiori

用php实现对数据库(MySql)的查询,返回的结果用xml显示出来,这个怎么处理.
比如说:查询数据库中student的表,返回其中的name ,sex,age这几列数据.希望大家帮帮忙,谢谢!

夕水

懒了吧，呵呵！
下面是自己写的从数据库里面读文件，生成xml的例子
$typeid是类别参数
sql（）是我自己写的函数，方便数据查询的
function sql($sql){
         $db=@mysql_query ($sql);
         $array = @mysql_fetch_array($db);
         return $array;
}

if(empty($typeid)){ echo "类别为空!";exit();}
header("content-type: text/xml";
$query="Select name,kind from $sql_lanmu where lid=$typeid ";
$row=sql($query);
$typename = htmlspecialchars($row[name]);
$kind =$row[kind];
$query_root="select sitename,siteurl,email from $sql_root ";
$row_root=sql($query_root);
$sitename=$row_root[sitename];
$siteurl =$row_root[siteurl];
$email =$row_root[email];
$link="$siteurl/lanmu.php?lid=$typeid";
$qc = "?";
$row = "";
echo "<".$qc."xml version=\"1.0\" encoding=\"gb2312\"".$qc.">;\r\n";
echo "<rss version=\"2.0\">;\r\n";
echo "<channel>;\r\n";
echo "<title>;$typename</title>;\r\n";
echo "<link>;$link</link>;\r\n";
echo "<description>;$sitename 的 $typename 分类的最新内容</description>;\r\n";
echo "<language>;zh-cn</language>;\r\n";
echo "<generator>;power by $sitename</generator>;\r\n";
echo "<webmaster>;$email</webmaster>;\r\n";
if ($kind)
{
$query = "Select wid,name,content,date,newsurl From $sql_art where lid=$typeid order by wid desc limit 0,100";
$rs = mysql_query($query);
while($row = mysql_fetch_object($rs))
{
         $title = htmlspecialchars(trim($row->;name));
         $content = htmlspecialchars(cn_substr(trim($row->;content),250))."...";
         $stime =date("Y-m-d",$row->;date);
         $filelink = htmlspecialchars($row->;newsurl);
         echo "<item>;
     <title>;$title</title>;
     <link>;$filelink</link>;
     <description>;$content</description>;
     <pubDate>;$stime</pubDate>;
     <category>;$typename</category>;
          </item>;\r\n";
}
}
else
{
$query = "Select  name,type,lid from $sql_lanmu where kind=$typeid";
$rs =mysql_query($query);
while($row=mysql_fetch_object($rs))
{   
      $title = htmlspecialchars(trim($row->;name));
          echo"<item>;
          <title>;$title</title>;
          <link>;$filelink</link>;
          <description>;$title</description>;
               </item>;\r\n";
  }
}
echo "</channel>;\r\n";
echo "</rss>;\r\n";

zzyiori

谢谢,太感谢了,帮大忙了