PHP创建XML接口示例_php技巧_

 ......  */ $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 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();