【php开源代码栏目提醒】:网学会员--在 php开源代码编辑为广大网友搜集整理了:AjaxData1.php绩等信息,祝愿广大网友取得需要的信息,参考学习。
<?php
header('Content-Type: text/xml');
$xml="<?xml version='1.0' encoding='GB2312'?>";
$px=$_GET['px'];
$px=iconv( 'UTF-8', 'gb2312//IGNORE' , $px);
$exec="";
if($px=="0")
$exec="select * from mybook order by id";
if($px=="1")
$exec="select * from mybook order by name";
if($px=="2")
$exec="select * from mybook order by price";
$xml=$
xml."<contents>";
$link=mysql_connect("localhost","root","0");
mysql_select_db("books");
$result=
mysql_query($exec);
while($rs=my
sql_fetch_object($result))
{
$id=$rs->id;
$name=$rs->name;
$author=$rs->author;
$pub=$rs->publisher;
$isbn=$rs->isbn;
$type=$rs->type;
$price=$rs->price;
$content=$content."<content><id>".$id."</id><name>".$name."</name><author>".$author."</author><publisher>".$pub."</publisher><isbn>".$isbn."</isbn><type>".$type."</type><price>".$price."</price></content>";
}
$xml=$xml.$content."</contents>";
echo $xml;
mysql_close();
?>