php最簡單的產生xml文檔執行個體教程

<?php
 
 mysql教程_connect('localhost','root','1******') or die('database server no exists!');
 mysql_select_db('wk') or die('database error!'); 
 mysql_query("SET NAMES 'gbk'");//set document charset encode

 
 function CreateXml(){
  $tag  =0;
  $head ='<?xml version="1.0" encoding="gb2312" ?> <channel>';  
  $sql  ="Select * from wk_works order by id desc";

 

  $res  =mysql_query($sql) or die(mysql_error());
     while($rs =mysql_fetch_array($res) ){
      if($tag==0){
     $stp = "<item class="".$rs['w_type']."" uid="".$rs['m_id']."" name="".$this->get_name($rs['m_id'])."" portrait="".$rs['w_head']."" blogname = "".$rs['blogname']."" url="user.php?id=".$rs['m_id']."" poll = "".$rs['w_support']."" ></item>";
    }else{

 

     $stp.= "<item class="".$rs['w_type']."" uid="".$rs['m_id']."" name="".$this->get_name($rs['m_id'])."" portrait="".$rs['w_head']."" blogname = "".$rs['blogname']."" url="user.php?id=".$rs['m_id']."" poll = "".$rs['w_support']."" ></item>";   
    }

    $tag++;
     }
  $foot ='</channel>';
  $cont =fopen("xml/111cn.net.xml",'w');
  fwrite($cont,$head.$stp.$foot);
  fclose($cont);
 }
 
 function get_name($id){
  $sqle ="select id,m_uid from wk_member where id='$id'";
  $relt = mysql_query($sqle);
  $reus = mysql_fetch_array($relt);
  return $reus['m_uid'];
 }
?>

 

本站原創轉載註明: www.111cn.net