php输出标准xml，php访问mysql数据库简单例子（可以被asp等程序读取）

 <?php
//把bbs的回复写入blog  blog根据bbs的回帖id输出一个相关的xml文档
    //根据回帖id（pid），得到回贴记录和对应的主帖记录
 require("config.inc.php");

//$pid=1259714;
 $pid=$_GET['pid'];
    $exec1="select A.tid atid,A.authorid aauthorid,A.subject asubject,A.message amessage,B.pid bpid,B.subject bsubject,B.message bmessage,C.passportid cpassportid from bbs_posts B
inner join bbs_posts A inner join bbs_members C where  B.pid=".$pid." and A.tid=B.tid 
and A.first=1 and B.authorid=C.uid limit 0,1";
    $conn=mysql_connect ($dbhost, $dbuser, $dbpw);
    mysql_select_db($dbname);
    mysql_query("SET NAMES 'GB2312'");
 $result1=mysql_query($exec1);
 /*
 while($rs1=mysql_fetch_object($result1))
 {
  echo "a.tid:".$rs1->atid." ";
  echo "a.authorid".$rs1->aauthorid;
  echo "A.subject".$rs1->asubject;
  echo "A.message".$rs1->amessage;
  echo "B.pid".$rs1->bpid;
  echo "B.message".$rs1->bmessage;
  echo "C.passportid".$rs1->cpassportid;
 }*/

 //开始写xml
   while($rs1=mysql_fetch_object($result1))
   {
   $questiontitle=$rs1->asubject;
   $questioncontent=$rs1->amessage;
   $questionlink=$rs1->atid; //主帖的url  (查看详细 联接)http://bbs.91.cn/viewthread.php?tid=1029042&extra=page%3D1
   //$questionlink="http://bbs.91.cn/viewthread.php?tid=".$questionlink."&extra=page%3D1";
  
   //$answertitle=$rs1->asubject;
   $answertitle=$rs1->bsubject;
   $answercontent=$rs1->bmessage;
   $passportid=$rs1->cpassportid;
   }
 
 transfor($questioncontent);
 function transfor(&$str)
 {
  $str=preg_replace("/(/[[^/[]*/])/", "", $str);
  $str=preg_replace("/(/“)/", "'", $str);
  $str=preg_replace("/(/”)/", "'", $str);
  $str=preg_replace("/(/")/", "'", $str);
 }

  /* 
    $query1=$db->query(exec1);
    $thaauote1=$db->fetch_array($query1);
    $a=$thaauote1["author"];
    echo $a;
   
    $uid=2;
    $exec2="select uid,passportid,username from bbs_members where uid=".$uid;
    $query2 = $db->query(exec2);
    $thaquote2=$db->fetch_array($query2);
    $puid=$thaquote2["passportid"];
    echo $puid;  */
   
    //拼成一个标准的xml文档
   /* header("Content-type:application/xml"); 
    header("Content-Type: text/xml; charset=gb2312");*/
   /*$questiontitle="我怎[font color=red][/font]么了？";
   $questioncontent="有病";
   $questionlink="http://www.qq.com";
   $answertitle="回复";
   $answercontent="严重";*/
   header("Content-type:application/xml"); 
   header("Content-Type: text/xml; charset=gb2312");
    echo "<?xml version=/"1.0/" encoding=/"gb2312/"?><asks><ask><questiontitle>".$questiontitle."</questiontitle><questioncontent>".$questioncontent."</questioncontent><questionlink>".$questionlink."</questionlink><answertitle>".$answertitle."</answertitle><answercontent>".$answercontent."</answercontent><passportid>".$passportid."</passportid></ask></asks>"

?>