PHP创建XML接口示例

<?php
header("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();