连接数据库
数据表如下
建立Feed.PHP文件
<?PHP /* 连接数据库,动态生成RSS Feed 连接数据库 取最新的10条,输出xml */ class Feed{ public $title='';//channel的title public $link='';//channel的link public $description='';//channel的description public $items=array(); public $template='./Feed.xml';//xml模板 protected $RSS=null; protected $dom=null; public function __construct(){ $this->dom=new DomDocument('1.0','utf-8'); $this->dom->load($this->template); $this->RSS=$this->dom->getElementsByTagName('RSS')->item(0); } //调用createItem,把所有的Item节点都生成,再输出 public function display(){ $this->createChannel(); $this->addItem($this->items); header('content-type:text/xml'); echo $this->dom->savexml(); } //封装createChannel方法,用来创建RSS的channel节点 protected function createChannel(){ $channel=$this->dom->createElement('channel'); $channel->appendChild($this->createEle('title',$this->title)); $channel->appendChild($this->createEle('link',$this->link)); $channel->appendChild($this->createEle('description',$this->description)); $this->RSS->appendChild($channel); } //封装一个方法,用来造item protected function createItem($arr){ $item=$this->dom->createElement('item'); foreach($arr as $k=>$v){ $item->appendChild($this->createEle($k,$v)); } return $item; } //封装addItem方法,把所有的商品增加到RSS里面去 //$list是商品列表,是二维数组 protected function addItem($list){ foreach($list as $goods){ $this->RSS->appendChild($this->createItem($goods)); //$this->RSS->appendChild($this->createItem($list)); } } //封装一个方法,直接创建如<ele>some text</ele>这样的节点 protected function createEle($name,$value){ $ele=$this->dom->createElement($name); $text=$this->dom->createTextNode($value); $ele->appendChild($text); return $ele; } } $conn=MysqL_connect('localhost','root','19900801'); MysqL_query('set names utf8',$conn); MysqL_query('use test'); $rs=MysqL_query('select dealer as title,price as description from shop'); $list=array(); while($row=MysqL_fetch_assoc($rs)){ $list[]=$row; } /* echo "<pre>"; print_r($list); echo "</pre>"; */ $Feed=new Feed(); $Feed->title='商城'; $Feed->link='http://localhost/bool'; $Feed->description='这是优惠信息的集合'; $Feed->items=$list; $Feed->display(); ?>最后效果