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

//把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\"?>".$questiontitle."".$questioncontent."".$questionlink."".$answertitle."".$answercontent."".$passportid.""

?>

分享到：

2007-08-22 18:20

浏览 918

评论