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

lsyf8

　　<?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]么了？";
$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>"
　　?>