<?phpheader("content-type:text/html;charset=utf-8");//制作xml接口，提供網站最新的10條商品信息$link = mysql_connect('localhost','root','123');mysql_select_db('shop',$link);mysql_query('set names utf8');/*<shop>  <goods>    <name></name>    <price></price>    <number></number>  </goods>  ......</shop>*/$sql = "select goods_name, goos_price, goods_number from sw_goods order by goods_id desc limit 10";$qry = mysql_query($sql);//接收的是一個結果集$info = array();//取出每一條記錄while($re = mysql_fetch_assoc($qry)){  //$re 是一維數組，代表每條記錄  $info[] = $re;//$info是二維數組，接收每條記錄}$dom = new DOMDocument('1.0', 'utf-8');$shop = $dom -> createElement('shop');//創建根節點for($i=0; $i<count($info); $i++){  //創建元素節點  $goods = $dom -> createElement('goods');  $name = $dom -> createElement('name');  $price = $dom -> createElement('price');  $number = $dom -> createElement('number');  //創建文本節點  $name_txt = $dom -> createTextNode($info[$i]['goods_name']);  $price_txt = $dom -> createTextNode($info[$i]['goods_price']);  $number_txt = $dom -> createTextNode($info[$i]['goods_number']);  //追加節點  $name -> appendChild($name_txt);  $price -> appendChild($price_txt);  $number -> appendChild($number_txt);  $goods -> appendChild($name);  $goods -> appendChild($price);  $goods -> appendChild($number);  $shop -> appendChild($goods);}$dom -> appendChild($shop);//追加根節點header("content-type:text/xml;charset=utf-8");echo $dom -> saveXML();